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 40

Question 390

A business needs encryption of database files and backups at rest. The team selects: Enable transparent data encryption. Which implementation action puts this design into practice?

  1. Use supported key rotation workflow with Key Vault and drivers
  2. Configure database TDE with supported protector and key management
  3. Create database principal for function identity and GRANT EXECUTE
  4. Create Entra principal and assign managed identity to workload

Explanation

Correct Answer

B:

Configure database TDE with supported protector and key management. This is the concrete setup for enable transparent data encryption, and verify encryption state via supported sys.dm_database_encryption_keys supplies a direct confirmation.

Incorrect Answers

A:

Use supported key rotation workflow with Key Vault and drivers. This concerns secure key rotation for always encrypted. Instead, configure database TDE with supported protector and key management.

C:

Create database principal for function identity and GRANT EXECUTE. This concerns permission to call a database. Instead, configure database TDE with supported protector and key management.

D:

Create Entra principal and assign managed identity to workload. This concerns authenticating without storing a SQL password. Instead, configure database TDE with supported protector and key management.

Question 391

A business needs encryption of database files and backups at rest. After implementing the design, which check most directly validates the expected behavior?

  1. Test an approved enclave computation without plaintext exposure
  2. Verify encryption state via supported sys.dm_database_encryption_keys
  3. Verify clients decrypt data after key rotation
  4. Test unauthorized calls receive access denial

Explanation

Correct Answer

B:

Verify encryption state via supported sys.dm_database_encryption_keys. This verifies the requirement in the case rather than merely confirming that a job ran; an opposing result can reveal that transparent data encryption was not enabled or backed correctly.

Incorrect Answers

A:

Test an approved enclave computation without plaintext exposure. This concerns executing server-side calculations over protected columns. Instead, verify encryption state via supported sys.dm_database_encryption_keys.

C:

Verify clients decrypt data after key rotation. This concerns secure key rotation for always encrypted. Instead, verify encryption state via supported sys.dm_database_encryption_keys.

D:

Test unauthorized calls receive access denial. This concerns an external service calls a database-backed rest API. Instead, verify encryption state via supported sys.dm_database_encryption_keys.

Question 392

A business needs encryption of database files and backups at rest. A test instead finds: A stolen database file is readable offline. Which underlying issue best explains this finding?

  1. REST endpoint authorization defaults were too permissive
  2. Transparent data encryption was not enabled or backed correctly
  3. Database lacks mapped principal or appropriate grant
  4. The migration role was granted unnecessary data-reader rights

Explanation

Correct Answer

B:

Transparent data encryption was not enabled or backed correctly. It accounts for the specific observed failure: a stolen database file is readable offline. The intended solution is enable transparent data encryption with the required setup.

Incorrect Answers

A:

REST endpoint authorization defaults were too permissive. This concerns anonymous callers can query restricted entities. Here, transparent data encryption was not enabled or backed correctly.

C:

Database lacks mapped principal or appropriate grant. This concerns function cannot authenticate despite a valid azure identity. Here, transparent data encryption was not enabled or backed correctly.

D:

The migration role was granted unnecessary data-reader rights. This concerns deployment identity can export customer records. Here, transparent data encryption was not enabled or backed correctly.

Question 393

A shared support portal should obscure salaries on standard queries. Which database design or engineering approach most directly meets this requirement?

  1. Separate schema-deployment permission from data SELECT rights
  2. Use Dynamic Data Masking to reduce casual exposure
  3. Use encryption for secrecy instead of relying on Dynamic Data Masking
  4. Use SQL data classification metadata

Explanation

Correct Answer

B:

Use Dynamic Data Masking to reduce casual exposure. The implementation is define a masked with function and restrict unmask permission; success can be checked by query as masked and privileged principals. The method addresses the stated data and workload constraint.

Incorrect Answers

A:

Separate schema-deployment permission from data SELECT rights. This concerns being unable to read private production data. Instead, use Dynamic Data Masking to reduce casual exposure.

