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 37

Question 360

A schema migration changes a base column used by multiple schema-bound dependencies. Which technical property or constraint MOST directly matters here?

  1. Aggregate views are not generally directly updatable like simple single-table projections.
  2. Per-row scalar function calls may create expensive repeated execution on some workloads.
  3. A scalar function produces one value for each call but may affect query optimization.
  4. SCHEMABINDING protects referenced definitions against incompatible schema changes.

Explanation

Correct Answer

D:

SCHEMABINDING protects referenced definitions against incompatible schema changes. This explains why the corrective action is to review dependency effects and change the schema-bound view deliberately before modifying underlying objects. Confirm the diagnosis when a migration test catches incompatible column modification before production.

Incorrect Answers

A:

Aggregate views are not generally directly updatable like simple single-table projections. The actual technical constraint is that SCHEMABINDING protects referenced definitions against incompatible schema changes.

B:

Per-row scalar function calls may create expensive repeated execution on some workloads. The actual technical constraint is that SCHEMABINDING protects referenced definitions against incompatible schema changes.

C:

A scalar function produces one value for each call but may affect query optimization. The actual technical constraint is that SCHEMABINDING protects referenced definitions against incompatible schema changes.

Question 361

A team stores edge relationships in comma-separated strings instead of graph edges. Which preventive practice BEST addresses the underlying risk over time?

  1. Enforce ownership and governance over graph writes.
  2. Guard against cyclic paths and unsupported graph features.
  3. Set sensible MAXRECURSION and detect cycles.
  4. Implement graph integrity checks on writes.

Explanation

Correct Answer

A:

Enforce ownership and governance over graph writes. This guards against recurrence because the graph pattern engine expects node/edge structures, not arbitrary string lists. The direct remediation is: Normalize relationships into graph edge tables before using MATCH.

Incorrect Answers

B:

Guard against cyclic paths and unsupported graph features. The current task instead requires this action: enforce ownership and governance over graph writes.

C:

Set sensible MAXRECURSION and detect cycles. The current task instead requires this action: enforce ownership and governance over graph writes.

D:

Implement graph integrity checks on writes. The current task instead requires this action: enforce ownership and governance over graph writes.

Question 362

A DBA suspects one SQL statement drives most CPU usage during office hours. What should the SQL developer do FIRST to address the specific issue?

  1. Use Query Performance Insight and supported Azure/SQL monitoring evidence.
  2. Use relevant DMVs and Query Store runtime statistics to isolate resource-intensive statements.
  3. Use targeted measured configuration changes and a rollback plan rather than blindly enabling trace flags.
  4. Use appropriate locking or optimistic concurrency validation to make stock decrement atomic.

Explanation

Correct Answer

B:

Use relevant DMVs and Query Store runtime statistics to isolate resource-intensive statements. This targets the primary issue because instance metrics alone do not identify which cached statements consume resources. Verification: Top CPU queries correlate with observed workload and waits. Prevent recurrence: Use secure diagnostic access and preserve plan evidence.

Incorrect Answers

A:

Platform-native query insight tools expose historical workload statistics for managed instances.

C:

Database-level settings can affect many workloads and engine versions differently.

D:

Using appropriate locking or optimistic concurrency validation to make stock decrement atomic would not correct a DBA suspects one SQL statement drives most CPU usage during office hours. Use relevant DMVs and Query Store runtime statistics to isolate resource-intensive statements.

Question 363

A SQL developer wants editor suggestions inside a repository but has no enterprise Copilot entitlement. Which acceptance check is MOST directly related to this scenario?

  1. An approved SQL workspace exposes supported Copilot features for a licensed tester.
  2. An audit shows requests use the intended approved endpoint.
  3. A test completion appears under an authorized developer identity.
  4. Generated examples show placeholders and approved secret references.

Explanation

Correct Answer

C:

A test completion appears under an authorized developer identity. This is the decisive observable evidence after implementing confirm approved GitHub Copilot seat, editor extension and organization policy. It tests the underlying requirement: Editor AI availability depends on licensing, identity and permitted configuration.

Incorrect Answers

A:

