McAfee Secure

Exam Code: DP-800

Exam Name: Developing AI-Enabled Database Solutions

Certification Provider: Microsoft

Corresponding Certification: Microsoft Certified: SQL AI Developer Associate

Questions & Answers

Microsoft DP-800 Questions & Answers

Study with Up-To-Date REAL Exam Questions and Answers from the ACTUAL Test

Questions & Answers

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 87

Question 860

A schema migration changes a base column used by multiple schema-bound dependencies. Which implementation decision BEST addresses this requirement?

  1. Use a supported write path or redesign the view rather than assuming all views are updatable.
  2. Rewrite the DML trigger to handle the inserted/deleted pseudo-tables as sets.
  3. Inspect the function execution mode and consider set-based expressions or eligible scalar UDF inlining.
  4. Review dependency effects and change the schema-bound view deliberately before modifying underlying objects.

Explanation

Correct Answer

D:

Review dependency effects and change the schema-bound view deliberately before modifying underlying objects. This targets the primary issue because SCHEMABINDING protects referenced definitions against incompatible schema changes. Verification: A migration test catches incompatible column modification before production. Prevent recurrence: Track dependent objects through versioned migrations.

Incorrect Answers

A:

Aggregate views are not generally directly updatable like simple single-table projections.

B:

SQL triggers run per statement and inserted can contain multiple rows.

C:

Per-row scalar function calls may create expensive repeated execution on some workloads.

Question 861

A team stores edge relationships in comma-separated strings instead of graph edges. Which acceptance check is MOST directly related to this scenario?

  1. Queries find related entities after a validated data migration.
  2. A sample network returns the known minimal path when explicitly requested.
  3. Month-over-month differences match a reference table.
  4. An order with three lines produces the correct three-element array.

Explanation

Correct Answer

A:

Queries find related entities after a validated data migration. This is the decisive observable evidence after implementing normalize relationships into graph edge tables before using MATCH. It tests the underlying requirement: The graph pattern engine expects node/edge structures, not arbitrary string lists.

Incorrect Answers

B:

A sample network returns the known minimal path when explicitly requested. However, that result would not establish the required outcome: queries find related entities after a validated data migration.

C:

Month-over-month differences match a reference table. However, that result would not establish the required outcome: queries find related entities after a validated data migration.

D:

An order with three lines produces the correct three-element array. However, that result would not establish the required outcome: queries find related entities after a validated data migration.

Question 862

A DBA suspects one SQL statement drives most CPU usage during office hours. Which technical property or constraint MOST directly matters here?

  1. Platform-native query insight tools expose historical workload statistics for managed instances.
  2. Instance metrics alone do not identify which cached statements consume resources.
  3. Optimistic concurrency only works if conflicts are detected, not silently overwritten.
  4. Serializable range protection can reduce throughput and increase blocking.

Explanation

Correct Answer

B:

Instance metrics alone do not identify which cached statements consume resources. This explains why the corrective action is to use relevant DMVs and Query Store runtime statistics to isolate resource-intensive statements. Confirm the diagnosis when top CPU queries correlate with observed workload and waits.

Incorrect Answers

A:

Platform-native query insight tools expose historical workload statistics for managed instances. The actual technical constraint is that instance metrics alone do not identify which cached statements consume resources.

C:

Optimistic concurrency only works if conflicts are detected, not silently overwritten. The actual technical constraint is that instance metrics alone do not identify which cached statements consume resources.

D:

Serializable range protection can reduce throughput and increase blocking. The actual technical constraint is that instance metrics alone do not identify which cached statements consume resources.

Question 863

A SQL developer wants editor suggestions inside a repository but has no enterprise Copilot entitlement. Which preventive practice BEST addresses the underlying risk over time?

  1. Revalidate Fabric feature availability when capacity policies change.
  2. Version guidance with source code and test patterns.
  3. Record feature enablement and organizational restrictions.
  4. Maintain a controlled model catalog and audit changes.

Explanation

Correct Answer

C:

Record feature enablement and organizational restrictions. This guards against recurrence because editor AI availability depends on licensing, identity and permitted configuration. The direct remediation is: Confirm approved GitHub Copilot seat, editor extension and organization policy.

