Microsoft DP-800 Practice Test 23 - 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 23

Question 220

A deduplication service needs to propose likely duplicate customer names despite small spelling differences, but exact equality misses them. Choose TWO statements: a suitable intervention and evidence of its success.

  1. Repeated runs produce the expected ranking and tie handling for the same data.
  2. Use supported edit-distance similarity functions to rank candidates and preserve a human confirmation step.
  3. Reviewers see plausible ranked candidates without automatic merges of unrelated customers.
  4. Use ROW_NUMBER over a device partition with a deterministic timestamp and tie-breaking order.
  5. Evaluate REGEXP_REPLACE with a narrowly tested account-token pattern and independent sensitive-data detection.

Explanation

Correct Answers

B:

Use supported edit-distance similarity functions to rank candidates and preserve a human confirmation step.

C:

Reviewers see plausible ranked candidates without automatic merges of unrelated customers. Use supported edit-distance similarity functions to rank candidates and preserve a human confirmation step.

Incorrect Answers

A:

Repeated runs produce the expected ranking and tie handling for the same data. Use supported edit-distance similarity functions to rank candidates and preserve a human confirmation step. Reviewers see plausible ranked candidates without automatic merges of unrelated customers.

D:

Use ROW_NUMBER over a device partition with a deterministic timestamp and tie-breaking order. Use supported edit-distance similarity functions to rank candidates and preserve a human confirmation step.

E:

Evaluate REGEXP_REPLACE with a narrowly tested account-token pattern and independent sensitive-data detection. Use supported edit-distance similarity functions to rank candidates and preserve a human confirmation step.

Question 221

A web application database login has db_owner privileges solely because its installation script creates a few tables during deployment. Which TWO options together specify a corrective step and a meaningful test?

  1. Authorized payroll clients read correct values while database operators cannot recover plaintext by ordinary SELECT.
  2. Separate migrations into a controlled deployment identity and grant the runtime only needed object operations.
  3. The web application runs normal queries while an attempted schema modification is denied.
  4. Plan coordinated key rotation and recovery testing before replacing or retiring key material.
  5. Remove unnecessary unmask privileges and combine masking with real access restrictions.

Explanation

Correct Answers

B:

Separate migrations into a controlled deployment identity and grant the runtime only needed object operations.

C:

The web application runs normal queries while an attempted schema modification is denied. Separate migrations into a controlled deployment identity and grant the runtime only needed object operations.

Incorrect Answers

A:

Authorized payroll clients read correct values while database operators cannot recover plaintext by ordinary SELECT. Separate migrations into a controlled deployment identity and grant the runtime only needed object operations. The web application runs normal queries while an attempted schema modification is denied.

D:

Plan coordinated key rotation and recovery testing before replacing or retiring key material. Separate migrations into a controlled deployment identity and grant the runtime only needed object operations.

E:

Remove unnecessary unmask privileges and combine masking with real access restrictions. Separate migrations into a controlled deployment identity and grant the runtime only needed object operations.

Question 222

A data migration receives a semi-structured comma-separated tag field where individual tags must be validated before loading. What distinction makes the recommended approach appropriate?

  1. Pattern specificity matters as much as the function chosen for regular-expression counts.
  2. Converting free-form values to rows requires explicit delimiter and validation semantics.
  3. Correlated queries preserve per-row context when selecting related records.
  4. Window offset functions simplify ordered comparisons but do not create missing time periods.

Explanation

Correct Answer

B:

Converting free-form values to rows requires explicit delimiter and validation semantics.

Incorrect Answers

A:

Pattern specificity matters as much as the function chosen for regular-expression counts. Converting free-form values to rows requires explicit delimiter and validation semantics.

C:

Correlated queries preserve per-row context when selecting related records. Converting free-form values to rows requires explicit delimiter and validation semantics.

D:

Window offset functions simplify ordered comparisons but do not create missing time periods. Converting free-form values to rows requires explicit delimiter and validation semantics.

Question 223

A product catalog updates embedding vectors but its approximate index remains stale and searches continue returning deleted descriptions. What should the database developer verify to confirm the suspected cause?

  1. Ranking differs significantly between offline validation and production despite identical inputs.
  2. The query output contains a citation to another tenant's chunk under certain prompts.
  3. The vector row has new text but nearest-neighbor results still surface an obsolete version.
  4. The rejected rows originate from a model that returns different coordinate lengths.

Explanation

Correct Answer

C:

The vector row has new text but nearest-neighbor results still surface an obsolete version. Search quality depends on keeping index state synchronized with current vector records.

Incorrect Answers

A:

Ranking differs significantly between offline validation and production despite identical inputs. Search quality depends on keeping index state synchronized with current vector records. The vector row has new text but nearest-neighbor results still surface an obsolete version.

B:

The query output contains a citation to another tenant's chunk under certain prompts. Search quality depends on keeping index state synchronized with current vector records. The vector row has new text but nearest-neighbor results still surface an obsolete version.

D:

The rejected rows originate from a model that returns different coordinate lengths. Search quality depends on keeping index state synchronized with current vector records. The vector row has new text but nearest-neighbor results still surface an obsolete version.

