Microsoft DP-800 Practice Test 21 - Prepaway
Practice Exams:

Pass Microsoft DP-800 Exam in First Attempt Guaranteed!

Get 100% Latest Exam Questions, Accurate & Verified Answers!

30 Days Free Updates, Instant Download!

Verified By Experts
Premium File
$69.99 $76.99

DP-800 Premium ETE File


  • Premium File 101 Questions & Answers. Last Update: Nov 06, 2026
Whats Included:
  • Latest Questions
  • 100% Accurate Answers
  • Fast Exam Updates

Microsoft DP-800 Practice Test 21

Question 200

An AI coding assistant proposes rewriting a billing query, but the team has no regression fixture for null taxes and partial refunds. Which observation is the strongest evidence for the reported problem?

  1. Authorized staff cannot access the expected assistant despite seeing it in a marketing demonstration.
  2. The query explanation shows proposed changes but the database still contains the original stored procedure.
  3. A proposed query runs faster in a developer test but returns records belonging to other tenants.
  4. The faster version silently drops refunds because a new INNER JOIN filters unmatched rows.

Explanation

Correct Answer

D:

The faster version silently drops refunds because a new INNER JOIN filters unmatched rows. Correctness regression testing is essential when AI assistance alters set and join semantics.

Incorrect Answers

A:

Authorized staff cannot access the expected assistant despite seeing it in a marketing demonstration. Correctness regression testing is essential when AI assistance alters set and join semantics. The faster version silently drops refunds because a new INNER JOIN filters unmatched rows.

B:

The query explanation shows proposed changes but the database still contains the original stored procedure. Correctness regression testing is essential when AI assistance alters set and join semantics. The faster version silently drops refunds because a new INNER JOIN filters unmatched rows.

C:

A proposed query runs faster in a developer test but returns records belonging to other tenants. Correctness regression testing is essential when AI assistance alters set and join semantics. The faster version silently drops refunds because a new INNER JOIN filters unmatched rows.

Question 201

A T-SQL workflow builds a prompt for an external language model but includes every row and confidential identifier regardless of question scope. Which next step most directly resolves this SQL solution issue?

  1. Use sp_invoke_external_rest_endpoint only with an approved network and identity configuration and a minimal validated prompt payload.
  2. Record authorized prompt/source version metadata, model identity, and approval outcome with appropriate privacy retention.
  3. Treat retrieved content as untrusted evidence and never grant it authority to execute SQL actions.
  4. Convert the approved structured rows to valid JSON with supported SQL JSON construction functions.

Explanation

Correct Answer

A:

Use sp_invoke_external_rest_endpoint only with an approved network and identity configuration and a minimal validated prompt payload. External REST calls from SQL must minimize disclosed data and enforce endpoint security.

Incorrect Answers

B:

Record authorized prompt/source version metadata, model identity, and approval outcome with appropriate privacy retention. External REST calls from SQL must minimize disclosed data and enforce endpoint security. Use sp_invoke_external_rest_endpoint only with an approved network and identity configuration and a minimal validated prompt payload.

C:

Treat retrieved content as untrusted evidence and never grant it authority to execute SQL actions. External REST calls from SQL must minimize disclosed data and enforce endpoint security. Use sp_invoke_external_rest_endpoint only with an approved network and identity configuration and a minimal validated prompt payload.

D:

Convert the approved structured rows to valid JSON with supported SQL JSON construction functions. External REST calls from SQL must minimize disclosed data and enforce endpoint security. Use sp_invoke_external_rest_endpoint only with an approved network and identity configuration and a minimal validated prompt payload.

Question 202

A SQL project tracks application tables but lookup status codes are manually edited in production, causing different values across environments. Which test result would demonstrate the fix worked?

  1. A tested failing pull request is blocked and approved changes follow the defined merge path.
  2. Deployment preserves required values or uses a documented approved transformation without silent truncation.
  3. A clean rebuild and incremental deployment produce identical authorized lookup mappings.
  4. A dry run validates the intended server/database identity and production release targets only that environment.

Explanation

Correct Answer

C:

A clean rebuild and incremental deployment produce identical authorized lookup mappings.

Incorrect Answers

A:

A tested failing pull request is blocked and approved changes follow the defined merge path. A clean rebuild and incremental deployment produce identical authorized lookup mappings.

B:

Deployment preserves required values or uses a documented approved transformation without silent truncation. A clean rebuild and incremental deployment produce identical authorized lookup mappings.

D:

A dry run validates the intended server/database identity and production release targets only that environment. A clean rebuild and incremental deployment produce identical authorized lookup mappings.

Question 203

