mcAfee Secure Website
23

Microsoft DP-300 Bundle

Exam Code: DP-300

Exam Name Administering Microsoft Azure SQL Solutions

Certification Provider: Microsoft

Corresponding Certification: Microsoft Certified: Azure Database Administrator Associate

DP-300 Training Materials $44.99

Reliable & Actual Study Materials for DP-300 Exam Success

The Latest DP-300 Exam Questions as Experienced in the Actual Test!

  • 24
    Questions & Answers

    DP-300 Questions & Answers

    470 Questions & Answers

    Includes questions types found on actual exam such as drag and drop, simulation, type in, and fill in the blank.

  • 25
    DP-300 Video Course

    DP-300 Training Course

    130 Video Lectures

    Based on Real Life Scenarios which you will encounter in exam and learn by working with real equipment.

  • exam =30
    Study Guide

    DP-300 Study Guide

    672 PDF Pages

    Study Guide developed by industry experts who have written exams in the past. They are technology-specific IT certification researchers with at least a decade of experience at Fortune 500 companies.

exam =32

Administering Microsoft Azure SQL Solutions (DP-300) Practice Tests

Guarantee

Satisfaction Guaranteed

Pass4sure has a remarkable Microsoft Candidate Success record. We're confident of our products and provide no hassle product exchange. That's how confident we are!

99.3% Pass Rate
Total Cost: $194.97
Bundle Price: $149.98

Purchase Individually

  • exam =34
    Questions & Answers

    Questions & Answers

    470 Questions

    $124.99
    exam =35
  • exam =37
    DP-300 Video Course

    Training Course

    130 Video Lectures

    $39.99
  • exam =36
    Study Guide

    Study Guide

    672 PDF Pages

    $29.99

Microsoft DP-300 Practice Test 23

Question 220

An Azure SQL operations team investigates: A network engineer opens broad public firewall rules in response to a database permission-denied error. Select TWO complementary answers: the targeted corrective action AND the evidence that verifies it.

  1. Separate network reachability, token validity, tenant identity, database mapping and SQL permission problems when troubleshooting failed authentication.
  2. Inside-VNet DNS resolves the intended private endpoint, allowed clients connect and prohibited public access fails.
  3. Connection logs and controlled tests identify whether the failure occurs at network, authentication or authorization stage.
  4. Evaluate Always Encrypted with secure enclaves for supported encrypted-column operations that require enclave-supported computations and key configuration.
  5. Maintain SQL login configuration and password policy appropriately on SQL Server installations that support SQL authentication and coordinate with directory alternatives.

Explanation

Correct Answers

A:

The reported Azure SQL or SQL Server condition is: A network engineer opens broad public firewall rules in response to a database permission-denied error. The specific supported administrative response is: Separate network reachability, token validity, tenant identity, database mapping and SQL permission problems when troubleshooting failed authentication. The technical risk is: Treating every database error as a firewall block can conceal authentication and access-control faults. Confirm the correction with: Connection logs and controlled tests identify whether the failure occurs at network, authentication or authorization stage.

C:

The acceptance evidence for this incident (A network engineer opens broad public firewall rules in response to a database permission-denied error.) is: Connection logs and controlled tests identify whether the failure occurs at network, authentication or authorization stage. It directly tests whether the remediation (Separate network reachability, token validity, tenant identity, database mapping and SQL permission problems when troubleshooting failed authentication.) solves the specified issue, instead of proving an unrelated database control works.

Incorrect Answers

B:

Azure SQL private endpoints and public exposure (2.2) would demonstrate or implement: Inside-VNet DNS resolves the intended private endpoint, allowed clients connect and prohibited public access fails. This choice can be useful for that problem, but it does not establish the Diagnosing login and token failures (2.1) control being assessed here.

D:

Always encrypted secure enclave workloads (2.2) addresses another technical failure: Assuming all encrypted-column operations work without enclave support can cause unsupported queries or unexpected decryption behavior. The required paired action and test concerns Diagnosing login and token failures (2.1); a passing result for this alternative could leave that requirement unresolved.

E:

SQL authentication management on SQL server vms (2.1) addresses another technical failure: Poorly governed shared SQL logins are hard to rotate and can bypass centralized identity lifecycle management. The paired-answer requirement concerns Diagnosing login and token failures (2.1); this alternative does not provide the matching intervention and separate acceptance evidence.

Question 221

An Azure database administrator observes: A support role must execute one procedure in an operations schema and nothing else. Which action best addresses the specific technical requirement?

  1. Use schema ownership, object-level GRANT, DENY and appropriate role membership to control SQL access consistently.
  2. Require supported TLS encryption, valid certificates and client hostname validation for database network connections.
  3. Configure a supported Microsoft Entra administrator and tenant identity prerequisites before enabling Entra-based SQL principals and sign-in.
  4. Apply Azure SQL server-level or database-level firewall controls with least-privilege source ranges and verify interaction with network access policy.

Explanation

Correct Answer

A:

The reported Azure SQL or SQL Server condition is: A support role must execute one procedure in an operations schema and nothing else. The specific supported administrative response is: Use schema ownership, object-level GRANT, DENY and appropriate role membership to control SQL access consistently. The technical risk is: Granting broad table permissions for a narrow reporting requirement can expose unrelated sensitive objects. Confirm the correction with: Database effective-permission tests confirm view and procedure access while disallowed base-table operations fail.

Incorrect Answers

B:

SQL encrypted connections and TLS verification (2.2) addresses another technical failure: Unvalidated or unencrypted database transport can expose credentials or data to interception and server impersonation. This choice can be useful for that problem, but it does not establish the Database object ownership and schema authorization (2.1) control being assessed here.

C:

Microsoft entra administrator for azure SQL (2.1) addresses another technical failure: Without correct tenant mapping and directory administration, intended Entra accounts cannot be provisioned for database access. This case instead tests Database object ownership and schema authorization (2.1); the choice measures or changes another part of the system.

D:

Azure SQL firewall rule scoping (2.2) addresses another technical failure: Allowing every public Azure IP or all internet clients to connect widens access to the SQL endpoint unnecessarily. The required corrective action concerns Database object ownership and schema authorization (2.1); a passing result for this alternative could leave that requirement unresolved.

Question 222

During post-change validation, the team reports: A support role must execute one procedure in an operations schema and nothing else. Which observation best demonstrates that the appropriate correction worked?

  1. An authorized Entra identity can authenticate and create the intended supported contained database principal without a shared SQL password.
  2. Approved source clients can connect through expected network paths and unauthorized test addresses are rejected.
  3. Database effective-permission tests confirm view and procedure access while disallowed base-table operations fail.
  4. An approved SQL client validates the intended server certificate and rejects an untrusted endpoint during a controlled test.

Explanation

Correct Answer

C:

The acceptance evidence for this incident (A support role must execute one procedure in an operations schema and nothing else.) is: Database effective-permission tests confirm view and procedure access while disallowed base-table operations fail. It directly tests whether the remediation (Use schema ownership, object-level GRANT, DENY and appropriate role membership to control SQL access consistently.) solves the specified issue, instead of proving an unrelated database control works.

Incorrect Answers

A:

Microsoft entra administrator for azure SQL (2.1) would demonstrate or implement: An authorized Entra identity can authenticate and create the intended supported contained database principal without a shared SQL password. The case states: A support role must execute one procedure in an operations schema and nothing else. The most direct evidence is: Database effective-permission tests confirm view and procedure access while disallowed base-table operations fail.

B:

Azure SQL firewall rule scoping (2.2) would demonstrate or implement: Approved source clients can connect through expected network paths and unauthorized test addresses are rejected. This choice can be useful for that problem, but it does not establish the Database object ownership and schema authorization (2.1) control being assessed here.

D:

SQL encrypted connections and TLS verification (2.2) would demonstrate or implement: An approved SQL client validates the intended server certificate and rejects an untrusted endpoint during a controlled test. The required evidence concerns Database object ownership and schema authorization (2.1); a passing result for this alternative could leave that requirement unresolved.

Question 223

