100% Latest & Updated Microsoft DP-300 Practice Test Questions, Exam Dumps & Verified Answers!
30 Days Free Updates, Instant Download!
Question 180
Three independently confirmed SQL platform issues require separate evidence checks. Case A: A regulator requires database files transaction logs and backups to be encrypted at rest without modifying SQL queries. Case B: A security scan detects a SQL client using insecure transport despite encryption-at-rest controls. Case C: A payroll application must prevent database administrators from reading salary plaintext while the client retains decryption keys. Select exactly THREE distinct diagnostic checks, one for each case.
- Column encryption metadata driver support and client-side key access
- Encrypted payload representation and decryption-key ownership record
- Client connection encryption setting and negotiated TLS version
- Secure enclave attestation settings and encrypted-column operation capability
- Azure SQL TDE state and protector key configuration
- Private endpoint connection status and private DNS resolution to the private address
Explanation
Correct Answers
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.
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.
E: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
B:Encrypted payload representation and decryption-key ownership record 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 3 cases are A: A regulator requires database files transaction logs and backups to be encrypted at rest without modifying SQL queries; B: A security scan detects a SQL client using insecure transport despite encryption-at-rest controls; C: A payroll application must prevent database administrators from reading salary plaintext while the client retains decryption keys. This option is not the specific diagnostic evidence for any of those stated cases.
D:Secure enclave attestation settings and encrypted-column operation capability is appropriate for the separate condition that a sensitive encrypted column needs supported server-side computations without exposing general plaintext to SQL administrators. The actual 3 cases are A: A regulator requires database files transaction logs and backups to be encrypted at rest without modifying SQL queries; B: A security scan detects a SQL client using insecure transport despite encryption-at-rest controls; C: A payroll application must prevent database administrators from reading salary plaintext while the client retains decryption keys. This option is not the specific diagnostic evidence for any of those stated cases.
F: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 regulator requires database files transaction logs and backups to be encrypted at rest without modifying SQL queries; B: A security scan detects a SQL client using insecure transport despite encryption-at-rest controls; C: A payroll application must prevent database administrators from reading salary plaintext while the client retains decryption keys. This option is not the specific diagnostic evidence for any of those stated cases.
Question 181
A post-change impact assessment considers the requirement that: A payroll application must prevent database administrators from reading salary plaintext while the client retains decryption keys. What operational outcome follows from implementing the appropriate solution?
- Column plaintext can remain inaccessible to the database engine for supported operations
- Storage-level database data is encrypted without changing SQL application statements
- Eligible clients can establish network connections to the SQL service
- The sensitive payload is protected at a narrower data boundary
Explanation
Correct Answer
A:Column plaintext can remain inaccessible to the database engine for supported operations is the expected technical effect when the administrator chooses the relevant approach for a payroll application must prevent database administrators from reading salary plaintext while the client retains decryption keys. The needed action is to implement Always Encrypted for the protected columns with supported client drivers.
Incorrect Answers
B:Storage-level database data is encrypted without changing SQL application statements 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.
C:Eligible clients can establish network connections to the SQL service 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:The sensitive payload is protected at a narrower data boundary applies when only one legacy sensitive attribute needs an application-controlled encryption path rather than whole-database disk protection, not when a payroll application must prevent database administrators from reading salary plaintext while the client retains decryption keys.
Question 182
The team needs to anticipate the behavior of a correct solution for: A sensitive encrypted column needs supported server-side computations without exposing general plaintext to SQL administrators. What operational outcome follows from implementing the appropriate solution?
- Eligible clients can establish network connections to the SQL service
- Supported confidential computations become possible over protected columns
- Client-held keys can remain outside the database engine's direct control
- Storage-level database data is encrypted without changing SQL application statements
Explanation
Correct Answer
B:Supported confidential computations become possible over protected columns is the expected technical effect when the administrator chooses the relevant approach for a sensitive encrypted column needs supported server-side computations without exposing general plaintext to SQL administrators. The needed action is to configure supported Always Encrypted with secure enclaves and eligible client drivers.
Incorrect Answers
A:Eligible clients can establish network connections to the SQL service 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.
C:Client-held keys can remain outside the database engine's direct control 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.
D:Storage-level database data is encrypted without changing SQL application statements applies when a regulator requires database files transaction logs and backups to be encrypted at rest without modifying SQL queries, not when a sensitive encrypted column needs supported server-side computations without exposing general plaintext to SQL administrators.
Question 183
An operational planning meeting reviews this deployment condition: A finance database must be reached through approved VNet private IP connectivity rather than an exposed public endpoint. What operational outcome follows from implementing the appropriate solution?
- The client-to-server database connection is protected against passive interception
- Storage-level database data is encrypted without changing SQL application statements
- Clients can route to the SQL service through the private address
- The sensitive payload is protected at a narrower data boundary
Explanation
Correct Answer
C:Clients can route to the SQL service through the private address is the expected technical effect when the administrator chooses the relevant approach for a finance database must be reached through approved VNet private IP connectivity rather than an exposed public endpoint. The needed action is to configure a Private Link endpoint and private DNS integration for Azure SQL.
Incorrect Answers
A:The client-to-server database connection is protected against passive interception applies when a security scan detects a SQL client using insecure transport despite encryption-at-rest controls, not when a finance database must be reached through approved VNet private IP connectivity rather than an exposed public endpoint.
B:Storage-level database data is encrypted without changing SQL application statements 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.
D:The sensitive payload is protected at a narrower data boundary 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 184
A post-change impact assessment considers the requirement that: A test system can use the correct SQL credentials but its current source IP is blocked by Azure SQL firewall policy. What operational outcome follows from implementing the appropriate solution?
- Storage-level database data is encrypted without changing SQL application statements
- Supported confidential computations become possible over protected columns
- Eligible clients can establish network connections to the SQL service
- The sensitive payload is protected at a narrower data boundary
Explanation
Correct Answer
C:Eligible clients can establish network connections to the SQL service is the expected technical effect when the administrator chooses the relevant approach for a test system can use the correct SQL credentials but its current source IP is blocked by Azure SQL firewall policy. The needed action is to apply a least-permissive logical-server or database-level firewall rule for the authorized source.
Incorrect Answers
A:Storage-level database data is encrypted without changing SQL application statements applies when a regulator requires database files transaction logs and backups to be encrypted at rest without modifying SQL queries, not when a test system can use the correct SQL credentials but its current source IP is blocked by Azure SQL firewall policy.
B:Supported confidential computations become possible over protected columns applies when a sensitive encrypted column needs supported server-side computations without exposing general plaintext to SQL administrators, not when a test system can use the correct SQL credentials but its current source IP is blocked by Azure SQL firewall policy.
D:The sensitive payload is protected at a narrower data boundary applies when only one legacy sensitive attribute needs an application-controlled encryption path rather than whole-database disk protection, not when a test system can use the correct SQL credentials but its current source IP is blocked by Azure SQL firewall policy.
Question 185
The team needs to anticipate the behavior of a correct solution for: A security scan detects a SQL client using insecure transport despite encryption-at-rest controls. What operational outcome follows from implementing the appropriate solution?
- Column plaintext can remain inaccessible to the database engine for supported operations
- Clients can route to the SQL service through the private address
- The client-to-server database connection is protected against passive interception
- Supported confidential computations become possible over protected columns
Explanation
Correct Answer
C:The client-to-server database connection is protected against passive interception is the expected technical effect when the administrator chooses the relevant approach for a security scan detects a SQL client using insecure transport despite encryption-at-rest controls. The needed action is to require encrypted SQL client transport with valid certificate verification.
Incorrect Answers
A:Column plaintext can remain inaccessible to the database engine for supported operations applies when a payroll application must prevent database administrators from reading salary plaintext while the client retains decryption keys, not when a security scan detects a SQL client using insecure transport despite encryption-at-rest controls.
B:Clients can route to the SQL service through 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 security scan detects a SQL client using insecure transport despite encryption-at-rest controls.
D:Supported confidential computations become possible over protected columns applies when a sensitive encrypted column needs supported server-side computations without exposing general plaintext to SQL administrators, not when a security scan detects a SQL client using insecure transport despite encryption-at-rest controls.
Question 186
An operational planning meeting reviews this deployment condition: A regulated Azure SQL deployment requires customer control over the database encryption key lifecycle. What operational outcome follows from implementing the appropriate solution?
- Clients can route to the SQL service through the private address
- The customer controls key rotation and access policy for the encryption protector
- Storage-level database data is encrypted without changing SQL application statements
- Eligible clients can establish network connections to the SQL service
Explanation
Correct Answer
B:The customer controls key rotation and access policy for the encryption protector is the expected technical effect when the administrator chooses the relevant approach for a regulated Azure SQL deployment requires customer control over the database encryption key lifecycle. The needed action is to configure a supported customer-managed TDE protector using Azure Key Vault.
Incorrect Answers
A:Clients can route to the SQL service through 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.
C:Storage-level database data is encrypted without changing SQL application statements applies when a regulator requires database files transaction logs and backups to be encrypted at rest without modifying SQL queries, not when a regulated Azure SQL deployment requires customer control over the database encryption key lifecycle.
D:Eligible clients can establish network connections to the SQL service 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 regulated Azure SQL deployment requires customer control over the database encryption key lifecycle.
Question 187
A post-change impact assessment considers the requirement that: A team wants column master key operations separated from database administration and stored in a key vault. What operational outcome follows from implementing the appropriate solution?
- Supported confidential computations become possible over protected columns
- Eligible clients can establish network connections to the SQL service
- Storage-level database data is encrypted without changing SQL application statements
- Client-held keys can remain outside the database engine's direct control
Explanation
Correct Answer
D:Client-held keys can remain outside the database engine's direct control is the expected technical effect when the administrator chooses the relevant approach for a team wants column master key operations separated from database administration and stored in a key vault. The needed action is to store supported Always Encrypted column master keys in a protected key store.
Incorrect Answers
A:Supported confidential computations become possible over protected columns applies when a sensitive encrypted column needs supported server-side computations without exposing general plaintext to SQL administrators, not when a team wants column master key operations separated from database administration and stored in a key vault.
B:Eligible clients can establish network connections to the SQL service 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 team wants column master key operations separated from database administration and stored in a key vault.
C:Storage-level database data is encrypted without changing SQL application statements applies when a regulator requires database files transaction logs and backups to be encrypted at rest without modifying SQL queries, not when a team wants column master key operations separated from database administration and stored in a key vault.
Question 188
The team needs to anticipate the behavior of a correct solution for: Only one legacy sensitive attribute needs an application-controlled encryption path rather than whole-database disk protection. What operational outcome follows from implementing the appropriate solution?
- Eligible clients can establish network connections to the SQL service
- The sensitive payload is protected at a narrower data boundary
- Column plaintext can remain inaccessible to the database engine for supported operations
- Storage-level database data is encrypted without changing SQL application statements
Explanation
Correct Answer
B:The sensitive payload is protected at a narrower data boundary is the expected technical effect when the administrator chooses the relevant approach for only one legacy sensitive attribute needs an application-controlled encryption path rather than whole-database disk protection. The needed action is to choose supported object or column encryption explicitly for that attribute.
Incorrect Answers
A:Eligible clients can establish network connections to the SQL service 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.
C:Column plaintext can remain inaccessible to the database engine for supported operations applies when a payroll application must prevent database administrators from reading salary plaintext while the client retains decryption keys, not when only one legacy sensitive attribute needs an application-controlled encryption path rather than whole-database disk protection.
D:Storage-level database data is encrypted without changing SQL application statements applies when a regulator requires database files transaction logs and backups to be encrypted at rest without modifying SQL queries, not when only one legacy sensitive attribute needs an application-controlled encryption path rather than whole-database disk protection.
Question 189
Two independent Azure SQL administration tickets require separate actions. Case A: A regulator requires database files transaction logs and backups to be encrypted at rest without modifying SQL queries. Case B: A regulated Azure SQL deployment requires customer control over the database encryption key lifecycle. Select exactly TWO distinct implementation steps, one for each case.
- Apply a least-permissive logical-server or database-level firewall rule for the authorized source
- Configure a supported customer-managed TDE protector using Azure Key Vault
- Require encrypted SQL client transport with valid certificate verification
- Choose supported object or column encryption explicitly for that attribute
- Enable or verify transparent data encryption for the database and supporting assets
Explanation
Correct Answers
B: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.
E: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.
Incorrect Answers
A: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 regulator requires database files transaction logs and backups to be encrypted at rest without modifying SQL queries; B: A regulated Azure SQL deployment requires customer control over the database encryption key lifecycle. This option is not the specific implementation or corrective step for any of those stated cases.
C: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 regulator requires database files transaction logs and backups to be encrypted at rest without modifying SQL queries; B: A regulated Azure SQL deployment requires customer control over the database encryption key lifecycle. This option is not the specific implementation or corrective step for any of those stated cases.
D: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 regulator requires database files transaction logs and backups to be encrypted at rest without modifying SQL queries; B: A regulated Azure SQL deployment requires customer control over the database encryption key lifecycle. This option is not the specific implementation or corrective step for any of those stated cases.
Question 190
Three independently confirmed SQL platform issues require separate evidence checks. Case A: A payroll application must prevent database administrators from reading salary plaintext while the client retains decryption keys. Case B: A team wants column master key operations separated from database administration and stored in a key vault. 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.
- Column master key metadata and Azure Key Vault permissions
- Column encryption metadata driver support and client-side key access
- Azure SQL TDE state and protector key configuration
- Azure SQL firewall rules and connection rejection code
- Private endpoint connection status and private DNS resolution to the private address
- Secure enclave attestation settings and encrypted-column operation capability
Explanation
Correct Answers
A: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.
B: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.
F: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
C: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 payroll application must prevent database administrators from reading salary plaintext while the client retains decryption keys; B: A team wants column master key operations separated from database administration and stored in a key vault; 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: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 payroll application must prevent database administrators from reading salary plaintext while the client retains decryption keys; B: A team wants column master key operations separated from database administration and stored in a key vault; 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.
E: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 payroll application must prevent database administrators from reading salary plaintext while the client retains decryption keys; B: A team wants column master key operations separated from database administration and stored in a key vault; 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