Question 224

Two concurrent booking transactions check an available seat count then both reserve the final seat because the availability predicate is not protected. How should the SQL engineering team confirm the issue is truly resolved?

  1. The validated remedy shortens lock waits and separate deadlock monitoring remains stable.
  2. Under concurrent replay at most one valid reservation commits and a clear retry result reaches the other caller.
  3. The chosen change lowers total reads without an unacceptable index maintenance penalty.
  4. The analysis identifies specific statements and a tested change reduces peak resource use.

Explanation

Correct Answer

B:

Under concurrent replay at most one valid reservation commits and a clear retry result reaches the other caller. The intended intervention is: Choose transactional locking or isolation that enforces the reservation invariant under concurrency.

Incorrect Answers

A:

The validated remedy shortens lock waits and separate deadlock monitoring remains stable. The intended intervention is: Choose transactional locking or isolation that enforces the reservation invariant under concurrency. Under concurrent replay at most one valid reservation commits and a clear retry result reaches the other caller.

C:

The chosen change lowers total reads without an unacceptable index maintenance penalty. The intended intervention is: Choose transactional locking or isolation that enforces the reservation invariant under concurrency. Under concurrent replay at most one valid reservation commits and a clear retry result reaches the other caller.

D:

The analysis identifies specific statements and a tested change reduces peak resource use. The intended intervention is: Choose transactional locking or isolation that enforces the reservation invariant under concurrency. Under concurrent replay at most one valid reservation commits and a clear retry result reaches the other caller.

Question 225

A legal research system chooses approximate nearest-neighbor search for speed but a small high-stakes sample requires exhaustive top-k accuracy. What should the database developer do FIRST within approved procedures?

  1. Compare ANN and exact-nearest-neighbor methods using agreed recall and latency thresholds.
  2. Apply product availability and eligibility rules before or during semantic ranking and verify result scope.
  3. Use supported VECTOR_DISTANCE with a compatible metric and deterministic ranking checks.
  4. Review supported filter placement and retrieve enough authorized candidates before ranking as appropriate.

Explanation

Correct Answer

A:

Compare ANN and exact-nearest-neighbor methods using agreed recall and latency thresholds. Approximate search gains speed by accepting possible recall loss relative to exact search.

Incorrect Answers

B:

Apply product availability and eligibility rules before or during semantic ranking and verify result scope. Approximate search gains speed by accepting possible recall loss relative to exact search. Compare ANN and exact-nearest-neighbor methods using agreed recall and latency thresholds.

C:

Use supported VECTOR_DISTANCE with a compatible metric and deterministic ranking checks. Approximate search gains speed by accepting possible recall loss relative to exact search. Compare ANN and exact-nearest-neighbor methods using agreed recall and latency thresholds.

D:

Review supported filter placement and retrieve enough authorized candidates before ranking as appropriate. Approximate search gains speed by accepting possible recall loss relative to exact search. Compare ANN and exact-nearest-neighbor methods using agreed recall and latency thresholds.

Question 226

A checkout workflow inserts an order and several details through separate client requests, leaving partial orders when one call fails. What is the MOST appropriate initial remediation?

  1. Design a parameterized inline table-valued function with a verified query plan and security boundary.
  2. Use a stored procedure with an explicit transaction, input validation, and appropriate error handling.
  3. Investigate parameter-sensitive plans and choose an engine-supported mitigation after measuring both workloads.
  4. Evaluate a narrowly scoped INSTEAD OF trigger or redesign the data-access contract with full transactional tests.

Explanation

Correct Answer

B:

Use a stored procedure with an explicit transaction, input validation, and appropriate error handling. A stored procedure can enforce a coherent transaction boundary for related database changes.

Incorrect Answers

A:

Design a parameterized inline table-valued function with a verified query plan and security boundary. A stored procedure can enforce a coherent transaction boundary for related database changes. Use a stored procedure with an explicit transaction, input validation, and appropriate error handling.

C:

Investigate parameter-sensitive plans and choose an engine-supported mitigation after measuring both workloads. A stored procedure can enforce a coherent transaction boundary for related database changes. Use a stored procedure with an explicit transaction, input validation, and appropriate error handling.

D:

Evaluate a narrowly scoped INSTEAD OF trigger or redesign the data-access contract with full transactional tests. A stored procedure can enforce a coherent transaction boundary for related database changes. Use a stored procedure with an explicit transaction, input validation, and appropriate error handling.

Question 227

Two inventory workers read the same quantity, compute a decrement, and then overwrite each other's result without conflict detection. Choose TWO: one correct response and one verification of success.

  1. Concurrent fulfillment produces consistent stock and conflicting updates are retried or rejected.
  2. Language-sliced tests retrieve authorized relevant records with accepted coverage.
  3. Use an atomic update or optimistic concurrency check to prevent lost updates.
  4. Use Query Store to compare recorded plans and runtime metrics, then test an appropriate plan-correction strategy.
  5. Analyze the deadlock graph and standardize access order or shorten transactions based on evidence.

Explanation

Correct Answers

A:

Concurrent fulfillment produces consistent stock and conflicting updates are retried or rejected. This gives the verification result for the issue: Two inventory workers read the same quantity, compute a decrement, and then overwrite each other's result without conflict detection.

C:

Use an atomic update or optimistic concurrency check to prevent lost updates. This gives the verification result for the issue: Two inventory workers read the same quantity, compute a decrement, and then overwrite each other's result without conflict detection.

Incorrect Answers

B:

Language-sliced tests retrieve authorized relevant records with accepted coverage. This gives the verification result for the issue: Two inventory workers read the same quantity, compute a decrement, and then overwrite each other's result without conflict detection. Concurrent fulfillment produces consistent stock and conflicting updates are retried or rejected.

D:

Use Query Store to compare recorded plans and runtime metrics, then test an appropriate plan-correction strategy. This gives the verification result for the issue: Two inventory workers read the same quantity, compute a decrement, and then overwrite each other's result without conflict detection. Use an atomic update or optimistic concurrency check to prevent lost updates.

E:

Analyze the deadlock graph and standardize access order or shorten transactions based on evidence. This gives the verification result for the issue: Two inventory workers read the same quantity, compute a decrement, and then overwrite each other's result without conflict detection. Concurrent fulfillment produces consistent stock and conflicting updates are retried or rejected.

Question 228

A customer database encrypts every attribute and then expects ordinary range searches across an encrypted salary column without design changes. What distinction makes the recommended approach appropriate?

  1. Background integrations require narrowly scoped identities just as interactive users do.
  2. Security auditing requires deliberate event selection, integrity, and lifecycle management.
  3. Data masking is a presentation-level control and inference exposure needs separate review.
  4. Encryption mode and query capabilities must be chosen together; not every plaintext operation remains available.

Explanation

Correct Answer

D:

Encryption mode and query capabilities must be chosen together; not every plaintext operation remains available.

Incorrect Answers

A:

Background integrations require narrowly scoped identities just as interactive users do. Encryption mode and query capabilities must be chosen together; not every plaintext operation remains available.

B:

Security auditing requires deliberate event selection, integrity, and lifecycle management. Encryption mode and query capabilities must be chosen together; not every plaintext operation remains available.

C:

Data masking is a presentation-level control and inference exposure needs separate review. Encryption mode and query capabilities must be chosen together; not every plaintext operation remains available.

Question 229

An AI coding assistant proposes rewriting a billing query, but the team has no regression fixture for null taxes and partial refunds. Which next step most directly resolves this SQL solution issue?

  1. Replace live values with safe synthetic examples and enforce repository secret and privacy scanning.
  2. Treat retrieved schema documentation as untrusted task data and block unauthorized tool calls.
  3. Create reviewed repository instruction files that specify migration, test, and secure coding conventions without embedding secrets.
  4. Add representative test data and assert the business outputs before accepting the generated change.

Explanation

Correct Answer

D:

Add representative test data and assert the business outputs before accepting the generated change. Correctness regression testing is essential when AI assistance alters set and join semantics.

Incorrect Answers

A:

Replace live values with safe synthetic examples and enforce repository secret and privacy scanning. Correctness regression testing is essential when AI assistance alters set and join semantics. Add representative test data and assert the business outputs before accepting the generated change.

B:

Treat retrieved schema documentation as untrusted task data and block unauthorized tool calls. Correctness regression testing is essential when AI assistance alters set and join semantics. Add representative test data and assert the business outputs before accepting the generated change.

C:

Create reviewed repository instruction files that specify migration, test, and secure coding conventions without embedding secrets. Correctness regression testing is essential when AI assistance alters set and join semantics. Add representative test data and assert the business outputs before accepting the generated change.

Question 230

A customer analytics query calls an expensive scalar UDF for every row and slows dramatically during monthly aggregation. Which corrective action best fits the observed symptoms?

  1. Assess supported scalar UDF inlining or rewrite the computation into a set-based expression.
  2. Use a stored procedure with an explicit transaction, input validation, and appropriate error handling.
  3. Review trigger nesting, rowset handling, and the necessity of the write-back operation.
  4. Evaluate a narrowly scoped INSTEAD OF trigger or redesign the data-access contract with full transactional tests.

Explanation

Correct Answer

A:

Assess supported scalar UDF inlining or rewrite the computation into a set-based expression. Set-based SQL processing can avoid per-row procedural overhead when the function is compatible.

Incorrect Answers

B:

Use a stored procedure with an explicit transaction, input validation, and appropriate error handling. Set-based SQL processing can avoid per-row procedural overhead when the function is compatible. Assess supported scalar UDF inlining or rewrite the computation into a set-based expression.

C:

Review trigger nesting, rowset handling, and the necessity of the write-back operation. Set-based SQL processing can avoid per-row procedural overhead when the function is compatible. Assess supported scalar UDF inlining or rewrite the computation into a set-based expression.

D:

Evaluate a narrowly scoped INSTEAD OF trigger or redesign the data-access contract with full transactional tests. Set-based SQL processing can avoid per-row procedural overhead when the function is compatible. Assess supported scalar UDF inlining or rewrite the computation into a set-based expression.

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