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 30

Question 290

A permissions audit finds a group membership granting undesired writes. Which change most directly meets the requirement?

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

Explanation

Correct Answer

A:

This implementation addresses a specific overbroad authorization path.

Incorrect Answers

B:

This choice lets a stored procedure perform controlled work without general caller rights. This does not meet the need for a method that addresses a specific overbroad authorization path.

C:

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

D:

This choice reduces excessive per-user object privileges. This does not meet the need for a method that addresses a specific overbroad authorization path.

Question 291

A cloud-hosted service wants token-based SQL authentication with centrally managed identity. What is the most appropriate next design step?

  1. Use Always Encrypted for designated sensitive columns with supported client drivers
  2. Use TLS-encrypted connections with certificate validation
  3. Use Transparent Data Encryption for database files at rest
  4. Use Microsoft Entra authentication or managed identity where supported

Explanation

Correct Answer

D:

This implementation avoids application-stored long-lived SQL passwords.

Incorrect Answers

A:

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

B:

That technique protects data moving between clients and the database endpoint. This does not meet the need for a method that avoids application-stored long-lived SQL passwords.

C:

This option encrypts database files and backups without changing each column query. This does not meet the need for a method that avoids application-stored long-lived SQL passwords.

Question 292

A compliance baseline mandates encryption of all database data files and compatible backups. Which approach would you recommend?

  1. Use TLS-encrypted connections with certificate validation
  2. Use Always Encrypted for designated sensitive columns with supported client drivers
  3. Use column-level encryption when applications can manage selected ciphertext values
  4. Use Transparent Data Encryption for database files at rest

Explanation

Correct Answer

D:

This implementation fits because it encrypts database files and backups without changing each column query. That addresses the stated technical constraint.

Incorrect Answers

A:

That technique protects data moving between clients and the database endpoint. This does not meet the need for a method that encrypts database files and backups without changing each column query.

B:

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

C:

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

Question 293

A lower-privileged dashboard needs masked email addresses without changing underlying stored data. What is the most appropriate next design step?

  1. Grant SELECT on a narrowly scoped view instead of the base table
  2. Use Dynamic Data Masking for supported nonprivileged query display
  3. Apply ownership/EXECUTE AS module security only with review
  4. Use DENY or remove unintended inherited broad access after reviewing effective permissions

Explanation

Correct Answer

B:

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

Incorrect Answers

A:

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

C:

This choice 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.

D:

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.

Question 294

A Copilot connector uses a global service identity without differentiating allowed operations. 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. Use network-level TLS and application authorization together
  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 is the appropriate choice: it prevents an AI agent bypassing database access controls. The deployment should be tested with representative data.

Incorrect Answers

A:

That technique 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:

This option 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 alternative combines encrypted transport with verified caller permissions. This does not meet the need for a method that prevents an AI agent bypassing database access controls.

Question 295

A superseded reporting service still has an active database login. Which change most directly meets the requirement?

  1. Audit failed authentication attempts without leaking credentials
  2. Revoke obsolete service account access after deployment
  3. Apply both row filtering and column projection for tenant privacy
  4. Use authorized test data instead of production PII for development

Explanation

Correct Answer

B:

This approach removes credential paths no longer required by running workloads.

Incorrect Answers

A:

This option supports detection while avoiding secret collection. This does not meet the need for a method that removes credential paths no longer required by running workloads.

C:

This choice limits records and sensitive attributes exposed to users. This does not meet the need for a method that removes credential paths no longer required by running workloads.

D:

This alternative protects customer information in CI test pipelines. This does not meet the need for a method that removes credential paths no longer required by running workloads.

Question 296

A database login is authorized but the SQL connection does not validate its certificate. Which approach would you recommend?

  1. Enable SQL auditing for sensitive access and changes
  2. Secure a Data API builder endpoint with authentication and entity permissions
  3. Use network-level TLS and application authorization together
  4. Use managed identity for an Azure-hosted model endpoint call

Explanation

Correct Answer

C:

This implementation combines encrypted transport with verified caller permissions.

Incorrect Answers

A:

This alternative records reviewable database events for investigation and compliance. This does not meet the need for a method that combines encrypted transport with verified caller permissions.

B:

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

D:

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

Question 297

A GraphQL request includes a user-controlled tenantId with no identity binding. Which implementation is the best fit?

  1. Revoke obsolete service account access after deployment
  2. Audit failed authentication attempts without leaking credentials
  3. Apply both row filtering and column projection for tenant privacy
  4. Use server-side validation of user-supplied tenant identity

Explanation

Correct Answer

D:

This approach rejects tenant IDs chosen solely through client parameters.

Incorrect Answers

A:

This alternative removes credential paths no longer required by running workloads. This does not meet the need for a method that rejects tenant IDs chosen solely through client parameters.

B:

This choice supports detection while avoiding secret collection. This does not meet the need for a method that rejects tenant IDs chosen solely through client parameters.

C:

This alternative limits records and sensitive attributes exposed to users. This does not meet the need for a method that rejects tenant IDs chosen solely through client parameters.

Question 298

A regulated system must record access to sensitive records according to policy. Which implementation is the best fit?

  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. Validate the identity and authorization of an MCP tool caller
  4. Enable SQL auditing for sensitive access and changes

Explanation

Correct Answer

D:

Enable SQL auditing for sensitive access and changes is the appropriate choice: it records reviewable database events for investigation and compliance. The deployment should be tested with representative data.

Incorrect Answers

A:

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

B:

This choice reduces exposure of the database endpoint to untrusted networks. This does not meet the need for a method that records reviewable database events for investigation and compliance.

C:

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

Question 299

A database client transmits secrets over an untrusted network segment. Which change most directly meets the requirement?

  1. Use TLS-encrypted connections with certificate validation
  2. Use Transparent Data Encryption for database files at rest
  3. Use Always Encrypted for designated sensitive columns with supported client drivers
  4. Use Microsoft Entra authentication or managed identity where supported

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 choice encrypts database files and backups without changing each column query. This does not meet the need for a method that protects data moving between clients and the database endpoint.

C:

This alternative 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.

D:

This alternative avoids application-stored long-lived SQL passwords. This does not meet the need for a method that protects data moving between clients and the database endpoint.

Question 300

Each regional manager may query only records assigned to their own region. Which solution best satisfies the stated constraint?

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

Explanation

Correct Answer

C:

This implementation filters rows according to an execution context or predicate.

Incorrect Answers

A:

This choice obscures selected output values without replacing true access controls. This does not meet the need for a method that filters rows according to an execution context or predicate.

B:

This choice 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.

D:

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.

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