Microsoft DP-300 Exam Dumps, Practice Test Questions

100% Latest & Updated Microsoft DP-300 Practice Test Questions, Exam Dumps & Verified Answers!
30 Days Free Updates, Instant Download!

Microsoft DP-300 Premium Bundle
$79.97
$59.98

DP-300 Premium Bundle

  • Premium File: 470 Questions & Answers. Last update: Nov 5, 2026
  • Training Course: 130 Video Lectures
  • Study Guide: 672 Pages
  • Latest Questions
  • 100% Accurate Answers
  • Fast Exam Updates

DP-300 Premium Bundle

Microsoft DP-300 Premium Bundle
  • Premium File: 470 Questions & Answers. Last update: Nov 5, 2026
  • Training Course: 130 Video Lectures
  • Study Guide: 672 Pages
  • Latest Questions
  • 100% Accurate Answers
  • Fast Exam Updates
$79.97
$59.98

Microsoft DP-300 Practice Test 16

Question 150

Three independently confirmed SQL platform issues require separate evidence checks. Case A: A managed identity reaches the SQL endpoint but a connection fails due to the wrong database principal or requested scope. Case B: A stored procedure works for its owner but fails on a permission check for an ordinary application user. Case C: An Azure SQL logical server requires central identity administration before Microsoft Entra database accounts can be provisioned. Select exactly THREE distinct diagnostic checks, one for each case.

  1. Connection error identity claim database name and principal mapping
  2. Microsoft Entra group membership mapped to database role membership
  3. EXECUTE AS USER or effective permissions test and failed statement context
  4. sys.database_role_members and effective SELECT privileges on the reporting view
  5. sys.database_principals and relevant server-level principal inventory
  6. Logical-server Microsoft Entra administrator configuration and successful token-based sign-in

Explanation

Correct Answers

A:

Connection error identity claim database name and principal mapping directly tests the observation that a managed identity reaches the SQL endpoint but a connection fails due to the wrong database principal or requested scope. It helps the team evaluate whether it should validate the acquired token's resource and mapped database user privileges. The check has a boundary: Adding firewall access does not repair an incorrect database principal mapping.

C:

EXECUTE AS USER or effective permissions test and failed statement context directly tests the observation that a stored procedure works for its owner but fails on a permission check for an ordinary application user. It helps the team evaluate whether it should reproduce the statement under the calling principal's security context. The check has a boundary: Using the dbo context can hide access weaknesses seen by normal users.

F:

Logical-server Microsoft Entra administrator configuration and successful token-based sign-in directly tests the observation that an Azure SQL logical server requires central identity administration before Microsoft Entra database accounts can be provisioned. It helps the team evaluate whether it should configure an appropriate Microsoft Entra administrator for the Azure SQL resource. The check has a boundary: An Entra administrator does not make every directory user a database reader automatically.

Incorrect Answers

B:

Microsoft Entra group membership mapped to database role membership is appropriate for the separate condition that several engineers need identical read-only data access without individually maintained GRANT statements. The actual 3 cases are A: A managed identity reaches the SQL endpoint but a connection fails due to the wrong database principal or requested scope; B: A stored procedure works for its owner but fails on a permission check for an ordinary application user; C: An Azure SQL logical server requires central identity administration before Microsoft Entra database accounts can be provisioned. This option is not the specific diagnostic evidence for any of those stated cases.

D:

sys.database_role_members and effective SELECT privileges on the reporting view is appropriate for the separate condition that a report service must read one approved view but currently has db_owner membership. The actual 3 cases are A: A managed identity reaches the SQL endpoint but a connection fails due to the wrong database principal or requested scope; B: A stored procedure works for its owner but fails on a permission check for an ordinary application user; C: An Azure SQL logical server requires central identity administration before Microsoft Entra database accounts can be provisioned. This option is not the specific diagnostic evidence for any of those stated cases.

E:

sys.database_principals and relevant server-level principal inventory is appropriate for the separate condition that an Azure SQL Database connection uses a contained database user and administrators expect it to appear in server-level logins. The actual 3 cases are A: A managed identity reaches the SQL endpoint but a connection fails due to the wrong database principal or requested scope; B: A stored procedure works for its owner but fails on a permission check for an ordinary application user; C: An Azure SQL logical server requires central identity administration before Microsoft Entra database accounts can be provisioned. This option is not the specific diagnostic evidence for any of those stated cases.

