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 17

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.

Question 161

The data platform team is assessing this situation: Only one legacy sensitive attribute needs an application-controlled encryption path rather than whole-database disk protection. Which Azure SQL service or administration concept most precisely fits this situation?

  1. Customer-managed TDE protector
  2. Cell or object level encryption
  3. SQL logical server firewall
  4. Private endpoint for Azure SQL

Explanation

Correct Answer

B:

Cell or object level encryption matches the precise requirement: only one legacy sensitive attribute needs an application-controlled encryption path rather than whole-database disk protection. The sensitive payload is protected at a narrower data boundary. Important scope limit: Database-level encryption alone cannot replace column confidentiality controls.

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 only one legacy sensitive attribute needs an application-controlled encryption path rather than whole-database disk protection.

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 only one legacy sensitive attribute needs an application-controlled encryption path rather than whole-database disk protection.

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 only one legacy sensitive attribute needs an application-controlled encryption path rather than whole-database disk protection.

Question 162

An operator is collecting proof for the following observation: A regulator requires database files transaction logs and backups to be encrypted at rest without modifying SQL queries. Which diagnostic artifact would most directly validate the stated condition?

  1. Private endpoint connection status and private DNS resolution to the private address
  2. Azure SQL TDE state and protector key configuration
  3. Client connection encryption setting and negotiated TLS version
  4. Column encryption metadata driver support and client-side key access

Explanation

Correct Answer

B:

Azure SQL TDE state and protector key configuration directly tests the observation that a regulator requires database files transaction logs and backups to be encrypted at rest without modifying SQL queries. It helps the team evaluate whether it should enable or verify transparent data encryption for the database and supporting assets. The check has a boundary: TDE does not conceal plaintext from users who have query access.

Incorrect Answers

A:

Private endpoint connection status and private DNS resolution to the private address applies when a finance database must be reached through approved VNet private IP connectivity rather than an exposed public endpoint, not when a regulator requires database files transaction logs and backups to be encrypted at rest without modifying SQL queries.

C:

Client connection encryption setting and negotiated TLS version applies when a security scan detects a SQL client using insecure transport despite encryption-at-rest controls, not when a regulator requires database files transaction logs and backups to be encrypted at rest without modifying SQL queries.

D:

Column encryption metadata driver support and client-side key access 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.

Question 163

During SQL troubleshooting the team must test this hypothesis: A payroll application must prevent database administrators from reading salary plaintext while the client retains decryption keys. Which diagnostic artifact would most directly validate the stated condition?

  1. Column encryption metadata driver support and client-side key access
  2. Azure SQL firewall rules and connection rejection code
  3. Azure SQL TDE state and protector key configuration
  4. Key Vault key identifier and Azure SQL TDE protector configuration

Explanation

Correct Answer

A:

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.

Incorrect Answers

B:

Azure SQL firewall rules and connection rejection code 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.

C:

Azure SQL TDE state and protector key configuration applies when a regulator requires database files transaction logs and backups to be encrypted at rest without modifying SQL queries, not when a payroll application must prevent database administrators from reading salary plaintext while the client retains decryption keys.

D:

Key Vault key identifier and Azure SQL TDE protector configuration 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.

Question 164

A production database review needs evidence of this condition: A sensitive encrypted column needs supported server-side computations without exposing general plaintext to SQL administrators. Which diagnostic artifact would most directly validate the stated condition?

  1. Key Vault key identifier and Azure SQL TDE protector configuration
  2. Column master key metadata and Azure Key Vault permissions
  3. Column encryption metadata driver support and client-side key access
  4. Secure enclave attestation settings and encrypted-column operation capability

Explanation

Correct Answer

D:

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.

Incorrect Answers

A:

Key Vault key identifier and Azure SQL TDE protector configuration 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.

B:

Column master key metadata and Azure Key Vault permissions applies when a team wants column master key operations separated from database administration and stored in a key vault, not when a sensitive encrypted column needs supported server-side computations without exposing general plaintext to SQL administrators.

C:

Column encryption metadata driver support and client-side key access applies when a payroll application must prevent database administrators from reading salary plaintext while the client retains decryption keys, not when a sensitive encrypted column needs supported server-side computations without exposing general plaintext to SQL administrators.

Question 165

An operator is collecting proof for the following observation: A finance database must be reached through approved VNet private IP connectivity rather than an exposed public endpoint. Which diagnostic artifact would most directly validate the stated condition?

  1. Azure SQL TDE state and protector key configuration
  2. Private endpoint connection status and private DNS resolution to the private address
  3. Column master key metadata and Azure Key Vault permissions
  4. Key Vault key identifier and Azure SQL TDE protector configuration

Explanation

Correct Answer

B:

Private endpoint connection status and private DNS resolution to the private address directly tests the observation that a finance database must be reached through approved VNet private IP connectivity rather than an exposed public endpoint. It helps the team evaluate whether it should configure a Private Link endpoint and private DNS integration for Azure SQL. The check has a boundary: Creating a private endpoint does not automatically disable public network access.

Incorrect Answers

A:

Azure SQL TDE state and protector key configuration applies when a regulator requires database files transaction logs and backups to be encrypted at rest without modifying SQL queries, not when a finance database must be reached through approved VNet private IP connectivity rather than an exposed public endpoint.

C:

Column master key metadata and Azure Key Vault permissions 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.

D:

Key Vault key identifier and Azure SQL TDE protector configuration applies when a regulated Azure SQL deployment requires customer control over the database encryption key lifecycle, not when a finance database must be reached through approved VNet private IP connectivity rather than an exposed public endpoint.

Question 166

During SQL troubleshooting the team must test this hypothesis: A test system can use the correct SQL credentials but its current source IP is blocked by Azure SQL firewall policy. Which diagnostic artifact would most directly validate the stated condition?

  1. Column encryption metadata driver support and client-side key access
  2. Column master key metadata and Azure Key Vault permissions
  3. Azure SQL firewall rules and connection rejection code
  4. Private endpoint connection status and private DNS resolution to the private address

Explanation

Correct Answer

C:

Azure SQL firewall rules and connection rejection code directly tests the observation that a test system can use the correct SQL credentials but its current source IP is blocked by Azure SQL firewall policy. It helps the team evaluate whether it should apply a least-permissive logical-server or database-level firewall rule for the authorized source. The check has a boundary: An open firewall path does not grant database login or object access.

Incorrect Answers

A:

Column encryption metadata driver support and client-side key access applies when a payroll application must prevent database administrators from reading salary plaintext while the client retains decryption keys, not when a test system can use the correct SQL credentials but its current source IP is blocked by Azure SQL firewall policy.

B:

Column master key metadata and Azure Key Vault permissions 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.

D:

Private endpoint connection status and private DNS resolution to the private address 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.

Question 167

A production database review needs evidence of this condition: A security scan detects a SQL client using insecure transport despite encryption-at-rest controls. Which diagnostic artifact would most directly validate the stated condition?

  1. Azure SQL firewall rules and connection rejection code
  2. Key Vault key identifier and Azure SQL TDE protector configuration
  3. Client connection encryption setting and negotiated TLS version
  4. Azure SQL TDE state and protector key configuration

Explanation

Correct Answer

C:

Client connection encryption setting and negotiated TLS version directly tests the observation that a security scan detects a SQL client using insecure transport despite encryption-at-rest controls. It helps the team evaluate whether it should require encrypted SQL client transport with valid certificate verification. The check has a boundary: Encrypting files at rest alone does not secure traffic over the network.

Incorrect Answers

A:

Azure SQL firewall rules and connection rejection code 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:

Key Vault key identifier and Azure SQL TDE protector configuration 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.

D:

Azure SQL TDE state and protector key configuration applies when a regulator requires database files transaction logs and backups to be encrypted at rest without modifying SQL queries, not when a security scan detects a SQL client using insecure transport despite encryption-at-rest controls.

Question 168

An operator is collecting proof for the following observation: A regulated Azure SQL deployment requires customer control over the database encryption key lifecycle. Which diagnostic artifact would most directly validate the stated condition?

  1. Client connection encryption setting and negotiated TLS version
  2. Column encryption metadata driver support and client-side key access
  3. Private endpoint connection status and private DNS resolution to the private address
  4. Key Vault key identifier and Azure SQL TDE protector configuration

Explanation

Correct Answer

D:

Key Vault key identifier and Azure SQL TDE protector configuration directly tests the observation that a regulated Azure SQL deployment requires customer control over the database encryption key lifecycle. It helps the team evaluate whether it should configure a supported customer-managed TDE protector using Azure Key Vault. The check has a boundary: Deleting or denying access to the protector can impair database availability.

Incorrect Answers

A:

Client connection encryption setting and negotiated TLS version applies when a security scan detects a SQL client using insecure transport despite encryption-at-rest controls, not when a regulated Azure SQL deployment requires customer control over the database encryption key lifecycle.

B:

Column encryption metadata driver support and client-side key access applies when a payroll application must prevent database administrators from reading salary plaintext while the client retains decryption keys, not when a regulated Azure SQL deployment requires customer control over the database encryption key lifecycle.

C:

Private endpoint connection status and private DNS resolution to the private address applies when a finance database must be reached through approved VNet private IP connectivity rather than an exposed public endpoint, not when a regulated Azure SQL deployment requires customer control over the database encryption key lifecycle.

Question 169