An approved SQL workspace exposes supported Copilot features for a licensed tester. However, that result would not establish the required outcome: a test completion appears under an authorized developer identity.

B:

An audit shows requests use the intended approved endpoint. However, that result would not establish the required outcome: a test completion appears under an authorized developer identity.

D:

Generated examples show placeholders and approved secret references. However, that result would not establish the required outcome: a test completion appears under an authorized developer identity.

Question 364

A Fabric lakehouse MCP endpoint returns authorization failures for a service principal. Which technical principle BEST explains the relevant design decision?

  1. A malicious or compromised MCP server may exfiltrate data or supply unsafe tool behavior.
  2. AI suggestions are proposals, not change-control authorization.
  3. Guidance can be limited by file type or directory to avoid irrelevant instructions.
  4. MCP access to a lakehouse is constrained by Fabric and identity permissions.

Explanation

Correct Answer

D:

MCP access to a lakehouse is constrained by Fabric and identity permissions. This explains why the corrective action is to check the configured workspace identity, connector permissions and supported MCP authentication. Confirm the diagnosis when an approved read operation succeeds while a forbidden workspace remains denied.

Incorrect Answers

A:

A malicious or compromised MCP server may exfiltrate data or supply unsafe tool behavior. The actual technical constraint is that MCP access to a lakehouse is constrained by Fabric and identity permissions.

B:

AI suggestions are proposals, not change-control authorization. The actual technical constraint is that MCP access to a lakehouse is constrained by Fabric and identity permissions.

C:

Guidance can be limited by file type or directory to avoid irrelevant instructions. The actual technical constraint is that MCP access to a lakehouse is constrained by Fabric and identity permissions.

Question 365

A vector search system reports fast p50 latency but fails badly on rare terminology. Following remediation, what safeguard BEST prevents a repeat of this specific failure?

  1. Maintain per-segment regression sets.
  2. Use fallback exact retrieval for critical queries when warranted.
  3. Test RLS and filter boundaries on lexical and vector paths.
  4. Record contribution of each retrieval branch for diagnostics.

Explanation

Correct Answer

A:

Maintain per-segment regression sets. This guards against recurrence because speed alone does not establish retrieval quality or fairness across intents. The direct remediation is: Measure recall@k and nDCG by query type in addition to p95 latency.

Incorrect Answers

B:

Use fallback exact retrieval for critical queries when warranted. The current task instead requires this action: maintain per-segment regression sets.

C:

Test RLS and filter boundaries on lexical and vector paths.

D:

Record contribution of each retrieval branch for diagnostics. The current task instead requires this action: maintain per-segment regression sets.

Question 366

An OLTP SQL deployment has sporadic CPU saturation and long query waits during a predictable business peak. Which technical action BEST resolves the primary problem?

  1. Benchmark MAXDOP and cost threshold changes using actual plans and instance guidance.
  2. Measure workload resource patterns and choose an appropriate compute/service tier or scaling policy.
  3. Require an expected rowversion predicate and verify rows affected before confirming success.
  4. Process safe bounded batches or adjust indexes and isolation as measured.

Explanation

Correct Answer

B:

Measure workload resource patterns and choose an appropriate compute/service tier or scaling policy. This targets the primary issue because resource limits can create bottlenecks independent of query syntax. Verification: A peak replay meets throughput and latency targets within budget. Prevent recurrence: Monitor p95 waits and adjust scaling only from measured evidence.

Incorrect Answers

A:

Benchmark MAXDOP and cost threshold changes using actual plans and instance guidance. The relevant technical condition instead is that measure workload resource patterns and choose an appropriate compute/service tier or scaling policy.

C:

Optimistic concurrency only works if conflicts are detected, not silently overwritten.

D:

Large transactions increase lock duration, log pressure and potential escalation.

Question 367

A query sends whole SELECT * rows including secret customer notes to an LLM for one sales metric. Which test result BEST demonstrates that the intended solution is working?

  1. An API test reads amounts with correct decimal interpretation.
  2. New policy clauses appear in answer citations after refresh.
  3. Captured outbound JSON excludes restricted notes and includes needed metrics.
  4. The computed amount matches audited ledger SQL exactly.

