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 39

Question 380

A repository contains examples that Copilot may use in suggestions. A test instead finds: Assistant repeats a credential from an example file. Which underlying issue best explains this finding?

  1. Generated SQL was trusted without privilege checks
  2. Instructions file is absent or not applied
  3. Unsafe examples were committed to accessible context
  4. Tenant or workspace feature prerequisites are not enabled

Explanation

Correct Answer

C:

Unsafe examples were committed to accessible context. It accounts for the specific observed failure: assistant repeats a credential from an example file. The intended solution is remove sensitive data and constrain repository access with the required setup.

Incorrect Answers

A:

Generated SQL was trusted without privilege checks. This concerns copilot-generated query reads a restricted table. Here, unsafe examples were committed to accessible context.

B:

Instructions file is absent or not applied. This concerns suggestions ignore established SQL code conventions. Here, unsafe examples were committed to accessible context.

D:

Tenant or workspace feature prerequisites are not enabled. This concerns assistant is inaccessible in a permitted workspace. Here, unsafe examples were committed to accessible context.

Question 381

A hospital protects payment numbers even from database administrators. Which database design or engineering approach most directly meets this requirement?

  1. Enable transparent data encryption
  2. Rotate column master key and update encrypted key metadata properly
  3. Use Always Encrypted for client-side column encryption
  4. Use SQL column-level encryption functions where appropriate

Explanation

Correct Answer

C:

Use Always Encrypted for client-side column encryption. The implementation is provision column encryption keys and compatible client driver; success can be checked by query as admin without keys and confirm ciphertext stays opaque. The method addresses the stated data and workload constraint.

Incorrect Answers

A:

Enable transparent data encryption. This concerns encryption of database files and backups at rest. Instead, use Always Encrypted for client-side column encryption.

B:

Rotate column master key and update encrypted key metadata properly. This concerns secure key rotation for always encrypted. Instead, use Always Encrypted for client-side column encryption.

D:

Use SQL column-level encryption functions where appropriate. This concerns developers need to encrypt one application field using SQL keys. Instead, use Always Encrypted for client-side column encryption.

Question 382

A hospital protects payment numbers even from database administrators. The team selects: Use Always Encrypted for client-side column encryption. Which implementation action puts this design into practice?

  1. Use GRANT UPDATE and explicit minimum SELECT permissions
  2. Manage symmetric keys, certificates and ENCRYPTBYKEY in approved code
  3. Configure database TDE with supported protector and key management
  4. Provision column encryption keys and compatible client driver

Explanation

Correct Answer

D:

Provision column encryption keys and compatible client driver. This is the concrete setup for use always encrypted for client-side column encryption, and query as admin without keys and confirm ciphertext stays opaque supplies a direct confirmation.

Incorrect Answers

A:

Use GRANT UPDATE and explicit minimum SELECT permissions. This concerns updating but not delete orders. Here, provision column encryption keys and compatible client driver.

B:

Manage symmetric keys, certificates and ENCRYPTBYKEY in approved code. This concerns developers need to encrypt one application field using SQL keys. Here, provision column encryption keys and compatible client driver.

C:

Configure database TDE with supported protector and key management. This concerns encryption of database files and backups at rest. Here, provision column encryption keys and compatible client driver.

Question 383

A hospital protects payment numbers even from database administrators. After implementing the design, which check most directly validates the expected behavior?

  1. Confirm function executes only approved stored procedures
  2. Query as admin without keys and confirm ciphertext stays opaque
  3. Open key and decrypt only as authorized principal
  4. Query with two tenant identities and compare visibility

Explanation

Correct Answer

B:

Query as admin without keys and confirm ciphertext stays opaque. This verifies the requirement in the case rather than merely confirming that a job ran; an opposing result can reveal that sensitive fields were encrypted server-side only rather than in the client.

Incorrect Answers

A:

Confirm function executes only approved stored procedures. This concerns permission to call a database. Instead, query as admin without keys and confirm ciphertext stays opaque.

C:

Open key and decrypt only as authorized principal. This concerns developers need to encrypt one application field using SQL keys. Instead, query as admin without keys and confirm ciphertext stays opaque.

D:

Query with two tenant identities and compare visibility. This concerns show each tenant only its own rows. Instead, query as admin without keys and confirm ciphertext stays opaque.

Question 384

A hospital protects payment numbers even from database administrators. A test instead finds: DBA sees payment plaintext during a normal SELECT. Which underlying issue best explains this finding?

  1. Sensitive fields were encrypted server-side only rather than in the client
  2. MCP server credential can access unapproved database objects
  3. Classification labels were not assigned to those fields
  4. Transparent data encryption was not enabled or backed correctly

Explanation

Correct Answer

A:

Sensitive fields were encrypted server-side only rather than in the client. It accounts for the specific observed failure: dba sees payment plaintext during a normal select. The intended solution is use always encrypted for client-side column encryption with the required setup.

Incorrect Answers

B:

MCP server credential can access unapproved database objects. This concerns agent lists protected schemas despite low privilege. Here, sensitive fields were encrypted server-side only rather than in the client.

C:

Classification labels were not assigned to those fields. This concerns sensitive columns are absent from inventory reports. Here, sensitive fields were encrypted server-side only rather than in the client.

D:

Transparent data encryption was not enabled or backed correctly. This is relevant when a stolen database file is readable offline. Here, sensitive fields were encrypted server-side only rather than in the client.

Question 385