Incorrect Answers

A:

Revalidate Fabric feature availability when capacity policies change. The current task instead requires this action: record feature enablement and organizational restrictions.

B:

Version guidance with source code and test patterns. The current task instead requires this action: record feature enablement and organizational restrictions.

D:

Maintain a controlled model catalog and audit changes. The current task instead requires this action: record feature enablement and organizational restrictions.

Question 864

A Fabric lakehouse MCP endpoint returns authorization failures for a service principal. What should the SQL developer do FIRST to address the specific issue?

  1. Reject the endpoint until source, TLS identity and tool effects are reviewed.
  2. Remove and rotate exposed secrets; use approved enterprise AI surfaces and sanitized prompts.
  3. Treat generated SQL as untrusted and require security review before execution.
  4. Check the configured workspace identity, connector permissions and supported MCP authentication.

Explanation

Correct Answer

D:

Check the configured workspace identity, connector permissions and supported MCP authentication. This targets the primary issue because MCP access to a lakehouse is constrained by Fabric and identity permissions. Verification: An approved read operation succeeds while a forbidden workspace remains denied. Prevent recurrence: Keep principal grants least-privilege and monitored.

Incorrect Answers

A:

A malicious or compromised MCP server may exfiltrate data or supply unsafe tool behavior.

B:

AI chat providers and extensions may retain shared content outside the database boundary.

C:

Generated code can violate least privilege even if it appears syntactically correct.

Question 865

A vector search system reports fast p50 latency but fails badly on rare terminology. Which acceptance check is MOST directly related to this scenario?

  1. A labeled benchmark meets recall for both common and rare queries.
  2. A controlled evaluation shows acceptable citations and answer faithfulness.
  3. Recall@10 and p95 latency meet separately defined thresholds.
  4. Both code-number and conceptual test queries find correct passages.

Explanation

Correct Answer

A:

A labeled benchmark meets recall for both common and rare queries. This is the decisive observable evidence after implementing measure recall@k and nDCG by query type in addition to p95 latency. It tests the underlying requirement: Speed alone does not establish retrieval quality or fairness across intents.

Incorrect Answers

B:

A controlled evaluation shows acceptable citations and answer faithfulness. However, that result would not establish the required outcome: a labeled benchmark meets recall for both common and rare queries.

C:

Recall@10 and p95 latency meet separately defined thresholds. However, that result would not establish the required outcome: a labeled benchmark meets recall for both common and rare queries.

D:

Both code-number and conceptual test queries find correct passages. However, that result would not establish the required outcome: a labeled benchmark meets recall for both common and rare queries.

Question 866

An OLTP SQL deployment has sporadic CPU saturation and long query waits during a predictable business peak. Which technical property or constraint MOST directly matters here?

  1. Uncontrolled parallelism can increase coordination overhead for short queries.
  2. Resource limits can create bottlenecks independent of query syntax.
  3. Lock waits are not resolved merely by allocating faster compute.
  4. Instance metrics alone do not identify which cached statements consume resources.

Explanation

Correct Answer

B:

Resource limits can create bottlenecks independent of query syntax. This explains why the corrective action is to measure workload resource patterns and choose an appropriate compute/service tier or scaling policy. Confirm the diagnosis when a peak replay meets throughput and latency targets within budget.

Incorrect Answers

A:

Uncontrolled parallelism can increase coordination overhead for short queries. The actual technical constraint is that resource limits can create bottlenecks independent of query syntax.

C:

Lock waits are not resolved merely by allocating faster compute. The actual technical constraint is that resource limits can create bottlenecks independent of query syntax.

D:

Instance metrics alone do not identify which cached statements consume resources. The actual technical constraint is that resource limits can create bottlenecks independent of query syntax.

Question 867

A query sends whole SELECT * rows including secret customer notes to an LLM for one sales metric. Which preventive practice BEST addresses the underlying risk over time?

  1. Compare model output to authoritative SQL totals.
  2. Keep business arithmetic outside uncontrolled model generation.
  3. Enforce outbound allowlists and unit tests for fields.
  4. Audit access metadata and citation validity.

Explanation

Correct Answer

