McAfee Secured

Exam Code: DP-800

Exam Name: Developing AI-Enabled Database Solutions

Certification Provider: Microsoft

Corresponding Certification: Microsoft Certified: SQL AI Developer Associate

100% Microsoft DP-800 Guaranteed Success With Testking Training Materials

Get Real DP-800 Exam Questions & Expert Verified Answers as Experienced on the Real Exam!

101 Questions & Answers with Testing Engine

"Developing AI-Enabled Database Solutions Exam", also known as DP-800 exam, is a Microsoft certification exam.

Pass your tests with the always up-to-date DP-800 Exam Engine. Your DP-800 training materials keep you at the head of the pack!

Satisfaction Guaranteed

Money Back Guarantee

Testking provides hassle-free money back guarantee with our products. That is because we have 100% trust in the abilities of our professional and experience product team, and our record is a proof of that.

99.6% PASS RATE
Was: $137.49
Now: $124.99

Microsoft DP-800 Practice Test 28

Question 270

A legacy application has two extremely sensitive fields and accepts explicit encrypt/decrypt logic. What is the most appropriate design decision?

  1. Use Always Encrypted for designated sensitive columns with supported client drivers
  2. Rotate and secure database encryption keys with a governed recovery plan
  3. Use Transparent Data Encryption for database files at rest
  4. Use column-level encryption when applications can manage selected ciphertext values

Explanation

Correct Answer

D:

This choice encrypts selected data using SQL cryptographic functions and key management.

Incorrect Answers

A:

That technique protects designated values from exposure to ordinary database-engine operators. This does not meet the need for a method that encrypts selected data using SQL cryptographic functions and key management.

B:

This option manages cryptographic key lifecycle and database recoverability. This does not meet the need for a method that encrypts selected data using SQL cryptographic functions and key management.

C:

This choice encrypts database files and backups without changing each column query. This does not meet the need for a method that encrypts selected data using SQL cryptographic functions and key management.

Question 271

A general support role should see partial account numbers for screen display. What is the most appropriate design decision?

  1. Create database roles and grant only the required permissions
  2. Use DENY or remove unintended inherited broad access after reviewing effective permissions
  3. Apply ownership/EXECUTE AS module security only with review
  4. Use Dynamic Data Masking for supported nonprivileged query display

Explanation

Correct Answer

D:

This implementation obscures selected output values without replacing true access controls.

Incorrect Answers

A:

This alternative reduces excessive per-user object privileges. This does not meet the need for a method that obscures selected output values without replacing true access controls.

B:

This choice addresses a specific overbroad authorization path. This does not meet the need for a method that obscures selected output values without replacing true access controls.

C:

This alternative lets a stored procedure perform controlled work without general caller rights. This does not meet the need for a method that obscures selected output values without replacing true access controls.

Question 272

A reporting vendor needs approved columns but must not see base-table salary data. Which solution is most directly applicable?

  1. Use Dynamic Data Masking for supported nonprivileged query display
  2. Use DENY or remove unintended inherited broad access after reviewing effective permissions
  3. Create database roles and grant only the required permissions
  4. Grant SELECT on a narrowly scoped view instead of the base table

Explanation

Correct Answer

D:

Grant SELECT on a narrowly scoped view instead of the base table fits because it exposes only approved projected data. That addresses the stated technical constraint.

Incorrect Answers

A:

This choice obscures selected output values without replacing true access controls. This does not meet the need for a method that exposes only approved projected data.

B:

This option addresses a specific overbroad authorization path. This does not meet the need for a method that exposes only approved projected data.

C:

This option reduces excessive per-user object privileges. This does not meet the need for a method that exposes only approved projected data.

Question 273

A multi-tenant app must prevent tenant A from reading tenant B rows in a shared table. Which technical choice addresses this need?

  1. Implement Row-Level Security with a validated security predicate
  2. Grant SELECT on a narrowly scoped view instead of the base table
  3. Apply ownership/EXECUTE AS module security only with review
  4. Create database roles and grant only the required permissions

Explanation

Correct Answer

A:

Implement Row-Level Security with a validated security predicate is the appropriate choice: it filters rows according to an execution context or predicate. The deployment should be tested with representative data.

Incorrect Answers

B:

This choice exposes only approved projected data. This does not meet the need for a method that filters rows according to an execution context or predicate.

C:

This choice lets a stored procedure perform controlled work without general caller rights. This does not meet the need for a method that filters rows according to an execution context or predicate.

D:

That technique reduces excessive per-user object privileges. This does not meet the need for a method that filters rows according to an execution context or predicate.

Question 274

A healthcare application must keep patient identifiers encrypted while the SQL service handles queries. What should the SQL developer implement?

  1. Use Microsoft Entra authentication or managed identity where supported
  2. Use Transparent Data Encryption for database files at rest
  3. Use column-level encryption when applications can manage selected ciphertext values
  4. Use Always Encrypted for designated sensitive columns with supported client drivers

Explanation

Correct Answer

D:

This choice protects designated values from exposure to ordinary database-engine operators.

Incorrect Answers

A:

This alternative avoids application-stored long-lived SQL passwords. This does not meet the need for a method that protects designated values from exposure to ordinary database-engine operators.

B:

That technique encrypts database files and backups without changing each column query. This does not meet the need for a method that protects designated values from exposure to ordinary database-engine operators.

C:

This option encrypts selected data using SQL cryptographic functions and key management. This does not meet the need for a method that protects designated values from exposure to ordinary database-engine operators.

Question 275