A SQL-centered maintenance application stores images and text descriptions of equipment failures and the team attempts to embed images with a text-only pipeline. Which concept should guide the database developer in this situation?

  1. Model modalities and preprocessing must match the stored evidence types.
  2. Model choice should match structured output requirements rather than general language fluency alone.
  3. Chunking should preserve semantically necessary context instead of merely maximizing ingestion speed.
  4. Synchronous external calls inside write transactions can couple availability to a remote inference service.

Explanation

Correct Answer

A:

Model modalities and preprocessing must match the stored evidence types.

Incorrect Answers

B:

Model choice should match structured output requirements rather than general language fluency alone. Model modalities and preprocessing must match the stored evidence types.

C:

Chunking should preserve semantically necessary context instead of merely maximizing ingestion speed. Model modalities and preprocessing must match the stored evidence types.

D:

Synchronous external calls inside write transactions can couple availability to a remote inference service. Model modalities and preprocessing must match the stored evidence types.

Question 204

An inventory update and fulfillment job update the same tables in opposite orders and periodic SQL deadlock victims trigger retries. Which test result would demonstrate the fix worked?

  1. The validated remedy shortens lock waits and separate deadlock monitoring remains stable.
  2. The new configuration reduces read blocking while reports avoid uncommitted data and temp/version costs are monitored.
  3. The chosen change lowers total reads without an unacceptable index maintenance penalty.
  4. Repeated parallel tests no longer reproduce the deadlock and functional outcomes remain correct.

Explanation

Correct Answer

D:

Repeated parallel tests no longer reproduce the deadlock and functional outcomes remain correct.

Incorrect Answers

A:

The validated remedy shortens lock waits and separate deadlock monitoring remains stable. Repeated parallel tests no longer reproduce the deadlock and functional outcomes remain correct.

B:

The new configuration reduces read blocking while reports avoid uncommitted data and temp/version costs are monitored. Repeated parallel tests no longer reproduce the deadlock and functional outcomes remain correct.

C:

The chosen change lowers total reads without an unacceptable index maintenance penalty. Repeated parallel tests no longer reproduce the deadlock and functional outcomes remain correct.

Question 205

A billing service reports connection timeouts and the team labels every wait a deadlock without inspecting lock ownership. What technical finding would substantiate this root cause?

  1. The plan includes hundreds of thousands of lookups for columns absent from the nonclustered index.
  2. A blocked request waits behind a long-running transaction but no deadlock victim is recorded.
  3. The captured plan was compiled with a tiny tenant ID and scans badly when reused for a huge tenant.
  4. Query Store shows the same query hash shifted to a more expensive plan after deployment.

Explanation

Correct Answer

B:

A blocked request waits behind a long-running transaction but no deadlock victim is recorded. Blocking is waiting for locks; a deadlock involves a cycle that SQL Server must resolve.

Incorrect Answers

A:

The plan includes hundreds of thousands of lookups for columns absent from the nonclustered index. Blocking is waiting for locks; a deadlock involves a cycle that SQL Server must resolve. A blocked request waits behind a long-running transaction but no deadlock victim is recorded.

C:

The captured plan was compiled with a tiny tenant ID and scans badly when reused for a huge tenant. Blocking is waiting for locks; a deadlock involves a cycle that SQL Server must resolve. A blocked request waits behind a long-running transaction but no deadlock victim is recorded.

D:

Query Store shows the same query hash shifted to a more expensive plan after deployment. Blocking is waiting for locks; a deadlock involves a cycle that SQL Server must resolve. A blocked request waits behind a long-running transaction but no deadlock victim is recorded.

Question 206

A team switches between hosted models in a coding assistant and assumes all model endpoints have identical data handling terms. What would be a valid post-database-change verification?

  1. New suggestions follow the documented conventions and still pass independent pull-request review.
  2. A selected index improves target queries without breaching transactional and storage budgets.
  3. Eligible users can perform an approved task and excluded users cannot access unsupported capabilities.
  4. Approved sessions use an allowed endpoint and unapproved configurations are blocked or corrected.

Explanation

Correct Answer

D:

Approved sessions use an allowed endpoint and unapproved configurations are blocked or corrected.

Incorrect Answers

A:

New suggestions follow the documented conventions and still pass independent pull-request review. Approved sessions use an allowed endpoint and unapproved configurations are blocked or corrected.

B:

A selected index improves target queries without breaching transactional and storage budgets. Approved sessions use an allowed endpoint and unapproved configurations are blocked or corrected.

C:

Eligible users can perform an approved task and excluded users cannot access unsupported capabilities. Approved sessions use an allowed endpoint and unapproved configurations are blocked or corrected.

Question 207

A procedure filters customers by region, usually returns ten rows but occasionally one region contains half the table; a cached plan performs poorly for the outlier. Which outcome shows the requirement is met without introducing a new risk?

  1. A cross-tenant negative test returns no forbidden records while authorized calls still work.
  2. A controlled update follows the intended mapping without corrupting the related tables.
  3. Representative small and large parameter tests both meet latency with acceptable compilation cost.
  4. The service can query approved totals and receives an authorization error for direct sensitive table reads.

