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 27

Question 260

An old CI agent retains production SQL write permissions after retirement. Which technical choice addresses this need?

  1. Use server-side validation of user-supplied tenant identity
  2. Apply both row filtering and column projection for tenant privacy
  3. Revoke obsolete service account access after deployment
  4. Use authorized test data instead of production PII for development

Explanation

Correct Answer

C:

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

Incorrect Answers

A:

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

B:

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:

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

A REST endpoint uses HTTPS but accidentally lets unauthenticated users list records. What should the engineer choose?

  1. Use network-level TLS and application authorization together
  2. Use a private endpoint or restricted networking for a sensitive SQL service
  3. Enable SQL auditing for sensitive access and changes
  4. Validate the identity and authorization of an MCP tool caller

Explanation

Correct Answer

A:

This choice combines encrypted transport with verified caller permissions.

Incorrect Answers

B:

That technique reduces exposure of the database endpoint to untrusted networks. This does not meet the need for a method that combines encrypted transport with verified caller permissions.

C:

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

D:

That technique prevents an AI agent bypassing database access controls. This does not meet the need for a method that combines encrypted transport with verified caller permissions.

Question 262

A test account can read a confidential table despite a narrower role grant. Which approach would you recommend?

  1. Implement Row-Level Security with a validated security predicate
  2. Use DENY or remove unintended inherited broad access after reviewing effective permissions
  3. Use Dynamic Data Masking for supported nonprivileged query display
  4. Apply ownership/EXECUTE AS module security only with review

Explanation

Correct Answer

B:

This implementation fits because it addresses a specific overbroad authorization path. That addresses the stated technical constraint.

Incorrect Answers

A:

This choice filters rows according to an execution context or predicate. 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 alternative 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.

Question 263

An Azure workload must connect to an authorized Azure SQL database without a hardcoded password. What should the SQL developer implement?

  1. Use column-level encryption when applications can manage selected ciphertext values
  2. Use Microsoft Entra authentication or managed identity where supported
  3. Use Always Encrypted for designated sensitive columns with supported client drivers
  4. Rotate and secure database encryption keys with a governed recovery plan

Explanation

Correct Answer

B:

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

Incorrect Answers

A:

This choice encrypts selected data using SQL cryptographic functions and key management. This does not meet the need for a method that avoids application-stored long-lived SQL passwords.

C:

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

D:

This choice manages cryptographic key lifecycle and database recoverability. This does not meet the need for a method that avoids application-stored long-lived SQL passwords.

Question 264

An audit team needs a history of administrative permission changes. Which implementation is the best fit?

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

B:

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:

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.

C:

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.

D:

This alternative prevents anonymous broad access to SQL objects through REST or GraphQL. This does not meet the need for a method that records reviewable database events for investigation and compliance.

Question 265

A caller can change a URL query parameter to request another tenant's data. Which approach would you recommend?

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

Explanation

Correct Answer

B:

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

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.

D:

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

Question 266

An organization needs storage-at-rest protection for a database containing many existing tables. Which implementation is the best fit?

  1. Use Transparent Data Encryption for database files at rest
  2. Use TLS-encrypted connections with certificate validation
  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 encrypts database files and backups without changing each column query.

Incorrect Answers

B:

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

C:

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

D:

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

Question 267

An organization changes key custodians and needs auditable rotation of access. What should the SQL developer implement?

  1. Use Microsoft Entra authentication or managed identity where supported
  2. Use Always Encrypted for designated sensitive columns with supported client drivers
  3. Use TLS-encrypted connections with certificate validation
  4. Rotate and secure database encryption keys with a governed recovery plan

Explanation

Correct Answer

D:

This implementation manages cryptographic key lifecycle and database recoverability.

Incorrect Answers

A:

That technique avoids application-stored long-lived SQL passwords. This does not meet the need for a method that manages cryptographic key lifecycle and database recoverability.

B:

This option protects designated values from exposure to ordinary database-engine operators. This does not meet the need for a method that manages cryptographic key lifecycle and database recoverability.

C:

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

Question 268

An analytics team is onboarding several read-only service accounts to the same small reporting schema. Each should get the approved SELECT rights through one manageable database authorization unit, never db_owner. What is the best design?

  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. Create database roles and grant only the required permissions

Explanation

Correct Answer

D:

Create database roles and grant only the required permissions fits because it reduces excessive per-user object privileges. That addresses the stated technical constraint.

Incorrect Answers

A:

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

B:

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

C:

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

Question 269

Developers propose restoring a full customer database into an unprotected test environment. What is the most appropriate next design step?

  1. Use separate key vault access policies for encryption operators
  2. Use authorized test data instead of production PII for development
  3. Revoke obsolete service account access after deployment
  4. Audit failed authentication attempts without leaking credentials

Explanation

Correct Answer

B:

This implementation protects customer information in CI test pipelines.

Incorrect Answers

A:

This alternative confines ability to unwrap sensitive encrypted columns. This does not meet the need for a method that protects customer information in CI test pipelines.

C:

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

D:

This alternative supports detection while avoiding secret collection. This does not meet the need for a method that protects customer information in CI test pipelines.

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.

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