Question 151

The security and reliability review asks what can still go wrong when: A developer claims SELECT access but DENY and inherited role memberships produce an unexpected effective permission. Which important limitation must be considered before approving the solution?

  1. Adding firewall access does not repair an incorrect database principal mapping
  2. Password-only SQL authentication does not supply Microsoft Entra conditional access
  3. A DENY can override a GRANT and exceptions depend on security context
  4. An Entra administrator does not make every directory user a database reader automatically

Explanation

Correct Answer

C:

A DENY can override a GRANT and exceptions depend on security context is a material limit for role and permission audit when a developer claims SELECT access but DENY and inherited role memberships produce an unexpected effective permission. The engineer should first inspect explicit GRANT DENY and role inheritance for the exact securable and verify relevant dependencies rather than promise unlimited coverage.

Incorrect Answers

A:

Adding firewall access does not repair an incorrect database principal mapping applies when a managed identity reaches the SQL endpoint but a connection fails due to the wrong database principal or requested scope, not when a developer claims SELECT access but DENY and inherited role memberships produce an unexpected effective permission.

B:

Password-only SQL authentication does not supply Microsoft Entra conditional access applies when a legacy SQL application uses password credentials that need controlled rotation and secure storage, not when a developer claims SELECT access but DENY and inherited role memberships produce an unexpected effective permission.

D:

An Entra administrator does not make every directory user a database reader automatically applies when an Azure SQL logical server requires central identity administration before Microsoft Entra database accounts can be provisioned, not when a developer claims SELECT access but DENY and inherited role memberships produce an unexpected effective permission.

Question 152

A reviewer asks for a caveat before signing off this proposed arrangement: A legacy SQL application uses password credentials that need controlled rotation and secure storage. Which important limitation must be considered before approving the solution?

  1. Password-only SQL authentication does not supply Microsoft Entra conditional access
  2. Directory group membership changes and existing sessions may affect effective access timing
  3. A DENY can override a GRANT and exceptions depend on security context
  4. View ownership chaining and underlying security context should still be reviewed

Explanation

Correct Answer

A:

Password-only SQL authentication does not supply Microsoft Entra conditional access is a material limit for sql authentication policy when a legacy SQL application uses password credentials that need controlled rotation and secure storage. The engineer should first apply least-privileged SQL credentials with managed secret rotation where required and verify relevant dependencies rather than promise unlimited coverage.

Incorrect Answers

B:

Directory group membership changes and existing sessions may affect effective access timing applies when several engineers need identical read-only data access without individually maintained GRANT statements, not when a legacy SQL application uses password credentials that need controlled rotation and secure storage.

C:

A DENY can override a GRANT and exceptions depend on security context applies when a developer claims SELECT access but DENY and inherited role memberships produce an unexpected effective permission, not when a legacy SQL application uses password credentials that need controlled rotation and secure storage.

D:

View ownership chaining and underlying security context should still be reviewed applies when a report service must read one approved view but currently has db_owner membership, not when a legacy SQL application uses password credentials that need controlled rotation and secure storage.

Question 153

A database architecture review reports the following requirement: A regulator requires database files transaction logs and backups to be encrypted at rest without modifying SQL queries. Which Azure SQL service or administration concept most precisely fits this situation?

  1. Always Encrypted secure enclave
  2. Transparent Data Encryption at rest
  3. Always Encrypted sensitive column
  4. SQL logical server firewall

Explanation

Correct Answer

B:

Transparent Data Encryption at rest matches the precise requirement: a regulator requires database files transaction logs and backups to be encrypted at rest without modifying SQL queries. Storage-level database data is encrypted without changing SQL application statements. Important scope limit: TDE does not conceal plaintext from users who have query access.

Incorrect Answers

A:

Always Encrypted secure enclave applies when a sensitive encrypted column needs supported server-side computations without exposing general plaintext to SQL administrators, not when a regulator requires database files transaction logs and backups to be encrypted at rest without modifying SQL queries.

C:

Always Encrypted sensitive column applies when a payroll application must prevent database administrators from reading salary plaintext while the client retains decryption keys, not when a regulator requires database files transaction logs and backups to be encrypted at rest without modifying SQL queries.

D:

SQL logical server firewall applies when a test system can use the correct SQL credentials but its current source IP is blocked by Azure SQL firewall policy, not when a regulator requires database files transaction logs and backups to be encrypted at rest without modifying SQL queries.