An Azure database administrator observes: An analyst is accidentally granted UPDATE on all objects in a reporting schema. Which action best addresses the specific technical requirement?

  1. Configure a supported Microsoft Entra administrator and tenant identity prerequisites before enabling Entra-based SQL principals and sign-in.
  2. Require supported TLS encryption, valid certificates and client hostname validation for database network connections.
  3. Apply Azure SQL server-level or database-level firewall controls with least-privilege source ranges and verify interaction with network access policy.
  4. Use schema ownership, object-level GRANT, DENY and appropriate role membership to control SQL access consistently.

Explanation

Correct Answer

D:

The reported Azure SQL or SQL Server condition is: An analyst is accidentally granted UPDATE on all objects in a reporting schema. The specific supported administrative response is: Use schema ownership, object-level GRANT, DENY and appropriate role membership to control SQL access consistently. The technical risk is: Granting broad table permissions for a narrow reporting requirement can expose unrelated sensitive objects. Confirm the correction with: Database effective-permission tests confirm view and procedure access while disallowed base-table operations fail.

Incorrect Answers

A:

Microsoft entra administrator for azure SQL (2.1) addresses another technical failure: Without correct tenant mapping and directory administration, intended Entra accounts cannot be provisioned for database access. The case states: An analyst is accidentally granted UPDATE on all objects in a reporting schema. The most direct corrective action is: Use schema ownership, object-level GRANT, DENY and appropriate role membership to control SQL access consistently.

B:

SQL encrypted connections and TLS verification (2.2) addresses another technical failure: Unvalidated or unencrypted database transport can expose credentials or data to interception and server impersonation. This choice can be useful for that problem, but it does not establish the Database object ownership and schema authorization (2.1) control being assessed here.

C:

Azure SQL firewall rule scoping (2.2) addresses another technical failure: Allowing every public Azure IP or all internet clients to connect widens access to the SQL endpoint unnecessarily. This case instead tests Database object ownership and schema authorization (2.1); the choice measures or changes another part of the system.

Question 224

In a database operations review, a team encounters: An analyst is accidentally granted UPDATE on all objects in a reporting schema. Which failure or exposure is most directly relevant?

  1. Without correct tenant mapping and directory administration, intended Entra accounts cannot be provisioned for database access.
  2. Granting broad table permissions for a narrow reporting requirement can expose unrelated sensitive objects.
  3. Allowing every public Azure IP or all internet clients to connect widens access to the SQL endpoint unnecessarily.
  4. Unvalidated or unencrypted database transport can expose credentials or data to interception and server impersonation.

Explanation

Correct Answer

B:

The incident (An analyst is accidentally granted UPDATE on all objects in a reporting schema.) most directly exposes: Granting broad table permissions for a narrow reporting requirement can expose unrelated sensitive objects. The resulting safe technical response is: Use schema ownership, object-level GRANT, DENY and appropriate role membership to control SQL access consistently. Its verification is: Database effective-permission tests confirm view and procedure access while disallowed base-table operations fail.

Incorrect Answers

A:

Microsoft entra administrator for azure SQL (2.1) would demonstrate or implement: Without correct tenant mapping and directory administration, intended Entra accounts cannot be provisioned for database access. The case states: An analyst is accidentally granted UPDATE on all objects in a reporting schema. The most direct risk is: Granting broad table permissions for a narrow reporting requirement can expose unrelated sensitive objects.

C:

Azure SQL firewall rule scoping (2.2) would demonstrate or implement: Allowing every public Azure IP or all internet clients to connect widens access to the SQL endpoint unnecessarily. This case instead tests Database object ownership and schema authorization (2.1); the choice measures or changes another part of the system.

D:

SQL encrypted connections and TLS verification (2.2) would demonstrate or implement: Unvalidated or unencrypted database transport can expose credentials or data to interception and server impersonation. The required risk concerns Database object ownership and schema authorization (2.1); a passing result for this alternative could leave that requirement unresolved.

Question 225

