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 60
Question 590
A mobile application needs to learn which customer IDs changed since its last successful sync without storing complete before-and-after value history. Which observation is the strongest evidence for the reported problem?
Explanation
Correct Answer
The poller rereads the full customer table for every sync despite only a few changes. Change Tracking is suited to changed-row identification rather than full change payload history.
Incorrect Answers
The production service starts with a default configuration missing the intended entity permissions. Change Tracking is suited to changed-row identification rather than full change payload history. The poller rereads the full customer table for every sync despite only a few changes.
An unbounded request sends millions of records and overwhelms the service during peak use. Change Tracking is suited to changed-row identification rather than full change payload history. The poller rereads the full customer table for every sync despite only a few changes.
The generic endpoint accepts arbitrary SQL text from the client instead of a defined business operation. Change Tracking is suited to changed-row identification rather than full change payload history. The poller rereads the full customer table for every sync despite only a few changes.
Question 591
A document search system builds vectors from entire customer records including social identifiers and confidential notes, despite requiring only product descriptions. Which TWO options together specify a corrective step and a meaningful test?
Explanation
Correct Answers
Search uses the approved description text and protected identifiers do not appear in vector inputs. Embed only approved semantically relevant fields and retain a secure linkage to source permissions.
Embed only approved semantically relevant fields and retain a secure linkage to source permissions.
Incorrect Answers
Use an approved secure identity or secret-management mechanism supported by the SQL platform and model endpoint. Embed only approved semantically relevant fields and retain a secure linkage to source permissions. Search uses the approved description text and protected identifiers do not appear in vector inputs.
Design section-aware chunks with appropriate overlap and metadata, then measure answer evidence coverage. Embed only approved semantically relevant fields and retain a secure linkage to source permissions. Search uses the approved description text and protected identifiers do not appear in vector inputs.
The model returns schema-valid fields with acceptable extraction accuracy and appropriate human review. Embed only approved semantically relevant fields and retain a secure linkage to source permissions. Search uses the approved description text and protected identifiers do not appear in vector inputs.
Question 592
A product catalog stores an occasionally filtered JSON status and developers want a reliable indexed search across supported SQL versions. Choose TWO: one correct response and one verification of success.
Explanation
Correct Answers
Check native JSON indexing support or use a supported indexed computed-property strategy where appropriate.
A test query filters on the intended JSON property using the verified supported index design. Check native JSON indexing support or use a supported indexed computed-property strategy where appropriate.
Incorrect Answers
Evaluate normalized, JSON, or sparse-column designs against actual query needs and engine support. Check native JSON indexing support or use a supported indexed computed-property strategy where appropriate.
Design date-aligned partitions and a tested retention or sliding-window maintenance procedure. Check native JSON indexing support or use a supported indexed computed-property strategy where appropriate.
Each tenant has unique invoice codes while other tenants can reuse the same code safely. Check native JSON indexing support or use a supported indexed computed-property strategy where appropriate. A test query filters on the intended JSON property using the verified supported index design.
Question 593
An API accepts arbitrary malformed JSON in a text field and downstream reporting intermittently fails during JSON parsing. Which test result would demonstrate the fix worked?
Explanation
Correct Answer
Malformed inputs are rejected and valid representative payloads remain queryable. The supporting symptom is: Test inserts include invalid JSON syntax that is accepted without validation and later breaks consumers.
Incorrect Answers
A representative graph traversal returns validated connections at acceptable cost. The supporting symptom is: Test inserts include invalid JSON syntax that is accepted without validation and later breaks consumers. Malformed inputs are rejected and valid representative payloads remain queryable.
The revised schema supports required searches while reducing unnecessary storage and migration burden. The supporting symptom is: Test inserts include invalid JSON syntax that is accepted without validation and later breaks consumers. Malformed inputs are rejected and valid representative payloads remain queryable.
Concurrent test inserts receive distinct identifiers and the business accepts documented gaps. The supporting symptom is: Test inserts include invalid JSON syntax that is accepted without validation and later breaks consumers. Malformed inputs are rejected and valid representative payloads remain queryable.
Question 594
A support platform stores optional case attributes in a JSON column and filters on a frequent nested risk-level property at scale. What is the underlying reason for the corrective step?
Explanation
Correct Answer
Semi-structured JSON still needs deliberate schema validation and indexing for predictable filtering.
Incorrect Answers
Physical storage decisions should follow transaction shapes rather than blanket performance claims. Semi-structured JSON still needs deliberate schema validation and indexing for predictable filtering.
Columnstore storage can improve scan-heavy analytics but its operational tradeoffs must be tested. Semi-structured JSON still needs deliberate schema validation and indexing for predictable filtering.
Historical convenience does not bypass privacy and records lifecycle requirements. Semi-structured JSON still needs deliberate schema validation and indexing for predictable filtering.
Question 595
A CRM team compares names with common prefix and transcription variations and wants an explainable candidate ranking. Which observation is the strongest evidence for the reported problem?
Explanation
Correct Answer
The current scoring treats harmless name variations and unrelated records as equally likely duplicates. String similarity metrics have different sensitivities and must be matched to actual data.
Incorrect Answers
Two tied sellers swap order across executions despite identical source revenue. String similarity metrics have different sensitivities and must be matched to actual data. The current scoring treats harmless name variations and unrelated records as equally likely duplicates.
A GROUP BY query returns a latest timestamp but cannot reliably choose the associated payload when timestamps tie. String similarity metrics have different sensitivities and must be matched to actual data. The current scoring treats harmless name variations and unrelated records as equally likely duplicates.
The existing query performs repeated nested scans and does not order same-time events predictably. String similarity metrics have different sensitivities and must be matched to actual data. The current scoring treats harmless name variations and unrelated records as equally likely duplicates.
Question 596
Developers can push directly to the default branch and deploy payment-table changes without review or security testing. Select TWO: the best action and the outcome that confirms it worked.
Explanation
Correct Answers
A tested failing pull request is blocked and approved changes follow the defined merge path. Developers can push directly to the default branch and deploy payment-table changes without review or security testing. Enforce branch policies, required reviewers, and successful SQL project validation before merge.
Enforce branch policies, required reviewers, and successful SQL project validation before merge. Developers can push directly to the default branch and deploy payment-table changes without review or security testing.
Incorrect Answers
A dry run validates the intended server/database identity and production release targets only that environment. Developers can push directly to the default branch and deploy payment-table changes without review or security testing. A tested failing pull request is blocked and approved changes follow the defined merge path.
Version reference data in a reviewed idempotent deployment process with migration tests. Developers can push directly to the default branch and deploy payment-table changes without review or security testing. A tested failing pull request is blocked and approved changes follow the defined merge path.
Reject the broad grant and model only narrowly required role permissions in reviewed project files. Developers can push directly to the default branch and deploy payment-table changes without review or security testing. A tested failing pull request is blocked and approved changes follow the defined merge path.
Question 597
A developer asks a coding assistant to optimize a stored procedure and accepts generated SQL that removes a tenant filter to improve latency. Which next step most directly resolves this SQL solution issue?
Explanation
Correct Answer
Treat the suggestion as untrusted code and require code review, data access tests, and execution plan analysis. AI-assisted development does not remove developer responsibility for SQL authorization and correctness.
Incorrect Answers
Review each configured model's data processing, retention, region, and tenant policy before sending SQL schema or examples. AI-assisted development does not remove developer responsibility for SQL authorization and correctness. Treat the suggestion as untrusted code and require code review, data access tests, and execution plan analysis.
Add representative test data and assert the business outputs before accepting the generated change. AI-assisted development does not remove developer responsibility for SQL authorization and correctness. Treat the suggestion as untrusted code and require code review, data access tests, and execution plan analysis.
Separate assistant suggestions from approved, executed changes and verify actual database state through controlled deployment. AI-assisted development does not remove developer responsibility for SQL authorization and correctness. Treat the suggestion as untrusted code and require code review, data access tests, and execution plan analysis.
Question 598
A developer configures both test and production SQL MCP endpoints with nearly identical names in the same assistant session. What would be a valid post-database-change verification?
Explanation
Correct Answer
The assisted workflow operates against the expected test environment and refuses unapproved production operations.
Incorrect Answers
A reviewed migration is applied through the authorized pipeline and subsequent tests confirm the changed procedure. The assisted workflow operates against the expected test environment and refuses unapproved production operations.
A negative tenant-access test fails safely while approved queries retain correct row scope and performance. The assisted workflow operates against the expected test environment and refuses unapproved production operations.
The tool returns only approved lakehouse metadata and rejects unauthorized workspace access. The assisted workflow operates against the expected test environment and refuses unapproved production operations.
Question 599
A customer portal query became slow immediately after a SQL compatibility change and operators cannot reproduce the older fast plan from memory. Which next step most directly resolves this SQL solution issue?
Explanation
Correct Answer
Use Query Store to compare recorded plans and runtime metrics, then test an appropriate plan-correction strategy. Query Store provides historical query-plan evidence and supports evidence-based regression diagnosis.
Incorrect Answers
Use live DMVs, wait information, and deadlock evidence to distinguish blocking chains from actual cyclic deadlocks. Query Store provides historical query-plan evidence and supports evidence-based regression diagnosis. Use Query Store to compare recorded plans and runtime metrics, then test an appropriate plan-correction strategy.
Choose transactional locking or isolation that enforces the reservation invariant under concurrency. Query Store provides historical query-plan evidence and supports evidence-based regression diagnosis. Use Query Store to compare recorded plans and runtime metrics, then test an appropriate plan-correction strategy.
Evaluate parameter-sensitive plan features and validated mitigation for the engine version. Query Store provides historical query-plan evidence and supports evidence-based regression diagnosis. Use Query Store to compare recorded plans and runtime metrics, then test an appropriate plan-correction strategy.
Question 600
A finance platform wants SQL records from supplier invoices, but its chosen general chat model outputs inconsistent field names and free-form commentary. Which next step most directly resolves this SQL solution issue?
Explanation
Correct Answer
Benchmark a suitable supported model for structured output on representative invoices and enforce schema validation. Model choice should match structured output requirements rather than general language fluency alone.
Incorrect Answers
Design section-aware chunks with appropriate overlap and metadata, then measure answer evidence coverage. Model choice should match structured output requirements rather than general language fluency alone. Benchmark a suitable supported model for structured output on representative invoices and enforce schema validation.
Use Change Tracking or another supported change signal to queue reliable re-embedding of modified source records. Model choice should match structured output requirements rather than general language fluency alone. Benchmark a suitable supported model for structured output on representative invoices and enforce schema validation.
Evaluate multilingual embedding models against labeled cross-language retrieval tests and relevant privacy constraints. Model choice should match structured output requirements rather than general language fluency alone. Benchmark a suitable supported model for structured output on representative invoices and enforce schema validation.
Developing AI-Enabled Database Solutions (DP-800) Practice Tests
- Microsoft DP-800 Practice Test 58 - 10 Questions (Last Reviewed 16-Nov-2026)
- Microsoft DP-800 Practice Test 59 - 10 Questions (Last Reviewed 15-Nov-2026)
- Microsoft DP-800 Practice Test 60 - 10 Questions (Last Reviewed 14-Nov-2026)
- Microsoft DP-800 Practice Test 61 - 10 Questions (Last Reviewed 13-Nov-2026)
- Microsoft DP-800 Practice Test 62 - 10 Questions (Last Reviewed 12-Nov-2026)