Question 154

A Microsoft Azure SQL solution proposal begins with this condition: A payroll application must prevent database administrators from reading salary plaintext while the client retains decryption keys. Which Azure SQL service or administration concept most precisely fits this situation?

  1. Customer-managed TDE protector
  2. Always Encrypted sensitive column
  3. SQL logical server firewall
  4. Private endpoint for Azure SQL

Explanation

Correct Answer

B:

Always Encrypted sensitive column matches the precise requirement: a payroll application must prevent database administrators from reading salary plaintext while the client retains decryption keys. Column plaintext can remain inaccessible to the database engine for supported operations. Important scope limit: Unsupported predicates and application driver requirements must be evaluated.

Incorrect Answers

A:

Customer-managed TDE protector applies when a regulated Azure SQL deployment requires customer control over the database encryption key lifecycle, not when a payroll application must prevent database administrators from reading salary plaintext while the client retains decryption keys.

C:

SQL logical server firewall applies when a test system can use the correct SQL credentials but its current source IP is blocked by Azure SQL firewall policy, not when a payroll application must prevent database administrators from reading salary plaintext while the client retains decryption keys.

D:

Private endpoint for Azure SQL applies when a finance database must be reached through approved VNet private IP connectivity rather than an exposed public endpoint, not when a payroll application must prevent database administrators from reading salary plaintext while the client retains decryption keys.

Question 155

The data platform team is assessing this situation: A sensitive encrypted column needs supported server-side computations without exposing general plaintext to SQL administrators. Which Azure SQL service or administration concept most precisely fits this situation?

  1. SQL logical server firewall
  2. Customer-managed TDE protector
  3. Cell or object level encryption
  4. Always Encrypted secure enclave

Explanation

Correct Answer

D:

Always Encrypted secure enclave matches the precise requirement: a sensitive encrypted column needs supported server-side computations without exposing general plaintext to SQL administrators. Supported confidential computations become possible over protected columns. Important scope limit: Enclave support requires compatible clients and hosting; the attestation requirement varies by enclave type.

Incorrect Answers

A:

SQL logical server firewall applies when a test system can use the correct SQL credentials but its current source IP is blocked by Azure SQL firewall policy, not when a sensitive encrypted column needs supported server-side computations without exposing general plaintext to SQL administrators.

B:

Customer-managed TDE protector applies when a regulated Azure SQL deployment requires customer control over the database encryption key lifecycle, not when a sensitive encrypted column needs supported server-side computations without exposing general plaintext to SQL administrators.

C:

Cell or object level encryption applies when only one legacy sensitive attribute needs an application-controlled encryption path rather than whole-database disk protection, not when a sensitive encrypted column needs supported server-side computations without exposing general plaintext to SQL administrators.

Question 156

A database architecture review reports the following requirement: A finance database must be reached through approved VNet private IP connectivity rather than an exposed public endpoint. Which Azure SQL service or administration concept most precisely fits this situation?

  1. Private endpoint for Azure SQL
  2. Always Encrypted key protection
  3. SQL logical server firewall
  4. Cell or object level encryption

Explanation

Correct Answer

A:

Private endpoint for Azure SQL matches the precise requirement: a finance database must be reached through approved VNet private IP connectivity rather than an exposed public endpoint. Clients can route to the SQL service through the private address. Important scope limit: Creating a private endpoint does not automatically disable public network access.

Incorrect Answers

B:

Always Encrypted key protection applies when a team wants column master key operations separated from database administration and stored in a key vault, not when a finance database must be reached through approved VNet private IP connectivity rather than an exposed public endpoint.

C:

SQL logical server firewall applies when a test system can use the correct SQL credentials but its current source IP is blocked by Azure SQL firewall policy, not when a finance database must be reached through approved VNet private IP connectivity rather than an exposed public endpoint.

D:

Cell or object level encryption applies when only one legacy sensitive attribute needs an application-controlled encryption path rather than whole-database disk protection, not when a finance database must be reached through approved VNet private IP connectivity rather than an exposed public endpoint.

Question 157

A Microsoft Azure SQL solution proposal begins with this condition: A test system can use the correct SQL credentials but its current source IP is blocked by Azure SQL firewall policy. Which Azure SQL service or administration concept most precisely fits this situation?

  1. Always Encrypted key protection
  2. SQL logical server firewall
  3. Private endpoint for Azure SQL
  4. TLS encryption in transit

