100% Latest & Updated Microsoft DP-800 Practice Test Questions, Exam Dumps & Verified Answers!
30 Days Free Updates, Instant Download!
Question 450
Developers need to encrypt one application field using SQL keys. The team selects: Use SQL column-level encryption functions where appropriate. Which implementation action puts this design into practice?
- Provision column encryption keys and compatible client driver
- Configure authenticated role mappings and field restrictions
- Manage symmetric keys, certificates and ENCRYPTBYKEY in approved code
- Create minimal integration role and GRANT EXECUTE
Explanation
Correct Answer
C:Manage symmetric keys, certificates and ENCRYPTBYKEY in approved code. This is the concrete setup for use sql column-level encryption functions where appropriate, and open key and decrypt only as authorized principal supplies a direct confirmation.
Incorrect Answers
A:Provision column encryption keys and compatible client driver. This concerns a hospital protects payment numbers even from database administrators. Here, manage symmetric keys, certificates and ENCRYPTBYKEY in approved code.
B:Configure authenticated role mappings and field restrictions. This concerns secure graphql field access for different roles. Here, manage symmetric keys, certificates and ENCRYPTBYKEY in approved code.
D:Create minimal integration role and GRANT EXECUTE. This concerns access one stored procedure. Here, manage symmetric keys, certificates and ENCRYPTBYKEY in approved code.
Question 451
Developers need to encrypt one application field using SQL keys. After implementing the design, which check most directly validates the expected behavior?
- Open key and decrypt only as authorized principal
- Test unauthorized calls receive access denial
- Confirm authorized call succeeds and disallowed call fails
- Verify clients decrypt data after key rotation
Explanation
Correct Answer
A:Open key and decrypt only as authorized principal. This verifies the requirement in the case rather than merely confirming that a job ran; an opposing result can reveal that required symmetric key was not opened in that session.
Incorrect Answers
B:Test unauthorized calls receive access denial. This concerns an external service calls a database-backed rest API. Instead, open key and decrypt only as authorized principal.
C:Confirm authorized call succeeds and disallowed call fails. This is relevant when a production ai model endpoint is called from SQL. Instead, open key and decrypt only as authorized principal.
D:Verify clients decrypt data after key rotation. This concerns secure key rotation for always encrypted. Instead, open key and decrypt only as authorized principal.
Question 452
Developers need to encrypt one application field using SQL keys. A test instead finds: DecryptByKey returns NULL unexpectedly. Which underlying issue best explains this finding?
- The application built SQL by concatenating user input
- DELETE permission was granted directly or via inherited role
- Required symmetric key was not opened in that session
- Keys were rotated without re-encrypting or updating dependent keys
Explanation
Correct Answer
C:Required symmetric key was not opened in that session. It accounts for the specific observed failure: decryptbykey returns null unexpectedly. The intended solution is use sql column-level encryption functions where appropriate with the required setup.
Incorrect Answers
A:The application built SQL by concatenating user input. This concerns input with a quote executes appended SQL. Here, required symmetric key was not opened in that session.
B:DELETE permission was granted directly or via inherited role. This concerns editor can remove entire rows. Here, required symmetric key was not opened in that session.
D:Keys were rotated without re-encrypting or updating dependent keys. This concerns old encryption metadata breaks all clients. Here, required symmetric key was not opened in that session.
Question 453
An auditor must record which identity retrieved salary information. Which database design or engineering approach most directly meets this requirement?
- Enable appropriate SQL auditing for schema events
- Capture SELECT access with supported SQL auditing
- Use Microsoft Entra authentication with managed identity where supported
- Use encryption for secrecy instead of relying on Dynamic Data Masking
Explanation
Correct Answer
B:Capture SELECT access with supported SQL auditing. The implementation is configure audit policy for sensitive object action; success can be checked by issue scoped query and verify principal and timestamp in logs. The method addresses the stated data and workload constraint.
Incorrect Answers
A:Enable appropriate SQL auditing for schema events. This concerns security officers need a durable record of database schema changes. Instead, capture SELECT access with supported SQL auditing.
C:Use Microsoft Entra authentication with managed identity where supported. This concerns authenticating without storing a SQL password. Instead, capture SELECT access with supported SQL auditing.
D:Use encryption for secrecy instead of relying on Dynamic Data Masking. This concerns distinguishing encrypted values from masked display values. Instead, capture SELECT access with supported SQL auditing.
Question 454
An auditor must record which identity retrieved salary information. The team selects: Capture SELECT access with supported SQL auditing. Which implementation action puts this design into practice?
- Use GRANT UPDATE and explicit minimum SELECT permissions
- Configure audit destination and action groups
- Apply sensitivity labels/information types to sensitive columns
- Configure audit policy for sensitive object action
Explanation
Correct Answer
D:Configure audit policy for sensitive object action. This is the concrete setup for capture select access with supported sql auditing, and issue scoped query and verify principal and timestamp in logs supplies a direct confirmation.
Incorrect Answers
A:Use GRANT UPDATE and explicit minimum SELECT permissions. This concerns updating but not delete orders. Instead, configure audit policy for sensitive object action.
B:Configure audit destination and action groups. This concerns security officers need a durable record of database schema changes. Instead, configure audit policy for sensitive object action.
C:Apply sensitivity labels/information types to sensitive columns. This concerns searchable sensitivity tags on columns. Instead, configure audit policy for sensitive object action.
Question 455
An auditor must record which identity retrieved salary information. After implementing the design, which check most directly validates the expected behavior?
- Open key and decrypt only as authorized principal
- Review logs and artifacts for accidental secret disclosure
- Issue scoped query and verify principal and timestamp in logs
- Execute a test ALTER and confirm audit record arrival
Explanation
Correct Answer
C:Issue scoped query and verify principal and timestamp in logs. This verifies the requirement in the case rather than merely confirming that a job ran; an opposing result can reveal that wrong audit actions were selected.
Incorrect Answers
A:Open key and decrypt only as authorized principal. This concerns developers need to encrypt one application field using SQL keys. Here, issue scoped query and verify principal and timestamp in logs.
B:Review logs and artifacts for accidental secret disclosure. This is relevant when an application uses a SQL credential in a deployment pipeline. Here, issue scoped query and verify principal and timestamp in logs.
D:Execute a test ALTER and confirm audit record arrival. This concerns security officers need a durable record of database schema changes. Here, issue scoped query and verify principal and timestamp in logs.
Question 456
An auditor must record which identity retrieved salary information. A test instead finds: Audit only records schema modifications but not sensitive reads. Which underlying issue best explains this finding?
- Wrong audit actions were selected
- Identity-based authentication was not configured end to end
- Audit logs lack protected independent retention
- Audit action or destination was not configured
Explanation
Correct Answer
A:Wrong audit actions were selected. It accounts for the specific observed failure: audit only records schema modifications but not sensitive reads. The intended solution is capture select access with supported sql auditing with the required setup.
Incorrect Answers
B:Identity-based authentication was not configured end to end. This concerns connection falls back to embedded SQL credentials. Here, wrong audit actions were selected.
C:Audit logs lack protected independent retention. This concerns an operator can erase all historical audit evidence. Here, wrong audit actions were selected.
D:Audit action or destination was not configured. This concerns change incident has no attributable database audit event. Here, wrong audit actions were selected.
Question 457
A vendor integration must access one stored procedure. Which database design or engineering approach most directly meets this requirement?
- Use a private endpoint and disable unwanted public access
- Require authenticated Data API builder endpoint access
- Grant EXECUTE on the procedure, not broad table access
- Capture SELECT access with supported SQL auditing
Explanation
Correct Answer
C:Grant EXECUTE on the procedure, not broad table access. The implementation is create minimal integration role and grant execute; success can be checked by verify procedure works and direct table read fails. The method addresses the stated data and workload constraint.
Incorrect Answers
A:Use a private endpoint and disable unwanted public access. This concerns internal-only database access from azure workloads. Instead, grant EXECUTE on the procedure, not broad table access.
B:Require authenticated Data API builder endpoint access. This concerns an external service calls a database-backed rest API. Instead, grant EXECUTE on the procedure, not broad table access.
D:Capture SELECT access with supported SQL auditing. This concerns recording which identity retrieved salary information. Instead, grant EXECUTE on the procedure, not broad table access.
Question 458
A vendor integration must access one stored procedure. The team selects: Grant EXECUTE on the procedure, not broad table access. Which implementation action puts this design into practice?
- Create database principal for function identity and GRANT EXECUTE
- Assign workload identity to endpoint access role
- Create minimal integration role and GRANT EXECUTE
- Create a report reader role with scoped GRANT SELECT
Explanation
Correct Answer
C:Create minimal integration role and GRANT EXECUTE. This is the concrete setup for grant execute on the procedure, not broad table access, and verify procedure works and direct table read fails supplies a direct confirmation.
Incorrect Answers
A:Create database principal for function identity and GRANT EXECUTE. This concerns permission to call a database. Instead, create minimal integration role and GRANT EXECUTE.
B:Assign workload identity to endpoint access role. This is relevant when a production ai model endpoint is called from SQL. Instead, create minimal integration role and GRANT EXECUTE.
D:Create a report reader role with scoped GRANT SELECT. This concerns reading only a specific schema. Instead, create minimal integration role and GRANT EXECUTE.
Question 459
A vendor integration must access one stored procedure. After implementing the design, which check most directly validates the expected behavior?
- Read secret from approved runtime while repo contains no plaintext
- Confirm authorized call succeeds and disallowed call fails
- Attempt direct export via privileged user without decrypt key
- Verify procedure works and direct table read fails
Explanation
Correct Answer
D:Verify procedure works and direct table read fails. This verifies the requirement in the case rather than merely confirming that a job ran; an opposing result can reveal that over-broad role membership was used instead of object grant.
Incorrect Answers
A:Read secret from approved runtime while repo contains no plaintext. This concerns retrieving a database secret without checking it into git. Instead, verify procedure works and direct table read fails.
B:Confirm authorized call succeeds and disallowed call fails. This is relevant when a production ai model endpoint is called from SQL. Instead, verify procedure works and direct table read fails.
C:Attempt direct export via privileged user without decrypt key. This concerns distinguishing encrypted values from masked display values. Instead, verify procedure works and direct table read fails.
Question 460
A vendor integration must access one stored procedure. A test instead finds: Vendor account can browse the full schema. Which underlying issue best explains this finding?
- Principal inherits broad db_datareader or equivalent access
- Over-broad role membership was used instead of object grant
- AI tooling reused an elevated operational account
- Permission arrives from a different role or ownership chain
Explanation
Correct Answer
B:Over-broad role membership was used instead of object grant. It accounts for the specific observed failure: vendor account can browse the full schema. The intended solution is grant execute on the procedure, not broad table access with the required setup.
Incorrect Answers
A:Principal inherits broad db_datareader or equivalent access. This concerns analyst reads payroll tables outside approved schema. Here, over-broad role membership was used instead of object grant.
C:AI tooling reused an elevated operational account. This concerns tool executes delete on a business table. Here, over-broad role membership was used instead of object grant.
D:Permission arrives from a different role or ownership chain. This concerns unexpected access persists after revoking direct grant. Here, over-broad role membership was used instead of object grant.
Developing AI-Enabled Database Solutions (DP-800) Practice Tests