An Azure database administrator observes: A schema ownership change causes a previously working stored procedure chain to fail. Which action best addresses the specific technical requirement?

  1. Apply Azure SQL server-level or database-level firewall controls with least-privilege source ranges and verify interaction with network access policy.
  2. Use schema ownership, object-level GRANT, DENY and appropriate role membership to control SQL access consistently.
  3. Require supported TLS encryption, valid certificates and client hostname validation for database network connections.
  4. Configure a supported Microsoft Entra administrator and tenant identity prerequisites before enabling Entra-based SQL principals and sign-in.

Explanation

Correct Answer

B:

The reported Azure SQL or SQL Server condition is: A schema ownership change causes a previously working stored procedure chain to fail. The specific supported administrative response is: Use schema ownership, object-level GRANT, DENY and appropriate role membership to control SQL access consistently. The technical risk is: Granting broad table permissions for a narrow reporting requirement can expose unrelated sensitive objects. Confirm the correction with: Database effective-permission tests confirm view and procedure access while disallowed base-table operations fail.

Incorrect Answers

A:

Azure SQL firewall rule scoping (2.2) addresses another technical failure: Allowing every public Azure IP or all internet clients to connect widens access to the SQL endpoint unnecessarily. The case states: A schema ownership change causes a previously working stored procedure chain to fail. The most direct corrective action is: Use schema ownership, object-level GRANT, DENY and appropriate role membership to control SQL access consistently.

C:

SQL encrypted connections and TLS verification (2.2) addresses another technical failure: Unvalidated or unencrypted database transport can expose credentials or data to interception and server impersonation. This case instead tests Database object ownership and schema authorization (2.1); the choice measures or changes another part of the system.

D:

Microsoft entra administrator for azure SQL (2.1) addresses another technical failure: Without correct tenant mapping and directory administration, intended Entra accounts cannot be provisioned for database access. The required corrective action concerns Database object ownership and schema authorization (2.1); a passing result for this alternative could leave that requirement unresolved.

Question 226

During post-change validation, the team reports: A schema ownership change causes a previously working stored procedure chain to fail. Which observation best demonstrates that the appropriate correction worked?

  1. Approved source clients can connect through expected network paths and unauthorized test addresses are rejected.
  2. An approved SQL client validates the intended server certificate and rejects an untrusted endpoint during a controlled test.
  3. Database effective-permission tests confirm view and procedure access while disallowed base-table operations fail.
  4. An authorized Entra identity can authenticate and create the intended supported contained database principal without a shared SQL password.

Explanation

Correct Answer

C:

The acceptance evidence for this incident (A schema ownership change causes a previously working stored procedure chain to fail.) is: Database effective-permission tests confirm view and procedure access while disallowed base-table operations fail. It directly tests whether the remediation (Use schema ownership, object-level GRANT, DENY and appropriate role membership to control SQL access consistently.) solves the specified issue, instead of proving an unrelated database control works.

Incorrect Answers

A:

Azure SQL firewall rule scoping (2.2) would demonstrate or implement: Approved source clients can connect through expected network paths and unauthorized test addresses are rejected. The case states: A schema ownership change causes a previously working stored procedure chain to fail. The most direct evidence is: Database effective-permission tests confirm view and procedure access while disallowed base-table operations fail.

B:

SQL encrypted connections and TLS verification (2.2) would demonstrate or implement: An approved SQL client validates the intended server certificate and rejects an untrusted endpoint during a controlled test. This choice can be useful for that problem, but it does not establish the Database object ownership and schema authorization (2.1) control being assessed here.

D:

Microsoft entra administrator for azure SQL (2.1) would demonstrate or implement: An authorized Entra identity can authenticate and create the intended supported contained database principal without a shared SQL password. The required evidence concerns Database object ownership and schema authorization (2.1); a passing result for this alternative could leave that requirement unresolved.

Question 227

An Azure database administrator observes: An application role needs SELECT on one view while its underlying sensitive table should remain protected. Which action best addresses the specific technical requirement?

  1. Use schema ownership, object-level GRANT, DENY and appropriate role membership to control SQL access consistently.
  2. Require supported TLS encryption, valid certificates and client hostname validation for database network connections.
  3. Configure a supported Microsoft Entra administrator and tenant identity prerequisites before enabling Entra-based SQL principals and sign-in.
  4. Apply Azure SQL server-level or database-level firewall controls with least-privilege source ranges and verify interaction with network access policy.