Explanation

Correct Answer

B:

SQL logical server firewall matches the precise requirement: a test system can use the correct SQL credentials but its current source IP is blocked by Azure SQL firewall policy. Eligible clients can establish network connections to the SQL service. Important scope limit: An open firewall path does not grant database login or object access.

Incorrect Answers

A:

Always Encrypted key protection applies when a team wants column master key operations separated from database administration and stored in a key vault, not when a test system can use the correct SQL credentials but its current source IP is blocked by Azure SQL firewall policy.

C:

Private endpoint for Azure SQL applies when a finance database must be reached through approved VNet private IP connectivity rather than an exposed public endpoint, not when a test system can use the correct SQL credentials but its current source IP is blocked by Azure SQL firewall policy.

D:

TLS encryption in transit applies when a security scan detects a SQL client using insecure transport despite encryption-at-rest controls, not when a test system can use the correct SQL credentials but its current source IP is blocked by Azure SQL firewall policy.

Question 158

The data platform team is assessing this situation: A security scan detects a SQL client using insecure transport despite encryption-at-rest controls. Which Azure SQL service or administration concept most precisely fits this situation?

  1. SQL logical server firewall
  2. Private endpoint for Azure SQL
  3. Customer-managed TDE protector
  4. TLS encryption in transit

Explanation

Correct Answer

D:

TLS encryption in transit matches the precise requirement: a security scan detects a SQL client using insecure transport despite encryption-at-rest controls. The client-to-server database connection is protected against passive interception. Important scope limit: Encrypting files at rest alone does not secure traffic over the network.

Incorrect Answers

A:

SQL logical server firewall applies when a test system can use the correct SQL credentials but its current source IP is blocked by Azure SQL firewall policy, not when a security scan detects a SQL client using insecure transport despite encryption-at-rest controls.

B:

Private endpoint for Azure SQL applies when a finance database must be reached through approved VNet private IP connectivity rather than an exposed public endpoint, not when a security scan detects a SQL client using insecure transport despite encryption-at-rest controls.

C:

Customer-managed TDE protector applies when a regulated Azure SQL deployment requires customer control over the database encryption key lifecycle, not when a security scan detects a SQL client using insecure transport despite encryption-at-rest controls.

Question 159

Two independent Azure SQL administration tickets require separate actions. Case A: A regulated Azure SQL deployment requires customer control over the database encryption key lifecycle. Case B: A regulator requires database files transaction logs and backups to be encrypted at rest without modifying SQL queries. Select exactly TWO distinct implementation steps, one for each case.

  1. Enable or verify transparent data encryption for the database and supporting assets
  2. Choose supported object or column encryption explicitly for that attribute
  3. Apply a least-permissive logical-server or database-level firewall rule for the authorized source
  4. Configure a supported customer-managed TDE protector using Azure Key Vault
  5. Require encrypted SQL client transport with valid certificate verification

Explanation

Correct Answers

A:

Enable or verify transparent data encryption for the database and supporting assets directly resolves the reported requirement that a regulator requires database files transaction logs and backups to be encrypted at rest without modifying SQL queries. Storage-level database data is encrypted without changing SQL application statements. The implementation must also respect this constraint: TDE does not conceal plaintext from users who have query access.

D:

Configure a supported customer-managed TDE protector using Azure Key Vault directly resolves the reported requirement that a regulated Azure SQL deployment requires customer control over the database encryption key lifecycle. The customer controls key rotation and access policy for the encryption protector. The implementation must also respect this constraint: Deleting or denying access to the protector can impair database availability.

Incorrect Answers

B:

Choose supported object or column encryption explicitly for that attribute is appropriate for the separate condition that only one legacy sensitive attribute needs an application-controlled encryption path rather than whole-database disk protection. The actual 2 cases are A: A regulated Azure SQL deployment requires customer control over the database encryption key lifecycle; B: A regulator requires database files transaction logs and backups to be encrypted at rest without modifying SQL queries. This option is not the specific implementation or corrective step for any of those stated cases.

C:

Apply a least-permissive logical-server or database-level firewall rule for the authorized source is appropriate for the separate condition that a test system can use the correct SQL credentials but its current source IP is blocked by Azure SQL firewall policy. The actual 2 cases are A: A regulated Azure SQL deployment requires customer control over the database encryption key lifecycle; B: A regulator requires database files transaction logs and backups to be encrypted at rest without modifying SQL queries. This option is not the specific implementation or corrective step for any of those stated cases.

