Pass Microsoft DP-800 Exam in First Attempt Guaranteed!
Get 100% Latest Exam Questions, Accurate & Verified Answers!
30 Days Free Updates, Instant Download!
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.
Explanation
Correct Answers
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. Use supported edit-distance similarity functions to rank candidates and preserve a human confirmation step.
Incorrect Answers
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.
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.
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?
Explanation
Correct Answers
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. Separate migrations into a controlled deployment identity and grant the runtime only needed object operations.
Incorrect Answers
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.
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.
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?
Explanation
Correct Answer
Converting free-form values to rows requires explicit delimiter and validation semantics.
Incorrect Answers
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.
Correlated queries preserve per-row context when selecting related records. Converting free-form values to rows requires explicit delimiter and validation semantics.
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?
Explanation
Correct Answer
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
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.
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.
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?
Explanation
Correct Answer
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
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.
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.
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?
Explanation
Correct Answer
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
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.
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.
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?
Explanation
Correct Answer
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
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.
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.
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.
Explanation
Correct Answers
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.
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
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.
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.
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?
Explanation
Correct Answer
Encryption mode and query capabilities must be chosen together; not every plaintext operation remains available.
Incorrect Answers
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.
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.
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?
Explanation
Correct Answer
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
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.
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.
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?
Explanation
Correct Answer
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
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.
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.
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
- Microsoft DP-800 Practice Test 21 - 10 Questions (Last Reviewed 27-Oct-2026)
- Microsoft DP-800 Practice Test 22 - 10 Questions (Last Reviewed 26-Oct-2026)
- Microsoft DP-800 Practice Test 23 - 10 Questions (Last Reviewed 25-Oct-2026)
- Microsoft DP-800 Practice Test 24 - 10 Questions (Last Reviewed 24-Oct-2026)
- Microsoft DP-800 Practice Test 25 - 10 Questions (Last Reviewed 23-Oct-2026)