C:

Use encryption for secrecy instead of relying on Dynamic Data Masking. This concerns distinguishing encrypted values from masked display values. Instead, use Dynamic Data Masking to reduce casual exposure.

D:

Use SQL data classification metadata. This concerns searchable sensitivity tags on columns. Instead, use Dynamic Data Masking to reduce casual exposure.

Question 394

A shared support portal should obscure salaries on standard queries. The team selects: Use Dynamic Data Masking to reduce casual exposure. Which implementation action puts this design into practice?

  1. Create database principal for function identity and GRANT EXECUTE
  2. GRANT VIEW DEFINITION or SELECT only where approved
  3. Define a MASKED WITH function and restrict UNMASK permission
  4. Apply appropriate protected-column encryption to sensitive data

Explanation

Correct Answer

C:

Define a MASKED WITH function and restrict UNMASK permission. This is the concrete setup for use dynamic data masking to reduce casual exposure, and query as masked and privileged principals supplies a direct confirmation.

Incorrect Answers

A:

Create database principal for function identity and GRANT EXECUTE. This concerns permission to call a database. Instead, define a MASKED WITH function and restrict UNMASK permission.

B:

GRANT VIEW DEFINITION or SELECT only where approved. This concerns segregated permissions for ai tooling. Instead, define a MASKED WITH function and restrict UNMASK permission.

D:

Apply appropriate protected-column encryption to sensitive data. This concerns distinguishing encrypted values from masked display values. Instead, define a MASKED WITH function and restrict UNMASK permission.

Question 395

A shared support portal should obscure salaries on standard queries. After implementing the design, which check most directly validates the expected behavior?

  1. Test schema deployment and reject raw sensitive data query
  2. Run role-specific queries for visible and hidden fields
  3. Query as masked and privileged principals
  4. Attempt direct export via privileged user without decrypt key

Explanation

Correct Answer

C:

Query as masked and privileged principals. This verifies the requirement in the case rather than merely confirming that a job ran; an opposing result can reveal that unmask permission or masking scope is misconfigured.

Incorrect Answers

A:

Test schema deployment and reject raw sensitive data query. This concerns being unable to read private production data. Instead, query as masked and privileged principals.

B:

Run role-specific queries for visible and hidden fields. This concerns secure graphql field access for different roles. Instead, query as masked and privileged principals.

D:

Attempt direct export via privileged user without decrypt key. This concerns distinguishing encrypted values from masked display values. Instead, query as masked and privileged principals.

Question 396

A shared support portal should obscure salaries on standard queries. A test instead finds: Support agents see all salary digits in results. Which underlying issue best explains this finding?

  1. Masking was mistaken for cryptographic confidentiality
  2. UNMASK permission or masking scope is misconfigured
  3. Secure enclave support or attestation configuration is absent
  4. The migration role was granted unnecessary data-reader rights

Explanation

Correct Answer

B:

UNMASK permission or masking scope is misconfigured. It accounts for the specific observed failure: support agents see all salary digits in results. The intended solution is use dynamic data masking to reduce casual exposure with the required setup.

Incorrect Answers

A:

Masking was mistaken for cryptographic confidentiality. This concerns privileged users retrieve underlying unmasked secret. The relevant SQL or system operation is UNMASK permission or masking scope is misconfigured.

C:

Secure enclave support or attestation configuration is absent. This concerns protected comparison fails despite proper client drivers. The relevant SQL or system operation is UNMASK permission or masking scope is misconfigured.

D:

The migration role was granted unnecessary data-reader rights. This concerns deployment identity can export customer records. The relevant SQL or system operation is UNMASK permission or masking scope is misconfigured.

Question 397

An analytics app must show each tenant only its own rows. Which database design or engineering approach most directly meets this requirement?

  1. Use Always Encrypted for client-side column encryption
  2. Use Row-Level Security with session-based tenant predicate
  3. Use Always Encrypted with secure enclaves where supported
  4. Audit effective permissions and role memberships