Explanation

Correct Answer

A:

The reported Azure SQL or SQL Server condition is: An application role needs SELECT on one view while its underlying sensitive table should remain protected. The specific supported administrative response is: Use schema ownership, object-level GRANT, DENY and appropriate role membership to control SQL access consistently. The technical risk is: Granting broad table permissions for a narrow reporting requirement can expose unrelated sensitive objects. Confirm the correction with: Database effective-permission tests confirm view and procedure access while disallowed base-table operations fail.

Incorrect Answers

B:

SQL encrypted connections and TLS verification (2.2) addresses another technical failure: Unvalidated or unencrypted database transport can expose credentials or data to interception and server impersonation. This choice can be useful for that problem, but it does not establish the Database object ownership and schema authorization (2.1) control being assessed here.

C:

Microsoft entra administrator for azure SQL (2.1) addresses another technical failure: Without correct tenant mapping and directory administration, intended Entra accounts cannot be provisioned for database access. This case instead tests Database object ownership and schema authorization (2.1); the choice measures or changes another part of the system.

D:

Azure SQL firewall rule scoping (2.2) addresses another technical failure: Allowing every public Azure IP or all internet clients to connect widens access to the SQL endpoint unnecessarily. The required corrective action concerns Database object ownership and schema authorization (2.1); a passing result for this alternative could leave that requirement unresolved.

Question 228

In a database operations review, a team encounters: An application role needs SELECT on one view while its underlying sensitive table should remain protected. Which failure or exposure is most directly relevant?

  1. Without correct tenant mapping and directory administration, intended Entra accounts cannot be provisioned for database access.
  2. Allowing every public Azure IP or all internet clients to connect widens access to the SQL endpoint unnecessarily.
  3. Unvalidated or unencrypted database transport can expose credentials or data to interception and server impersonation.
  4. Granting broad table permissions for a narrow reporting requirement can expose unrelated sensitive objects.

Explanation

Correct Answer

D:

The incident (An application role needs SELECT on one view while its underlying sensitive table should remain protected.) most directly exposes: Granting broad table permissions for a narrow reporting requirement can expose unrelated sensitive objects. The resulting safe technical response is: Use schema ownership, object-level GRANT, DENY and appropriate role membership to control SQL access consistently. Its verification is: Database effective-permission tests confirm view and procedure access while disallowed base-table operations fail.

Incorrect Answers

A:

Microsoft entra administrator for azure SQL (2.1) would demonstrate or implement: Without correct tenant mapping and directory administration, intended Entra accounts cannot be provisioned for database access. The case states: An application role needs SELECT on one view while its underlying sensitive table should remain protected. The most direct risk is: Granting broad table permissions for a narrow reporting requirement can expose unrelated sensitive objects.

B:

Azure SQL firewall rule scoping (2.2) would demonstrate or implement: Allowing every public Azure IP or all internet clients to connect widens access to the SQL endpoint unnecessarily. This choice can be useful for that problem, but it does not establish the Database object ownership and schema authorization (2.1) control being assessed here.

C:

SQL encrypted connections and TLS verification (2.2) would demonstrate or implement: Unvalidated or unencrypted database transport can expose credentials or data to interception and server impersonation. This case instead tests Database object ownership and schema authorization (2.1); the choice measures or changes another part of the system.

Question 229

An Azure database administrator observes: A database user has overlapping role grants and DENY permissions that require effective access analysis. Which action best addresses the specific technical requirement?

  1. Apply Azure SQL server-level or database-level firewall controls with least-privilege source ranges and verify interaction with network access policy.
  2. Require supported TLS encryption, valid certificates and client hostname validation for database network connections.
  3. Use schema ownership, object-level GRANT, DENY and appropriate role membership to control SQL access consistently.
  4. Configure a supported Microsoft Entra administrator and tenant identity prerequisites before enabling Entra-based SQL principals and sign-in.

