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 31

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.

Question 301

A multi-tenant portal needs tenant isolation plus exclusion of internal billing columns. Which approach would you recommend?

  1. Audit failed authentication attempts without leaking credentials
  2. Use separate key vault access policies for encryption operators
  3. Apply both row filtering and column projection for tenant privacy
  4. Revoke obsolete service account access after deployment

Explanation

Correct Answer

C:

Apply both row filtering and column projection for tenant privacy fits because it limits records and sensitive attributes exposed to users. That addresses the stated technical constraint.

Incorrect Answers

A:

That technique supports detection while avoiding secret collection. This does not meet the need for a method that limits records and sensitive attributes exposed to users.

B:

That technique confines ability to unwrap sensitive encrypted columns. This does not meet the need for a method that limits records and sensitive attributes exposed to users.

D:

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

Question 302

A service routine needs scoped execution rights independent of callers' broad membership. Which technical choice addresses this need?

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

Explanation

Correct Answer

B:

Apply ownership/EXECUTE AS module security only with review fits because it lets a stored procedure perform controlled work without general caller rights. That addresses the stated technical constraint.

Incorrect Answers

A:

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

C:

This alternative 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 option addresses a specific overbroad authorization path. This does not meet the need for a method that lets a stored procedure perform controlled work without general caller rights.

Question 303

A generated GraphQL endpoint is accessible to guest callers without required roles. 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. Secure a Data API builder endpoint with authentication and entity permissions
  4. Enable SQL auditing for sensitive access and changes

Explanation

Correct Answer

C:

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

B:

This option reduces exposure of the database endpoint to untrusted networks. This does not meet the need for a method that prevents anonymous broad access to SQL objects through REST or GraphQL.

D:

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

Question 304

A dashboard account should read a safe schema projection, not all underlying HR fields. Which approach would you recommend?

  1. Use DENY or remove unintended inherited broad access after reviewing effective permissions
  2. Grant SELECT on a narrowly scoped view instead of the base table
  3. Use Dynamic Data Masking for supported nonprivileged query display
  4. Implement Row-Level Security with a validated security predicate

Explanation

Correct Answer

B:

Grant SELECT on a narrowly scoped view instead of the base table is the appropriate choice: it exposes only approved projected data. The deployment should be tested with representative data.

Incorrect Answers

A:

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

C:

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

D:

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

Question 305

An application uses an Azure-hosted external model and must authenticate without plaintext API keys. What should the engineer choose?

  1. Use network-level TLS and application authorization together
  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

C:

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

Incorrect Answers

A:

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

B:

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

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

Question 306

A CI job needs predictable data for SQL unit tests without copying real employee records. Which implementation is the best fit?

  1. Use authorized test data instead of production PII for development
  2. Use server-side validation of user-supplied tenant identity
  3. Use separate key vault access policies for encryption operators
  4. Revoke obsolete service account access after deployment

Explanation

Correct Answer

A:

This implementation protects customer information in CI test pipelines.

Incorrect Answers

B:

This choice rejects tenant IDs chosen solely through client parameters. This does not meet the need for a method that protects customer information in CI test pipelines.

C:

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

D:

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

Question 307

Security monitors repeated access failures and needs caller/time metadata. Which technical choice addresses this need?

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

Explanation

Correct Answer

A:

Audit failed authentication attempts without leaking credentials fits because it supports detection while avoiding secret collection. That addresses the stated technical constraint.

Incorrect Answers

B:

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

C:

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

D:

This option limits records and sensitive attributes exposed to users. This does not meet the need for a method that supports detection while avoiding secret collection.

Question 308

A service needs alerting on suspicious login bursts without capturing authentication tokens. Which approach would you recommend?

  1. Use authorized test data instead of production PII for development
  2. Audit failed authentication attempts without leaking credentials
  3. Use separate key vault access policies for encryption operators
  4. Apply both row filtering and column projection for tenant privacy

Explanation

Correct Answer

B:

Audit failed authentication attempts without leaking credentials is the appropriate choice: it supports detection while avoiding secret collection. The deployment should be tested with representative data.

Incorrect Answers

A:

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

C:

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

D:

This alternative limits records and sensitive attributes exposed to users. This does not meet the need for a method that supports detection while avoiding secret collection.

Question 309

A service needs database-enforced record visibility rather than trusting every API filter. What should the SQL developer implement?

  1. Use DENY or remove unintended inherited broad access after reviewing effective permissions
  2. Create database roles and grant only the required permissions
  3. Use Dynamic Data Masking for supported nonprivileged query display
  4. Implement Row-Level Security with a validated security predicate

Explanation

Correct Answer

D:

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

Incorrect Answers

A:

This option addresses a specific overbroad authorization path. This does not meet the need for a method that filters rows according to an execution context or predicate.

B:

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

C:

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

Question 310

An integration architecture needs both transport confidentiality and least-privilege access. Which approach would you recommend?

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

Explanation

Correct Answer

C:

This approach combines encrypted transport with verified caller permissions.

Incorrect Answers

A:

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

D:

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

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