Explanation

Correct Answer

B:

Use Row-Level Security with session-based tenant predicate. The implementation is create inline tvf predicate and security policy; success can be checked by query with two tenant identities and compare visibility. The method addresses the stated data and workload constraint.

Incorrect Answers

A:

Use Always Encrypted for client-side column encryption. This concerns a hospital protects payment numbers even from database administrators. Instead, use Row-Level Security with session-based tenant predicate.

C:

Use Always Encrypted with secure enclaves where supported. This concerns executing server-side calculations over protected columns. Instead, use Row-Level Security with session-based tenant predicate.

D:

Audit effective permissions and role memberships. This concerns preventing accidental broad grants from roles. Instead, use Row-Level Security with session-based tenant predicate.

Question 398

An analytics app must show each tenant only its own rows. The team selects: Use Row-Level Security with session-based tenant predicate. Which implementation action puts this design into practice?

  1. Create inline TVF predicate and SECURITY POLICY
  2. Use fn_my_permissions or supported catalog views under principal
  3. Configure audit policy for sensitive object action
  4. Send SQL audit output to protected storage with retention controls

Explanation

Correct Answer

A:

Create inline TVF predicate and SECURITY POLICY. This is the concrete setup for use row-level security with session-based tenant predicate, and query with two tenant identities and compare visibility supplies a direct confirmation.

Incorrect Answers

B:

Use fn_my_permissions or supported catalog views under principal. This concerns preventing accidental broad grants from roles. Instead, create inline TVF predicate and SECURITY POLICY.

C:

Configure audit policy for sensitive object action. This concerns recording which identity retrieved salary information. Instead, create inline TVF predicate and SECURITY POLICY.

D:

Send SQL audit output to protected storage with retention controls. This concerns trustworthy records of security changes. Instead, create inline TVF predicate and SECURITY POLICY.

Question 399

An analytics app must show each tenant only its own rows. After implementing the design, which check most directly validates the expected behavior?

  1. Test an approved enclave computation without plaintext exposure
  2. Verify procedure works and direct table read fails
  3. Test effective access on representative securables
  4. Query with two tenant identities and compare visibility

Explanation

Correct Answer

D:

Query with two tenant identities and compare visibility. This verifies the requirement in the case rather than merely confirming that a job ran; an opposing result can reveal that rls predicate is missing or session context is untrusted.

Incorrect Answers

A:

Test an approved enclave computation without plaintext exposure. This concerns executing server-side calculations over protected columns. Instead, query with two tenant identities and compare visibility.

B:

Verify procedure works and direct table read fails. This concerns access one stored procedure. Instead, query with two tenant identities and compare visibility.

C:

Test effective access on representative securables. This concerns preventing accidental broad grants from roles. Instead, query with two tenant identities and compare visibility.

Question 400

An analytics app must show each tenant only its own rows. A test instead finds: Tenant A can SELECT rows belonging to tenant B. Which underlying issue best explains this finding?

  1. RLS predicate is missing or session context is untrusted
  2. MCP server credential can access unapproved database objects
  3. Secure enclave support or attestation configuration is absent
  4. Required symmetric key was not opened in that session

Explanation

Correct Answer

A:

RLS predicate is missing or session context is untrusted. It accounts for the specific observed failure: tenant a can select rows belonging to tenant b. The intended solution is use row-level security with session-based tenant predicate with the required setup.

Incorrect Answers

B:

MCP server credential can access unapproved database objects. This concerns agent lists protected schemas despite low privilege. The relevant SQL or system operation is RLS predicate is missing or session context is untrusted.

C:

Secure enclave support or attestation configuration is absent. This concerns protected comparison fails despite proper client drivers. The relevant SQL or system operation is RLS predicate is missing or session context is untrusted.

D:

Required symmetric key was not opened in that session. This concerns decryptbykey returns null unexpectedly. The relevant SQL or system operation is RLS predicate is missing or session context is untrusted.

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.