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

  1. The production service starts with a default configuration missing the intended entity permissions.
  2. An unbounded request sends millions of records and overwhelms the service during peak use.
  3. The generic endpoint accepts arbitrary SQL text from the client instead of a defined business operation.
  4. The poller rereads the full customer table for every sync despite only a few changes.

Explanation

Correct Answer

D:

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

A:

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.

B:

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.

C:

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?

  1. Use an approved secure identity or secret-management mechanism supported by the SQL platform and model endpoint.
  2. Search uses the approved description text and protected identifiers do not appear in vector inputs.
  3. Design section-aware chunks with appropriate overlap and metadata, then measure answer evidence coverage.
  4. The model returns schema-valid fields with acceptable extraction accuracy and appropriate human review.
  5. Embed only approved semantically relevant fields and retain a secure linkage to source permissions.

Explanation

Correct Answers

B:

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.

E:

Embed only approved semantically relevant fields and retain a secure linkage to source permissions.

Incorrect Answers

A:

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.

C:

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.

D:

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.

  1. Check native JSON indexing support or use a supported indexed computed-property strategy where appropriate.
  2. Evaluate normalized, JSON, or sparse-column designs against actual query needs and engine support.
  3. Design date-aligned partitions and a tested retention or sliding-window maintenance procedure.
  4. Each tenant has unique invoice codes while other tenants can reuse the same code safely.
  5. A test query filters on the intended JSON property using the verified supported index design.

Explanation

Correct Answers

A:

Check native JSON indexing support or use a supported indexed computed-property strategy where appropriate.

E:

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

B:

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.

C:

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.

D:

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?

  1. Malformed inputs are rejected and valid representative payloads remain queryable.
  2. A representative graph traversal returns validated connections at acceptable cost.
  3. The revised schema supports required searches while reducing unnecessary storage and migration burden.
  4. Concurrent test inserts receive distinct identifiers and the business accepts documented gaps.

Explanation

Correct Answer

A:

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

B:

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.

C:

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.

D:

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?

  1. Physical storage decisions should follow transaction shapes rather than blanket performance claims.
  2. Semi-structured JSON still needs deliberate schema validation and indexing for predictable filtering.
  3. Columnstore storage can improve scan-heavy analytics but its operational tradeoffs must be tested.
  4. Historical convenience does not bypass privacy and records lifecycle requirements.

Explanation

Correct Answer

B:

Semi-structured JSON still needs deliberate schema validation and indexing for predictable filtering.

Incorrect Answers

A:

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.

C:

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.

D:

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?

  1. Two tied sellers swap order across executions despite identical source revenue.
  2. The current scoring treats harmless name variations and unrelated records as equally likely duplicates.
  3. A GROUP BY query returns a latest timestamp but cannot reliably choose the associated payload when timestamps tie.
  4. The existing query performs repeated nested scans and does not order same-time events predictably.

Explanation

Correct Answer

B:

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

A:

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.

C:

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.

D:

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.

  1. A tested failing pull request is blocked and approved changes follow the defined merge path.
  2. A dry run validates the intended server/database identity and production release targets only that environment.
  3. Enforce branch policies, required reviewers, and successful SQL project validation before merge.
  4. Version reference data in a reviewed idempotent deployment process with migration tests.
  5. Reject the broad grant and model only narrowly required role permissions in reviewed project files.

Explanation

Correct Answers

A:

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.

C:

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

B:

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.

D:

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.

E:

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?

  1. Review each configured model's data processing, retention, region, and tenant policy before sending SQL schema or examples.
  2. Add representative test data and assert the business outputs before accepting the generated change.
  3. Separate assistant suggestions from approved, executed changes and verify actual database state through controlled deployment.
  4. Treat the suggestion as untrusted code and require code review, data access tests, and execution plan analysis.

Explanation

Correct Answer

D:

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

A:

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.

B:

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.

C:

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?

  1. A reviewed migration is applied through the authorized pipeline and subsequent tests confirm the changed procedure.
  2. A negative tenant-access test fails safely while approved queries retain correct row scope and performance.
  3. The tool returns only approved lakehouse metadata and rejects unauthorized workspace access.
  4. The assisted workflow operates against the expected test environment and refuses unapproved production operations.

Explanation

Correct Answer

D:

The assisted workflow operates against the expected test environment and refuses unapproved production operations.

Incorrect Answers

A:

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.

B:

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.

C:

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?

  1. Use live DMVs, wait information, and deadlock evidence to distinguish blocking chains from actual cyclic deadlocks.
  2. Choose transactional locking or isolation that enforces the reservation invariant under concurrency.
  3. Use Query Store to compare recorded plans and runtime metrics, then test an appropriate plan-correction strategy.
  4. Evaluate parameter-sensitive plan features and validated mitigation for the engine version.

Explanation

Correct Answer

C:

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

A:

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.

B:

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.

D:

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?

  1. Benchmark a suitable supported model for structured output on representative invoices and enforce schema validation.
  2. Design section-aware chunks with appropriate overlap and metadata, then measure answer evidence coverage.
  3. Use Change Tracking or another supported change signal to queue reliable re-embedding of modified source records.
  4. Evaluate multilingual embedding models against labeled cross-language retrieval tests and relevant privacy constraints.

Explanation

Correct Answer

A:

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

B:

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.

C:

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.

D:

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