E:

Require encrypted SQL client transport with valid certificate verification is appropriate for the separate condition that a security scan detects a SQL client using insecure transport despite encryption-at-rest controls. The actual 2 cases are A: A regulated Azure SQL deployment requires customer control over the database encryption key lifecycle; B: A regulator requires database files transaction logs and backups to be encrypted at rest without modifying SQL queries. This option is not the specific implementation or corrective step for any of those stated cases.

Question 160

Three independently confirmed SQL platform issues require separate evidence checks. Case A: A team wants column master key operations separated from database administration and stored in a key vault. Case B: A payroll application must prevent database administrators from reading salary plaintext while the client retains decryption keys. Case C: A sensitive encrypted column needs supported server-side computations without exposing general plaintext to SQL administrators. Select exactly THREE distinct diagnostic checks, one for each case.

  1. Secure enclave attestation settings and encrypted-column operation capability
  2. Azure SQL TDE state and protector key configuration
  3. Column encryption metadata driver support and client-side key access
  4. Private endpoint connection status and private DNS resolution to the private address
  5. Column master key metadata and Azure Key Vault permissions
  6. Azure SQL firewall rules and connection rejection code

Explanation

Correct Answers

A:

Secure enclave attestation settings and encrypted-column operation capability directly tests the observation that a sensitive encrypted column needs supported server-side computations without exposing general plaintext to SQL administrators. It helps the team evaluate whether it should configure supported Always Encrypted with secure enclaves and eligible client drivers. The check has a boundary: Enclave support requires compatible clients and hosting; the attestation requirement varies by enclave type.

C:

Column encryption metadata driver support and client-side key access directly tests the observation that a payroll application must prevent database administrators from reading salary plaintext while the client retains decryption keys. It helps the team evaluate whether it should implement Always Encrypted for the protected columns with supported client drivers. The check has a boundary: Unsupported predicates and application driver requirements must be evaluated.

E:

Column master key metadata and Azure Key Vault permissions directly tests the observation that a team wants column master key operations separated from database administration and stored in a key vault. It helps the team evaluate whether it should store supported Always Encrypted column master keys in a protected key store. The check has a boundary: Key loss or incorrect driver configuration can make encrypted values unreadable.

Incorrect Answers

B:

Azure SQL TDE state and protector key configuration is appropriate for the separate condition that a regulator requires database files transaction logs and backups to be encrypted at rest without modifying SQL queries. The actual 3 cases are A: A team wants column master key operations separated from database administration and stored in a key vault; B: A payroll application must prevent database administrators from reading salary plaintext while the client retains decryption keys; C: A sensitive encrypted column needs supported server-side computations without exposing general plaintext to SQL administrators. This option is not the specific diagnostic evidence for any of those stated cases.

D:

Private endpoint connection status and private DNS resolution to the private address is appropriate for the separate condition that a finance database must be reached through approved VNet private IP connectivity rather than an exposed public endpoint. The actual 3 cases are A: A team wants column master key operations separated from database administration and stored in a key vault; B: A payroll application must prevent database administrators from reading salary plaintext while the client retains decryption keys; C: A sensitive encrypted column needs supported server-side computations without exposing general plaintext to SQL administrators. This option is not the specific diagnostic evidence for any of those stated cases.

F:

Azure SQL firewall rules and connection rejection code is appropriate for the separate condition that a test system can use the correct SQL credentials but its current source IP is blocked by Azure SQL firewall policy. The actual 3 cases are A: A team wants column master key operations separated from database administration and stored in a key vault; B: A payroll application must prevent database administrators from reading salary plaintext while the client retains decryption keys; C: A sensitive encrypted column needs supported server-side computations without exposing general plaintext to SQL administrators. This option is not the specific diagnostic evidence for any of those stated cases.

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

UP

SPECIAL OFFER: GET 10% OFF

This is ONE TIME OFFER

ExamSnap Discount Offer
Enter Your Email Address to Receive Your 10% Off Discount Code

A confirmation link will be sent to this email address to verify your login. *We value your privacy. We will not rent or sell your email address.

Download Free Demo of VCE Exam Simulator

Experience Avanset VCE Exam Simulator for yourself.

Simply submit your e-mail address below to get started with our interactive software demo of your free trial.

Free Demo Limits: In the demo version you will be able to access only first 5 questions from exam.