Explanation

Correct Answer

C:

Representative small and large parameter tests both meet latency with acceptable compilation cost.

Incorrect Answers

A:

A cross-tenant negative test returns no forbidden records while authorized calls still work. Representative small and large parameter tests both meet latency with acceptable compilation cost.

B:

A controlled update follows the intended mapping without corrupting the related tables. Representative small and large parameter tests both meet latency with acceptable compilation cost.

D:

The service can query approved totals and receives an authorization error for direct sensitive table reads. Representative small and large parameter tests both meet latency with acceptable compilation cost.

Question 208

A procedure posts an invoice and then calls a failing validation routine; the customer balance remains changed because the error is swallowed. What is the MOST appropriate initial remediation?

  1. Extract the required JSON property and convert it to an appropriate numeric type with invalid-data handling.
  2. Evaluate JSON_CONTAINS or another supported JSON-aware predicate for the target engine and index design.
  3. Use OPENJSON with an explicit schema to expand validated line items into relational rows.
  4. Implement TRY CATCH with transaction state handling, rollback, and error propagation appropriate to the caller.

Explanation

Correct Answer

D:

Implement TRY CATCH with transaction state handling, rollback, and error propagation appropriate to the caller. T-SQL error handling must preserve transaction atomicity rather than merely log exceptions.

Incorrect Answers

A:

Extract the required JSON property and convert it to an appropriate numeric type with invalid-data handling. T-SQL error handling must preserve transaction atomicity rather than merely log exceptions. Implement TRY CATCH with transaction state handling, rollback, and error propagation appropriate to the caller.

B:

Evaluate JSON_CONTAINS or another supported JSON-aware predicate for the target engine and index design. T-SQL error handling must preserve transaction atomicity rather than merely log exceptions. Implement TRY CATCH with transaction state handling, rollback, and error propagation appropriate to the caller.

C:

Use OPENJSON with an explicit schema to expand validated line items into relational rows. T-SQL error handling must preserve transaction atomicity rather than merely log exceptions. Implement TRY CATCH with transaction state handling, rollback, and error propagation appropriate to the caller.

Question 209

A SQL service calls an external model and assumes its output is always a plain text answer, but the service contract requires structured fields and safe errors. How should the SQL engineering team confirm the issue is truly resolved?

  1. The workflow meets token and latency budgets while citing the correct current clauses.
  2. Valid responses populate the correct schema while failures are logged and retried safely.
  3. The model summarizes the comment without executing any unauthorized database change.
  4. The request sends only approved fields and the model receives sufficient task context.

Explanation

Correct Answer

B:

Valid responses populate the correct schema while failures are logged and retried safely.

Incorrect Answers

A:

The workflow meets token and latency budgets while citing the correct current clauses. Valid responses populate the correct schema while failures are logged and retried safely.

C:

The model summarizes the comment without executing any unauthorized database change. Valid responses populate the correct schema while failures are logged and retried safely.

D:

The request sends only approved fields and the model receives sufficient task context. Valid responses populate the correct schema while failures are logged and retried safely.

Question 210

Readers wait behind frequent updates in an order system and staff propose dirty reads as a quick fix for business dashboards. Which outcome shows the requirement is met without introducing a new risk?

  1. The analysis identifies specific statements and a tested change reduces peak resource use.
  2. The validated remedy shortens lock waits and separate deadlock monitoring remains stable.
  3. Under concurrent replay at most one valid reservation commits and a clear retry result reaches the other caller.
  4. The new configuration reduces read blocking while reports avoid uncommitted data and temp/version costs are monitored.

Explanation

Correct Answer

D:

The new configuration reduces read blocking while reports avoid uncommitted data and temp/version costs are monitored. The operating rule is: Versioned reads can improve concurrency without exposing dirty values when correctly configured.

Incorrect Answers

A:

The analysis identifies specific statements and a tested change reduces peak resource use. The operating rule is: Versioned reads can improve concurrency without exposing dirty values when correctly configured. The new configuration reduces read blocking while reports avoid uncommitted data and temp/version costs are monitored.

B:

The validated remedy shortens lock waits and separate deadlock monitoring remains stable. The operating rule is: Versioned reads can improve concurrency without exposing dirty values when correctly configured. The new configuration reduces read blocking while reports avoid uncommitted data and temp/version costs are monitored.

C:

Under concurrent replay at most one valid reservation commits and a clear retry result reaches the other caller. The operating rule is: Versioned reads can improve concurrency without exposing dirty values when correctly configured. The new configuration reduces read blocking while reports avoid uncommitted data and temp/version costs are monitored.

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