100% Latest & Updated Microsoft DP-800 Practice Test Questions, Exam Dumps & Verified Answers!
30 Days Free Updates, Instant Download!
Question 470
A compliance team needs searchable sensitivity tags on columns. The team selects: Use SQL data classification metadata. Which implementation action puts this design into practice?
- Apply sensitivity labels/information types to sensitive columns
- Configure enclave attestation and enclave-enabled encryption keys
- Use GRANT UPDATE and explicit minimum SELECT permissions
- Apply appropriate protected-column encryption to sensitive data
Explanation
Correct Answer
A:Apply sensitivity labels/information types to sensitive columns. This is the concrete setup for use sql data classification metadata, and inspect classified metadata and reporting output supplies a direct confirmation.
Incorrect Answers
B:Configure enclave attestation and enclave-enabled encryption keys. This concerns executing server-side calculations over protected columns. Instead, apply sensitivity labels/information types to sensitive columns.
C:Use GRANT UPDATE and explicit minimum SELECT permissions. This concerns updating but not delete orders. Instead, apply sensitivity labels/information types to sensitive columns.
D:Apply appropriate protected-column encryption to sensitive data. This concerns distinguishing encrypted values from masked display values. Instead, apply sensitivity labels/information types to sensitive columns.
Question 471
A compliance team needs searchable sensitivity tags on columns. After implementing the design, which check most directly validates the expected behavior?
- Query as admin without keys and confirm ciphertext stays opaque
- Inspect classified metadata and reporting output
- Attempt unauthorized metadata discovery and confirm denial
- Test injection-like strings and inspect query behavior
Explanation
Correct Answer
B:Inspect classified metadata and reporting output. This verifies the requirement in the case rather than merely confirming that a job ran; an opposing result can reveal that classification labels were not assigned to those fields.
Incorrect Answers
A:Query as admin without keys and confirm ciphertext stays opaque. This concerns a hospital protects payment numbers even from database administrators. Instead, inspect classified metadata and reporting output.
C:Attempt unauthorized metadata discovery and confirm denial. This concerns a team exposes SQL metadata through an mcp endpoint. Instead, inspect classified metadata and reporting output.
D:Test injection-like strings and inspect query behavior. This concerns protecting sensitive data from SQL injection. Instead, inspect classified metadata and reporting output.
Question 472
A compliance team needs searchable sensitivity tags on columns. A test instead finds: Sensitive columns are absent from inventory reports. Which underlying issue best explains this finding?
- Secure enclave support or attestation configuration is absent
- Masking was mistaken for cryptographic confidentiality
- Sensitive fields were encrypted server-side only rather than in the client
- Classification labels were not assigned to those fields
Explanation
Correct Answer
D:Classification labels were not assigned to those fields. It accounts for the specific observed failure: sensitive columns are absent from inventory reports. The intended solution is use sql data classification metadata with the required setup.
Incorrect Answers
A:Secure enclave support or attestation configuration is absent. This concerns protected comparison fails despite proper client drivers. Here, classification labels were not assigned to those fields.
B:Masking was mistaken for cryptographic confidentiality. This concerns privileged users retrieve underlying unmasked secret. Here, classification labels were not assigned to those fields.
C:Sensitive fields were encrypted server-side only rather than in the client. This concerns dba sees payment plaintext during a normal select. Here, classification labels were not assigned to those fields.
Question 473
A production AI model endpoint is called from SQL. Which database design or engineering approach most directly meets this requirement?
- Use managed identity and scoped endpoint permissions
- Require scoped authentication and permissioned tools
- Authorize its managed identity with least privileges
- Use Microsoft Entra authentication with managed identity where supported
Explanation
Correct Answer
A:Use managed identity and scoped endpoint permissions. The implementation is assign workload identity to endpoint access role; success can be checked by confirm authorized call succeeds and disallowed call fails. The method addresses the stated data and workload constraint.
Incorrect Answers
B:Require scoped authentication and permissioned tools. This concerns a team exposes SQL metadata through an mcp endpoint. Instead, use managed identity and scoped endpoint permissions.
C:Authorize its managed identity with least privileges. This concerns permission to call a database. Instead, use managed identity and scoped endpoint permissions.
D:Use Microsoft Entra authentication with managed identity where supported. This concerns authenticating without storing a SQL password. Instead, use managed identity and scoped endpoint permissions.
Question 474
A production AI model endpoint is called from SQL. The team selects: Use managed identity and scoped endpoint permissions. Which implementation action puts this design into practice?
- Create minimal integration role and GRANT EXECUTE
- Bind MCP server to least-privilege SQL identity and secure transport
- Assign workload identity to endpoint access role
- Create Entra principal and assign managed identity to workload
Explanation
Correct Answer
C:Assign workload identity to endpoint access role. This is the concrete setup for use managed identity and scoped endpoint permissions, and confirm authorized call succeeds and disallowed call fails supplies a direct confirmation.
Incorrect Answers
A:Create minimal integration role and GRANT EXECUTE. This concerns access one stored procedure. Instead, assign workload identity to endpoint access role.
B:Bind MCP server to least-privilege SQL identity and secure transport. This concerns a team exposes SQL metadata through an mcp endpoint. Instead, assign workload identity to endpoint access role.
D:Create Entra principal and assign managed identity to workload. This concerns authenticating without storing a SQL password. Instead, assign workload identity to endpoint access role.
Question 475
A production AI model endpoint is called from SQL. After implementing the design, which check most directly validates the expected behavior?
- Attempt unauthorized metadata discovery and confirm denial
- Confirm authorized call succeeds and disallowed call fails
- Run AI tool as its role and test blocked operations
- Confirm function executes only approved stored procedures
Explanation
Correct Answer
B:Confirm authorized call succeeds and disallowed call fails. This verifies the requirement in the case rather than merely confirming that a job ran; an opposing result can reveal that endpoint authentication was not migrated to managed identity.
Incorrect Answers
A:Attempt unauthorized metadata discovery and confirm denial. This concerns a team exposes SQL metadata through an mcp endpoint. Instead, confirm authorized call succeeds and disallowed call fails.
C:Run AI tool as its role and test blocked operations. This concerns segregated permissions for ai tooling. Instead, confirm authorized call succeeds and disallowed call fails.
D:Confirm function executes only approved stored procedures. This concerns permission to call a database. Instead, confirm authorized call succeeds and disallowed call fails.
Question 476
A production AI model endpoint is called from SQL. A test instead finds: SQL service sends a hard-coded endpoint key in clear configuration. Which underlying issue best explains this finding?
- MCP server credential can access unapproved database objects
- Endpoint authentication was not migrated to managed identity
- Required symmetric key was not opened in that session
- Identity-based authentication was not configured end to end
Explanation
Correct Answer
B:Endpoint authentication was not migrated to managed identity. It accounts for the specific observed failure: sql service sends a hard-coded endpoint key in clear configuration. The intended solution is use managed identity and scoped endpoint permissions with the required setup.
Incorrect Answers
A:MCP server credential can access unapproved database objects. This concerns agent lists protected schemas despite low privilege. Here, endpoint authentication was not migrated to managed identity.
C:Required symmetric key was not opened in that session. This concerns decryptbykey returns null unexpectedly. Here, endpoint authentication was not migrated to managed identity.
D:Identity-based authentication was not configured end to end. This concerns connection falls back to embedded SQL credentials. Here, endpoint authentication was not migrated to managed identity.
Question 477
A database deployer must be unable to read private production data. Which database design or engineering approach most directly meets this requirement?
- Grant SELECT on the reporting schema and restrict others
- Parameterize statements and restrict SQL principal rights
- Use SQL data classification metadata
- Separate schema-deployment permission from data SELECT rights
Explanation
Correct Answer
D:Separate schema-deployment permission from data SELECT rights. The implementation is use dedicated migration identity with scoped ddl capabilities; success can be checked by test schema deployment and reject raw sensitive data query. The method addresses the stated data and workload constraint.
Incorrect Answers
A:Grant SELECT on the reporting schema and restrict others. This concerns reading only a specific schema. Instead, separate schema-deployment permission from data SELECT rights.
B:Parameterize statements and restrict SQL principal rights. This concerns protecting sensitive data from SQL injection. Instead, separate schema-deployment permission from data SELECT rights.
C:Use SQL data classification metadata. This concerns searchable sensitivity tags on columns. Instead, separate schema-deployment permission from data SELECT rights.
Question 478
A database deployer must be unable to read private production data. The team selects: Separate schema-deployment permission from data SELECT rights. Which implementation action puts this design into practice?
- Grant managed identity a limited vault data-plane role
- Create a report reader role with scoped GRANT SELECT
- Use supported key rotation workflow with Key Vault and drivers
- Use dedicated migration identity with scoped DDL capabilities
Explanation
Correct Answer
D:Use dedicated migration identity with scoped DDL capabilities. This is the concrete setup for separate schema-deployment permission from data select rights, and test schema deployment and reject raw sensitive data query supplies a direct confirmation.
Incorrect Answers
A:Grant managed identity a limited vault data-plane role. This concerns retrieving a database secret without checking it into git. Instead, use dedicated migration identity with scoped DDL capabilities.
B:Create a report reader role with scoped GRANT SELECT. This concerns reading only a specific schema. Instead, use dedicated migration identity with scoped DDL capabilities.
C:Use supported key rotation workflow with Key Vault and drivers. This concerns secure key rotation for always encrypted. Instead, use dedicated migration identity with scoped DDL capabilities.
Question 479
A database deployer must be unable to read private production data. After implementing the design, which check most directly validates the expected behavior?
- Run tests under analyst role against report and private objects
- Test schema deployment and reject raw sensitive data query
- Query with two tenant identities and compare visibility
- Test injection-like strings and inspect query behavior
Explanation
Correct Answer
B:Test schema deployment and reject raw sensitive data query. This verifies the requirement in the case rather than merely confirming that a job ran; an opposing result can reveal that the migration role was granted unnecessary data-reader rights.
Incorrect Answers
A:Run tests under analyst role against report and private objects. This concerns reading only a specific schema. Instead, test schema deployment and reject raw sensitive data query.
C:Query with two tenant identities and compare visibility. This concerns show each tenant only its own rows. Instead, test schema deployment and reject raw sensitive data query.
D:Test injection-like strings and inspect query behavior. This concerns protecting sensitive data from SQL injection. Instead, test schema deployment and reject raw sensitive data query.
Question 480
A database deployer must be unable to read private production data. A test instead finds: Deployment identity can export customer records. Which underlying issue best explains this finding?
- Transparent data encryption was not enabled or backed correctly
- The migration role was granted unnecessary data-reader rights
- AI tooling reused an elevated operational account
- DELETE permission was granted directly or via inherited role
Explanation
Correct Answer
B:The migration role was granted unnecessary data-reader rights. It accounts for the specific observed failure: deployment identity can export customer records. The intended solution is separate schema-deployment permission from data select rights with the required setup.
Incorrect Answers
A:Transparent data encryption was not enabled or backed correctly. This is relevant when a stolen database file is readable offline. Here, the migration role was granted unnecessary data-reader rights.
C:AI tooling reused an elevated operational account. This concerns tool executes delete on a business table. Here, the migration role was granted unnecessary data-reader rights.
D:DELETE permission was granted directly or via inherited role. This concerns editor can remove entire rows. Here, the migration role was granted unnecessary data-reader rights.
Developing AI-Enabled Database Solutions (DP-800) Practice Tests