A database-side workflow calls an approved Azure AI endpoint and needs credential lifecycle control. Which technical choice addresses this need?

  1. Use managed identity for an Azure-hosted model endpoint call
  2. Use a private endpoint or restricted networking for a sensitive SQL service
  3. Enable SQL auditing for sensitive access and changes
  4. Use network-level TLS and application authorization together

Explanation

Correct Answer

A:

This implementation fits because it avoids embedding static model API credentials in SQL code. That addresses the stated technical constraint.

Incorrect Answers

B:

This option reduces exposure of the database endpoint to untrusted networks. This does not meet the need for a method that avoids embedding static model API credentials in SQL code.

C:

That technique records reviewable database events for investigation and compliance. This does not meet the need for a method that avoids embedding static model API credentials in SQL code.

D:

This choice combines encrypted transport with verified caller permissions. This does not meet the need for a method that avoids embedding static model API credentials in SQL code.

Question 276

A cloud SQL application can read data but should not administer master keys. Which technical choice addresses this need?

  1. Use separate key vault access policies for encryption operators
  2. Revoke obsolete service account access after deployment
  3. Use server-side validation of user-supplied tenant identity
  4. Audit failed authentication attempts without leaking credentials

Explanation

Correct Answer

A:

This approach confines ability to unwrap sensitive encrypted columns.

Incorrect Answers

B:

This alternative removes credential paths no longer required by running workloads. This does not meet the need for a method that confines ability to unwrap sensitive encrypted columns.

C:

That technique rejects tenant IDs chosen solely through client parameters. This does not meet the need for a method that confines ability to unwrap sensitive encrypted columns.

D:

This option supports detection while avoiding secret collection. This does not meet the need for a method that confines ability to unwrap sensitive encrypted columns.

Question 277

A partner must invoke one approved update procedure but not edit tables directly. Which solution is most directly applicable?

  1. Apply ownership/EXECUTE AS module security only with review
  2. Create database roles and grant only the required permissions
  3. Implement Row-Level Security with a validated security predicate
  4. Use Dynamic Data Masking for supported nonprivileged query display

Explanation

Correct Answer

A:

Apply ownership/EXECUTE AS module security only with review is the appropriate choice: it lets a stored procedure perform controlled work without general caller rights. The deployment should be tested with representative data.

Incorrect Answers

B:

This option reduces excessive per-user object privileges. This does not meet the need for a method that lets a stored procedure perform controlled work without general caller rights.

C:

This option filters rows according to an execution context or predicate. This does not meet the need for a method that lets a stored procedure perform controlled work without general caller rights.

D:

This choice obscures selected output values without replacing true access controls. This does not meet the need for a method that lets a stored procedure perform controlled work without general caller rights.

Question 278

A new DAB service exposes a confidential table over HTTP. What is the most appropriate design decision?

  1. Validate the identity and authorization of an MCP tool caller
  2. Use network-level TLS and application authorization together
  3. Use managed identity for an Azure-hosted model endpoint call
  4. Secure a Data API builder endpoint with authentication and entity permissions

Explanation

Correct Answer

D:

Secure a Data API builder endpoint with authentication and entity permissions is the appropriate choice: it prevents anonymous broad access to SQL objects through REST or GraphQL. The deployment should be tested with representative data.

Incorrect Answers

A:

This option prevents an AI agent bypassing database access controls. This does not meet the need for a method that prevents anonymous broad access to SQL objects through REST or GraphQL.

B:

This option combines encrypted transport with verified caller permissions. This does not meet the need for a method that prevents anonymous broad access to SQL objects through REST or GraphQL.

C:

This alternative avoids embedding static model API credentials in SQL code. This does not meet the need for a method that prevents anonymous broad access to SQL objects through REST or GraphQL.

Question 279

A remote app currently connects to SQL without verifying the server certificate. Which implementation is the best fit?

  1. Use TLS-encrypted connections with certificate validation
  2. Use column-level encryption when applications can manage selected ciphertext values
  3. Rotate and secure database encryption keys with a governed recovery plan
  4. Use Always Encrypted for designated sensitive columns with supported client drivers

Explanation

Correct Answer

A:

This implementation fits because it protects data moving between clients and the database endpoint. That addresses the stated technical constraint.

Incorrect Answers

B:

This option encrypts selected data using SQL cryptographic functions and key management. This does not meet the need for a method that protects data moving between clients and the database endpoint.

C:

That technique manages cryptographic key lifecycle and database recoverability. This does not meet the need for a method that protects data moving between clients and the database endpoint.

D:

That technique protects designated values from exposure to ordinary database-engine operators. This does not meet the need for a method that protects data moving between clients and the database endpoint.

Question 280

An agent tool endpoint can read customer tables but lacks caller-specific authorization. What should the SQL developer implement?

  1. Use a private endpoint or restricted networking for a sensitive SQL service
  2. Use managed identity for an Azure-hosted model endpoint call
  3. Enable SQL auditing for sensitive access and changes
  4. Validate the identity and authorization of an MCP tool caller

Explanation

Correct Answer

D:

Validate the identity and authorization of an MCP tool caller fits because it prevents an AI agent bypassing database access controls. That addresses the stated technical constraint.

Incorrect Answers

A:

This option reduces exposure of the database endpoint to untrusted networks. This does not meet the need for a method that prevents an AI agent bypassing database access controls.

B:

That technique avoids embedding static model API credentials in SQL code. This does not meet the need for a method that prevents an AI agent bypassing database access controls.

C:

This choice records reviewable database events for investigation and compliance. This does not meet the need for a method that prevents an AI agent bypassing database access controls.

Developing AI-Enabled Database Solutions (DP-800) Practice Tests