Explanation

Correct Answer

C:

The reported Azure SQL or SQL Server condition is: A database user has overlapping role grants and DENY permissions that require effective access analysis. The specific supported administrative response is: Use schema ownership, object-level GRANT, DENY and appropriate role membership to control SQL access consistently. The technical risk is: Granting broad table permissions for a narrow reporting requirement can expose unrelated sensitive objects. Confirm the correction with: Database effective-permission tests confirm view and procedure access while disallowed base-table operations fail.

Incorrect Answers

A:

Azure SQL firewall rule scoping (2.2) addresses another technical failure: Allowing every public Azure IP or all internet clients to connect widens access to the SQL endpoint unnecessarily. The case states: A database user has overlapping role grants and DENY permissions that require effective access analysis. The most direct corrective action is: Use schema ownership, object-level GRANT, DENY and appropriate role membership to control SQL access consistently.

B:

SQL encrypted connections and TLS verification (2.2) addresses another technical failure: Unvalidated or unencrypted database transport can expose credentials or data to interception and server impersonation. This choice can be useful for that problem, but it does not establish the Database object ownership and schema authorization (2.1) control being assessed here.

D:

Microsoft entra administrator for azure SQL (2.1) addresses another technical failure: Without correct tenant mapping and directory administration, intended Entra accounts cannot be provisioned for database access. The required corrective action concerns Database object ownership and schema authorization (2.1); a passing result for this alternative could leave that requirement unresolved.

Question 230

An Azure SQL operations team investigates: A database user has overlapping role grants and DENY permissions that require effective access analysis. Select TWO complementary answers: the targeted corrective action AND the evidence that verifies it.

  1. Apply Azure SQL server-level or database-level firewall controls with least-privilege source ranges and verify interaction with network access policy.
  2. Use schema ownership, object-level GRANT, DENY and appropriate role membership to control SQL access consistently.
  3. Configure a supported Microsoft Entra administrator and tenant identity prerequisites before enabling Entra-based SQL principals and sign-in.
  4. An approved SQL client validates the intended server certificate and rejects an untrusted endpoint during a controlled test.
  5. Database effective-permission tests confirm view and procedure access while disallowed base-table operations fail.

Explanation

Correct Answers

B:

The reported Azure SQL or SQL Server condition is: A database user has overlapping role grants and DENY permissions that require effective access analysis. The specific supported administrative response is: Use schema ownership, object-level GRANT, DENY and appropriate role membership to control SQL access consistently. The technical risk is: Granting broad table permissions for a narrow reporting requirement can expose unrelated sensitive objects. Confirm the correction with: Database effective-permission tests confirm view and procedure access while disallowed base-table operations fail.

E:

The acceptance evidence for this incident (A database user has overlapping role grants and DENY permissions that require effective access analysis.) is: Database effective-permission tests confirm view and procedure access while disallowed base-table operations fail. It directly tests whether the remediation (Use schema ownership, object-level GRANT, DENY and appropriate role membership to control SQL access consistently.) solves the specified issue, instead of proving an unrelated database control works.

Incorrect Answers

A:

Azure SQL firewall rule scoping (2.2) addresses another technical failure: Allowing every public Azure IP or all internet clients to connect widens access to the SQL endpoint unnecessarily. The case states: A database user has overlapping role grants and DENY permissions that require effective access analysis. The most direct paired action and test is: Use schema ownership, object-level GRANT, DENY and appropriate role membership to control SQL access consistently.

C:

Microsoft entra administrator for azure SQL (2.1) addresses another technical failure: Without correct tenant mapping and directory administration, intended Entra accounts cannot be provisioned for database access. This case instead tests Database object ownership and schema authorization (2.1); the choice measures or changes another part of the system.

D:

SQL encrypted connections and TLS verification (2.2) would demonstrate or implement: An approved SQL client validates the intended server certificate and rejects an untrusted endpoint during a controlled test. The required paired action and test concerns Database object ownership and schema authorization (2.1); a passing result for this alternative could leave that requirement unresolved.