Two independent Azure SQL administration tickets require separate actions. Case A: A team wants column master key operations separated from database administration and stored in a key vault. Case B: A security scan detects a SQL client using insecure transport despite encryption-at-rest controls. Select exactly TWO distinct implementation steps, one for each case.

  1. Enable or verify transparent data encryption for the database and supporting assets
  2. Require encrypted SQL client transport with valid certificate verification
  3. Apply a least-permissive logical-server or database-level firewall rule for the authorized source
  4. Store supported Always Encrypted column master keys in a protected key store
  5. Configure a Private Link endpoint and private DNS integration for Azure SQL

Explanation

Correct Answers

B:

Require encrypted SQL client transport with valid certificate verification directly resolves the reported requirement that 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. The implementation must also respect this constraint: Encrypting files at rest alone does not secure traffic over the network.

D:

Store supported Always Encrypted column master keys in a protected key store directly resolves the reported requirement that a team wants column master key operations separated from database administration and stored in a key vault. Client-held keys can remain outside the database engine's direct control. The implementation must also respect this constraint: Key loss or incorrect driver configuration can make encrypted values unreadable.

Incorrect Answers

A:

Enable or verify transparent data encryption for the database and supporting assets 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 2 cases are A: A team wants column master key operations separated from database administration and stored in a key vault; B: A security scan detects a SQL client using insecure transport despite encryption-at-rest controls. 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 team wants column master key operations separated from database administration and stored in a key vault; B: A security scan detects a SQL client using insecure transport despite encryption-at-rest controls. This option is not the specific implementation or corrective step for any of those stated cases.

E:

Configure a Private Link endpoint and private DNS integration for Azure SQL 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 2 cases are A: A team wants column master key operations separated from database administration and stored in a key vault; B: A security scan detects a SQL client using insecure transport despite encryption-at-rest controls. This option is not the specific implementation or corrective step for any of those stated cases.

Question 170

Three independently confirmed SQL platform issues require separate evidence checks. Case A: Only one legacy sensitive attribute needs an application-controlled encryption path rather than whole-database disk protection. Case B: A regulated Azure SQL deployment requires customer control over the database encryption key lifecycle. Case C: A test system can use the correct SQL credentials but its current source IP is blocked by Azure SQL firewall policy. Select exactly THREE distinct diagnostic checks, one for each case.

  1. Column encryption metadata driver support and client-side key access
  2. Client connection encryption setting and negotiated TLS version
  3. Private endpoint connection status and private DNS resolution to the private address
  4. Azure SQL firewall rules and connection rejection code
  5. Encrypted payload representation and decryption-key ownership record
  6. Key Vault key identifier and Azure SQL TDE protector configuration

Explanation

Correct Answers

D:

Azure SQL firewall rules and connection rejection code directly tests the observation that a test system can use the correct SQL credentials but its current source IP is blocked by Azure SQL firewall policy. It helps the team evaluate whether it should apply a least-permissive logical-server or database-level firewall rule for the authorized source. The check has a boundary: An open firewall path does not grant database login or object access.

E:

Encrypted payload representation and decryption-key ownership record directly tests the observation that only one legacy sensitive attribute needs an application-controlled encryption path rather than whole-database disk protection. It helps the team evaluate whether it should choose supported object or column encryption explicitly for that attribute. The check has a boundary: Database-level encryption alone cannot replace column confidentiality controls.

F:

Key Vault key identifier and Azure SQL TDE protector configuration directly tests the observation that a regulated Azure SQL deployment requires customer control over the database encryption key lifecycle. It helps the team evaluate whether it should configure a supported customer-managed TDE protector using Azure Key Vault. The check has a boundary: Deleting or denying access to the protector can impair database availability.

Incorrect Answers

A:

Column encryption metadata driver support and client-side key access is appropriate for the separate condition that a payroll application must prevent database administrators from reading salary plaintext while the client retains decryption keys. The actual 3 cases are A: Only one legacy sensitive attribute needs an application-controlled encryption path rather than whole-database disk protection; B: A regulated Azure SQL deployment requires customer control over the database encryption key lifecycle; C: A test system can use the correct SQL credentials but its current source IP is blocked by Azure SQL firewall policy. This option is not the specific diagnostic evidence for any of those stated cases.

B:

Client connection encryption setting and negotiated TLS version is appropriate for the separate condition that a security scan detects a SQL client using insecure transport despite encryption-at-rest controls. The actual 3 cases are A: Only one legacy sensitive attribute needs an application-controlled encryption path rather than whole-database disk protection; B: A regulated Azure SQL deployment requires customer control over the database encryption key lifecycle; C: A test system can use the correct SQL credentials but its current source IP is blocked by Azure SQL firewall policy. This option is not the specific diagnostic evidence for any of those stated cases.

C:

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: Only one legacy sensitive attribute needs an application-controlled encryption path rather than whole-database disk protection; B: A regulated Azure SQL deployment requires customer control over the database encryption key lifecycle; C: A test system can use the correct SQL credentials but its current source IP is blocked by Azure SQL firewall policy. 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.