C:

Enforce outbound allowlists and unit tests for fields. This guards against recurrence because data minimization reduces prompt exposure and cost without losing relevant context. The direct remediation is: Project only required columns into a controlled JSON payload.

Incorrect Answers

A:

Compare model output to authoritative SQL totals. The current task instead requires this action: enforce outbound allowlists and unit tests for fields.

B:

Keep business arithmetic outside uncontrolled model generation. The current task instead requires this action: enforce outbound allowlists and unit tests for fields.

D:

Audit access metadata and citation validity. The current task instead requires this action: enforce outbound allowlists and unit tests for fields.

Question 868

A local SQL developer needs to use MCP tools for metadata exploration on a SQL Server database. Which technical action BEST resolves the primary problem?

  1. Reject the endpoint until source, TLS identity and tool effects are reviewed.
  2. Confirm approved GitHub Copilot seat, editor extension and organization policy.
  3. Keep Copilot as an authoring assistant; execute changes through reviewed SQL project deployment.
  4. Connect the approved SQL MCP endpoint using supported secure transport and scoped credentials.

Explanation

Correct Answer

D:

Connect the approved SQL MCP endpoint using supported secure transport and scoped credentials. This targets the primary issue because an MCP client needs a discoverable trusted server and permissions to run tools. Verification: The client lists authorized metadata tools and returns expected schema names. Prevent recurrence: Prevent direct write access and verify server identity.

Incorrect Answers

A:

A malicious or compromised MCP server may exfiltrate data or supply unsafe tool behavior.

B:

Editor AI availability depends on licensing, identity and permitted configuration.

C:

Keeping Copilot as an authoring assistant; execute changes through reviewed SQL project deployment addresses a different database behavior; the relevant distinction is that connect the approved SQL MCP endpoint using supported secure transport and scoped credentials.

Question 869

An ANN index reduces latency but the RAG answer hallucination rate increases. Which test result BEST demonstrates that the intended solution is working?

  1. A controlled evaluation shows acceptable citations and answer faithfulness.
  2. A labeled benchmark meets recall for both common and rare queries.
  3. A controlled CONTAINS query succeeds after population completes.
  4. Both code-number and conceptual test queries find correct passages.

Explanation

Correct Answer

A:

A controlled evaluation shows acceptable citations and answer faithfulness. This is the decisive observable evidence after implementing compare retrieved evidence precision and grounded answer faithfulness against an exact baseline. It tests the underlying requirement: Approximate retrieval may omit key passages, degrading downstream grounding.

Incorrect Answers

B:

A labeled benchmark meets recall for both common and rare queries. However, that result would not establish the required outcome: a controlled evaluation shows acceptable citations and answer faithfulness.

C:

A controlled CONTAINS query succeeds after population completes. However, that result would not establish the required outcome: a controlled evaluation shows acceptable citations and answer faithfulness.

D:

Both code-number and conceptual test queries find correct passages. However, that result would not establish the required outcome: a controlled evaluation shows acceptable citations and answer faithfulness.

Question 870

A developer assumes a SQL firewall rule alone authenticates callers to Azure SQL. Which technical principle BEST explains the relevant design decision?

  1. Managed identities remove a static SQL password from the deployed application configuration.
  2. Network allowlisting does not establish user identity or object authorization.
  3. Read filtering alone does not necessarily stop unauthorized DML that changes row ownership.
  4. API generation does not automatically imply that exposed data is appropriately authorized.

Explanation

Correct Answer

B:

Network allowlisting does not establish user identity or object authorization. This explains why the corrective action is to require encrypted transport and a verified principal alongside network access restrictions. Confirm the diagnosis when an unapproved identity is denied even from an allowed network.

Incorrect Answers

A:

Managed identities remove a static SQL password from the deployed application configuration. The actual technical constraint is that network allowlisting does not establish user identity or object authorization.

C:

Read filtering alone does not necessarily stop unauthorized DML that changes row ownership. The actual technical constraint is that network allowlisting does not establish user identity or object authorization.

D:

API generation does not automatically imply that exposed data is appropriately authorized. The actual technical constraint is that network allowlisting does not establish user identity or object authorization.

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