Microsoft DP-800 Exam Dumps, Practice Test Questions

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

Microsoft DP-800  Premium File
$54.99
$49.99

DP-800 Premium File

  • Premium File: 101 Questions & Answers. Last update: Nov 9, 2026
  • Latest Questions
  • 100% Accurate Answers
  • Fast Exam Updates

DP-800 Premium File

Microsoft DP-800  Premium File
  • Premium File: 101 Questions & Answers. Last update: Nov 9, 2026
  • Latest Questions
  • 100% Accurate Answers
  • Fast Exam Updates
$54.99
$49.99

Microsoft DP-800 Practice Test 48

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?

  1. Apply sensitivity labels/information types to sensitive columns
  2. Configure enclave attestation and enclave-enabled encryption keys
  3. Use GRANT UPDATE and explicit minimum SELECT permissions
  4. 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?

  1. Query as admin without keys and confirm ciphertext stays opaque
  2. Inspect classified metadata and reporting output
  3. Attempt unauthorized metadata discovery and confirm denial
  4. 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?

  1. Secure enclave support or attestation configuration is absent
  2. Masking was mistaken for cryptographic confidentiality
  3. Sensitive fields were encrypted server-side only rather than in the client
  4. 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?

  1. Use managed identity and scoped endpoint permissions
  2. Require scoped authentication and permissioned tools
  3. Authorize its managed identity with least privileges
  4. 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?

  1. Create minimal integration role and GRANT EXECUTE
  2. Bind MCP server to least-privilege SQL identity and secure transport
  3. Assign workload identity to endpoint access role
  4. 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?

  1. Attempt unauthorized metadata discovery and confirm denial
  2. Confirm authorized call succeeds and disallowed call fails
  3. Run AI tool as its role and test blocked operations
  4. 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?

  1. MCP server credential can access unapproved database objects
  2. Endpoint authentication was not migrated to managed identity
  3. Required symmetric key was not opened in that session
  4. 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?

  1. Grant SELECT on the reporting schema and restrict others
  2. Parameterize statements and restrict SQL principal rights
  3. Use SQL data classification metadata
  4. 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?

  1. Grant managed identity a limited vault data-plane role
  2. Create a report reader role with scoped GRANT SELECT
  3. Use supported key rotation workflow with Key Vault and drivers
  4. 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?

  1. Run tests under analyst role against report and private objects
  2. Test schema deployment and reject raw sensitive data query
  3. Query with two tenant identities and compare visibility
  4. 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?

  1. Transparent data encryption was not enabled or backed correctly
  2. The migration role was granted unnecessary data-reader rights
  3. AI tooling reused an elevated operational account
  4. 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

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.