Explanation

Correct Answer

C:

Captured outbound JSON excludes restricted notes and includes needed metrics. This is the decisive observable evidence after implementing project only required columns into a controlled JSON payload. It tests the underlying requirement: Data minimization reduces prompt exposure and cost without losing relevant context.

Incorrect Answers

A:

An API test reads amounts with correct decimal interpretation. However, that result would not establish the required outcome: captured outbound JSON excludes restricted notes and includes needed metrics.

B:

New policy clauses appear in answer citations after refresh. However, that result would not establish the required outcome: captured outbound JSON excludes restricted notes and includes needed metrics.

D:

The computed amount matches audited ledger SQL exactly. However, that result would not establish the required outcome: captured outbound JSON excludes restricted notes and includes needed metrics.

Question 368

A local SQL developer needs to use MCP tools for metadata exploration on a SQL Server database. Which technical principle BEST explains the relevant design decision?

  1. A malicious or compromised MCP server may exfiltrate data or supply unsafe tool behavior.
  2. Tool discovery and endpoint configuration determine accessible operations.
  3. Broad MCP tool capability expands the agent's potential effect on the database.
  4. An MCP client needs a discoverable trusted server and permissions to run tools.

Explanation

Correct Answer

D:

An MCP client needs a discoverable trusted server and permissions to run tools. This explains why the corrective action is to connect the approved SQL MCP endpoint using supported secure transport and scoped credentials. Confirm the diagnosis when the client lists authorized metadata tools and returns expected schema names.

Incorrect Answers

A:

A malicious or compromised MCP server may exfiltrate data or supply unsafe tool behavior. The actual technical constraint is that an MCP client needs a discoverable trusted server and permissions to run tools.

B:

Tool discovery and endpoint configuration determine accessible operations. The actual technical constraint is that an MCP client needs a discoverable trusted server and permissions to run tools.

C:

Broad MCP tool capability expands the agent's potential effect on the database. The actual technical constraint is that an MCP client needs a discoverable trusted server and permissions to run tools.

Question 369

An ANN index reduces latency but the RAG answer hallucination rate increases. Following remediation, what safeguard BEST prevents a repeat of this specific failure?

  1. Use fallback exact retrieval for critical queries when warranted.
  2. Maintain per-segment regression sets.
  3. Benchmark quality loss and index size before reducing precision.
  4. Do not assume normalization is right for every model/metric.

Explanation

Correct Answer

A:

Use fallback exact retrieval for critical queries when warranted. This guards against recurrence because approximate retrieval may omit key passages, degrading downstream grounding. The direct remediation is: Compare retrieved evidence precision and grounded answer faithfulness against an exact baseline.

Incorrect Answers

B:

Maintaining per-segment regression sets would not correct following remediation, what safeguard BEST prevents a repeat of this specific failure. Use fallback exact retrieval for critical queries when warranted.

C:

Benchmark quality loss and index size before reducing precision. The current task instead requires this action: use fallback exact retrieval for critical queries when warranted.

D:

Do not assume normalization is right for every model/metric. The current task instead requires this action: use fallback exact retrieval for critical queries when warranted.

Question 370

A developer assumes a SQL firewall rule alone authenticates callers to Azure SQL. Which technical action BEST resolves the primary problem?

  1. Use Microsoft Entra-based managed identity authentication where supported.
  2. Require encrypted transport and a verified principal alongside network access restrictions.
  3. Configure distinct least-privilege grants on model and search resources.
  4. Evaluate SQL column-level encryption with explicit key and certificate controls.

Explanation

Correct Answer

B:

Require encrypted transport and a verified principal alongside network access restrictions. This targets the primary issue because network allowlisting does not establish user identity or object authorization. Verification: An unapproved identity is denied even from an allowed network. Prevent recurrence: Keep firewall, identity and database grants under independent review.

Incorrect Answers

A:

Managed identities remove a static SQL password from the deployed application configuration.

C:

Identity permission at one Azure service does not imply access to adjacent resources.

D:

Server-side encryption can decrypt inside SQL with authorized key access, unlike client-controlled Always Encrypted.

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