A regulated app must execute server-side calculations over protected columns. Which THREE listed actions together specify the technical design, its concrete implementation, and a direct acceptance check? (Choose THREE.)

  1. Rotate column master key and update encrypted key metadata properly
  2. Use immutable external audit retention when required
  3. Configure enclave attestation and enclave-enabled encryption keys
  4. Use Always Encrypted with secure enclaves where supported
  5. Use SQL data classification metadata
  6. Test an approved enclave computation without plaintext exposure

Explanation

Correct Answers

C:

This is the concrete configuration of the specified design: configure enclave attestation and enclave-enabled encryption keys. The choice makes the implementation testable in the given workload.

D:

Use Always Encrypted with secure enclaves where supported. The implementation is configure enclave attestation and enclave-enabled encryption keys; success can be checked by test an approved enclave computation without plaintext exposure. The method addresses the stated data and workload constraint.

F:

This verification checks the intended behavior directly: test an approved enclave computation without plaintext exposure. It can expose the failure mode secure enclave support or attestation configuration is absent.

Incorrect Answers

A:

Rotate column master key and update encrypted key metadata properly. This concerns secure key rotation for always encrypted. Instead, configure enclave attestation and enclave-enabled encryption keys.

B:

Use immutable external audit retention when required. This concerns trustworthy records of security changes. Instead, configure enclave attestation and enclave-enabled encryption keys.

E:

Use SQL data classification metadata. This concerns searchable sensitivity tags on columns. Instead, configure enclave attestation and enclave-enabled encryption keys.

Question 386

A regulated app must execute server-side calculations over protected columns. The team selects: Use Always Encrypted with secure enclaves where supported. Which implementation action puts this design into practice?

  1. Manage symmetric keys, certificates and ENCRYPTBYKEY in approved code
  2. Apply sensitivity labels/information types to sensitive columns
  3. Configure enclave attestation and enclave-enabled encryption keys
  4. Configure DAB auth provider and action permissions

Explanation

Correct Answer

C:

Configure enclave attestation and enclave-enabled encryption keys. This is the concrete setup for use always encrypted with secure enclaves where supported, and test an approved enclave computation without plaintext exposure supplies a direct confirmation.

Incorrect Answers

A:

Manage symmetric keys, certificates and ENCRYPTBYKEY in approved code. This concerns developers need to encrypt one application field using SQL keys. Instead, configure enclave attestation and enclave-enabled encryption keys.

B:

Apply sensitivity labels/information types to sensitive columns. This concerns searchable sensitivity tags on columns. Instead, configure enclave attestation and enclave-enabled encryption keys.

D:

Configure DAB auth provider and action permissions. This concerns an external service calls a database-backed rest API. Instead, configure enclave attestation and enclave-enabled encryption keys.

Question 387

A regulated app must execute server-side calculations over protected columns. After implementing the design, which check most directly validates the expected behavior?

  1. Read secret from approved runtime while repo contains no plaintext
  2. Execute a test ALTER and confirm audit record arrival
  3. Test an approved enclave computation without plaintext exposure
  4. Verify procedure works and direct table read fails

Explanation

Correct Answer

C:

Test an approved enclave computation without plaintext exposure. This verifies the requirement in the case rather than merely confirming that a job ran; an opposing result can reveal that secure enclave support or attestation configuration is absent.

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, test an approved enclave computation without plaintext exposure.

B:

Execute a test ALTER and confirm audit record arrival. This concerns security officers need a durable record of database schema changes. Instead, test an approved enclave computation without plaintext exposure.

D:

Verify procedure works and direct table read fails. This concerns access one stored procedure. Instead, test an approved enclave computation without plaintext exposure.

Question 388

A regulated app must execute server-side calculations over protected columns. A test instead finds: Protected comparison fails despite proper client drivers. Which underlying issue best explains this finding?

  1. RLS predicate is missing or session context is untrusted
  2. REST endpoint authorization defaults were too permissive
  3. Secure enclave support or attestation configuration is absent
  4. Classification labels were not assigned to those fields

Explanation

Correct Answer

C:

Secure enclave support or attestation configuration is absent. It accounts for the specific observed failure: protected comparison fails despite proper client drivers. The intended solution is use always encrypted with secure enclaves where supported with the required setup.

Incorrect Answers

A:

RLS predicate is missing or session context is untrusted. This concerns tenant a can select rows belonging to tenant b. Here, secure enclave support or attestation configuration is absent.

B:

REST endpoint authorization defaults were too permissive. This concerns anonymous callers can query restricted entities. Here, secure enclave support or attestation configuration is absent.

D:

Classification labels were not assigned to those fields. This concerns sensitive columns are absent from inventory reports. Here, secure enclave support or attestation configuration is absent.

Question 389

A business needs encryption of database files and backups at rest. Which database design or engineering approach most directly meets this requirement?

  1. Capture SELECT access with supported SQL auditing
  2. Enable transparent data encryption
  3. Require authenticated Data API builder endpoint access
  4. Use Always Encrypted for client-side column encryption

Explanation

Correct Answer

B:

Enable transparent data encryption. The implementation is configure database tde with supported protector and key management; success can be checked by verify encryption state via supported sys.dm_database_encryption_keys. The method addresses the stated data and workload constraint.

Incorrect Answers

A:

Capture SELECT access with supported SQL auditing. This concerns recording which identity retrieved salary information. Instead, enable transparent data encryption.

C:

Require authenticated Data API builder endpoint access. This concerns an external service calls a database-backed rest API. Instead, enable transparent data encryption.

D:

Use Always Encrypted for client-side column encryption. This concerns a hospital protects payment numbers even from database administrators. Instead, enable transparent data encryption.

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.

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.