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

Question 560

An inventory update and fulfillment job update the same tables in opposite orders and periodic SQL deadlock victims trigger retries. Which observation is the strongest evidence for the reported problem?

  1. A parallel test leaves inventory higher than the total number of fulfilled orders implies.
  2. The plan includes hundreds of thousands of lookups for columns absent from the nonclustered index.
  3. Resource charts show high CPU while the team has no ranked list of query costs.
  4. The graph identifies reversed lock acquisition order for the two transactions.

Explanation

Correct Answer

D:

The graph identifies reversed lock acquisition order for the two transactions. Consistent lock acquisition and bounded transactions can reduce application deadlocks.

Incorrect Answers

A:

A parallel test leaves inventory higher than the total number of fulfilled orders implies. Consistent lock acquisition and bounded transactions can reduce application deadlocks. The graph identifies reversed lock acquisition order for the two transactions.

B:

The plan includes hundreds of thousands of lookups for columns absent from the nonclustered index. Consistent lock acquisition and bounded transactions can reduce application deadlocks. The graph identifies reversed lock acquisition order for the two transactions.

C:

Resource charts show high CPU while the team has no ranked list of query costs. Consistent lock acquisition and bounded transactions can reduce application deadlocks. The graph identifies reversed lock acquisition order for the two transactions.

Question 561

A multi-customer vector search uses tenant filters only after retrieving global nearest neighbors, allowing protected chunks to influence responses. Which outcome shows the requirement is met without introducing a new risk?

  1. A representative query meets latency while returning acceptable nearest-neighbor quality.
  2. Negative cross-tenant searches reveal no unauthorized chunks or metadata.
  3. Language-sliced tests retrieve authorized relevant records with accepted coverage.
  4. A pre-insert check identifies incompatible vectors and routes them to repair before indexing.

Explanation

Correct Answer

B:

Negative cross-tenant searches reveal no unauthorized chunks or metadata. The operating rule is: Vector retrieval must not bypass the same row-level authorization as ordinary SQL queries.

Incorrect Answers

A:

A representative query meets latency while returning acceptable nearest-neighbor quality. The operating rule is: Vector retrieval must not bypass the same row-level authorization as ordinary SQL queries. Negative cross-tenant searches reveal no unauthorized chunks or metadata.

C:

Language-sliced tests retrieve authorized relevant records with accepted coverage. The operating rule is: Vector retrieval must not bypass the same row-level authorization as ordinary SQL queries. Negative cross-tenant searches reveal no unauthorized chunks or metadata.

D:

A pre-insert check identifies incompatible vectors and routes them to repair before indexing. The operating rule is: Vector retrieval must not bypass the same row-level authorization as ordinary SQL queries. Negative cross-tenant searches reveal no unauthorized chunks or metadata.

Question 562

A support role sees masked card numbers but can execute broad aggregate and comparison queries that might reveal protected details. Which corrective action best fits the observed symptoms?

  1. Bind the session context to trusted authenticated identity and prevent untrusted tenant switching.
  2. Use a suitable managed identity and Microsoft Entra authorization path supported by the SQL service.
  3. Plan coordinated key rotation and recovery testing before replacing or retiring key material.
  4. Constrain query permissions and review inference risks rather than treating masking as sufficient protection.

Explanation

Correct Answer

D:

Constrain query permissions and review inference risks rather than treating masking as sufficient protection. Data masking is a presentation-level control and inference exposure needs separate review.

Incorrect Answers

A:

Bind the session context to trusted authenticated identity and prevent untrusted tenant switching. Data masking is a presentation-level control and inference exposure needs separate review. Constrain query permissions and review inference risks rather than treating masking as sufficient protection.

B:

Use a suitable managed identity and Microsoft Entra authorization path supported by the SQL service. Data masking is a presentation-level control and inference exposure needs separate review. Constrain query permissions and review inference risks rather than treating masking as sufficient protection.

C:

Plan coordinated key rotation and recovery testing before replacing or retiring key material. Data masking is a presentation-level control and inference exposure needs separate review. Constrain query permissions and review inference risks rather than treating masking as sufficient protection.

Question 563

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. Select TWO: the best action and the outcome that confirms it worked.

  1. Create an appropriately permissioned view that projects only authorized aggregated fields.
  2. Keep granular permissions as the access barrier and implement carefully tested triggers only for appropriate data-change auditing.
  3. Representative small and large parameter tests both meet latency with acceptable compilation cost.
  4. Investigate parameter-sensitive plans and choose an engine-supported mitigation after measuring both workloads.
  5. The service can query approved totals and receives an authorization error for direct sensitive table reads.

Explanation

Correct Answers

C:

Representative small and large parameter tests both meet latency with acceptable compilation cost. Investigate parameter-sensitive plans and choose an engine-supported mitigation after measuring both workloads.

D:

Investigate parameter-sensitive plans and choose an engine-supported mitigation after measuring both workloads.

Incorrect Answers

A:

Create an appropriately permissioned view that projects only authorized aggregated fields. Investigate parameter-sensitive plans and choose an engine-supported mitigation after measuring both workloads.

B:

Keep granular permissions as the access barrier and implement carefully tested triggers only for appropriate data-change auditing. Investigate parameter-sensitive plans and choose an engine-supported mitigation after measuring both workloads. Representative small and large parameter tests both meet latency with acceptable compilation cost.

E:

The service can query approved totals and receives an authorization error for direct sensitive table reads. Investigate parameter-sensitive plans and choose an engine-supported mitigation after measuring both workloads. Representative small and large parameter tests both meet latency with acceptable compilation cost.

Question 564

A Data API builder endpoint accepts unvalidated client-side tenant parameters while backend queries use an all-tenant database identity. Select TWO: the best action and the outcome that confirms it worked.

  1. Apply DAB roles, entity permissions, and backend identity least privilege with negative tests.
  2. Configure protected audit export and retention consistent with organizational policy.
  3. Test audit events remain retrievable and immutable for the required retention period.
  4. Enforce authorized tenant scoping through backend policies and service identity rather than trust the caller's filter.
  5. Modified client filters cannot expand the account's authorized row scope.

Explanation

Correct Answers

D:

Enforce authorized tenant scoping through backend policies and service identity rather than trust the caller's filter.

E:

Modified client filters cannot expand the account's authorized row scope. Enforce authorized tenant scoping through backend policies and service identity rather than trust the caller's filter.

Incorrect Answers

A:

Apply DAB roles, entity permissions, and backend identity least privilege with negative tests. Enforce authorized tenant scoping through backend policies and service identity rather than trust the caller's filter.

B:

Configure protected audit export and retention consistent with organizational policy. Enforce authorized tenant scoping through backend policies and service identity rather than trust the caller's filter.

C:

Test audit events remain retrievable and immutable for the required retention period. Enforce authorized tenant scoping through backend policies and service identity rather than trust the caller's filter.

Question 565

A compliance analyst must count structured incident tags embedded in a text column, but searching a broad substring overcounts ordinary words. Choose TWO: one correct response and one verification of success.

  1. Use an appropriate window rank and secondary order according to the published tie rule.
  2. Implement TRY CATCH with transaction state handling, rollback, and error propagation appropriate to the caller.
  3. The extraction returns only identifiers meeting the agreed pattern on representative texts.
  4. Use an exact validated pattern and a supported REGEXP_COUNT function where available.
  5. Tag counts match a manually labeled sample and exclude incidental text.

Explanation

Correct Answers

D:

Use an exact validated pattern and a supported REGEXP_COUNT function where available. This gives the verification result for the issue: A compliance analyst must count structured incident tags embedded in a text column, but searching a broad substring overcounts ordinary words.

E:

Tag counts match a manually labeled sample and exclude incidental text. This gives the verification result for the issue: A compliance analyst must count structured incident tags embedded in a text column, but searching a broad substring overcounts ordinary words.

Incorrect Answers

A:

Use an appropriate window rank and secondary order according to the published tie rule. This gives the verification result for the issue: A compliance analyst must count structured incident tags embedded in a text column, but searching a broad substring overcounts ordinary words. Use an exact validated pattern and a supported REGEXP_COUNT function where available.

B:

Implement TRY CATCH with transaction state handling, rollback, and error propagation appropriate to the caller. This gives the verification result for the issue: A compliance analyst must count structured incident tags embedded in a text column, but searching a broad substring overcounts ordinary words. Use an exact validated pattern and a supported REGEXP_COUNT function where available.

C:

The extraction returns only identifiers meeting the agreed pattern on representative texts. This gives the verification result for the issue: A compliance analyst must count structured incident tags embedded in a text column, but searching a broad substring overcounts ordinary words. Tag counts match a manually labeled sample and exclude incidental text.

Question 566

A customer portal query became slow immediately after a SQL compatibility change and operators cannot reproduce the older fast plan from memory. Which technical principle explains the correct response?

  1. Versioned reads can improve concurrency without exposing dirty values when correctly configured.
  2. Query Store provides historical query-plan evidence and supports evidence-based regression diagnosis.
  3. Blocking is waiting for locks; a deadlock involves a cycle that SQL Server must resolve.
  4. Index maintenance should be justified by observed behavior and storage characteristics.

Explanation

Correct Answer

B:

Query Store provides historical query-plan evidence and supports evidence-based regression diagnosis.

Incorrect Answers

A:

Versioned reads can improve concurrency without exposing dirty values when correctly configured. Query Store provides historical query-plan evidence and supports evidence-based regression diagnosis.

C:

Blocking is waiting for locks; a deadlock involves a cycle that SQL Server must resolve. Query Store provides historical query-plan evidence and supports evidence-based regression diagnosis.

D:

Index maintenance should be justified by observed behavior and storage characteristics. Query Store provides historical query-plan evidence and supports evidence-based regression diagnosis.

Question 567

A pricing service caches DAB responses but customers continue receiving superseded prices after a time-sensitive promotion update. Which TWO options together specify a corrective step and a meaningful test?

  1. The service returns current approved prices within the agreed freshness interval after a change.
  2. A client retrieves only changed keys since its saved version and safely handles retention gaps.
  3. Require and test appropriate service-level authentication and network restrictions at every reachable endpoint.
  4. Implement idempotent event handling and durable progress controls for the SQL trigger binding.
  5. Design appropriate cache freshness and invalidation semantics for the business price lifecycle.

Explanation

Correct Answers

A:

The service returns current approved prices within the agreed freshness interval after a change.

E:

Design appropriate cache freshness and invalidation semantics for the business price lifecycle. The service returns current approved prices within the agreed freshness interval after a change.

Incorrect Answers

B:

A client retrieves only changed keys since its saved version and safely handles retention gaps. The service returns current approved prices within the agreed freshness interval after a change.

C:

Require and test appropriate service-level authentication and network restrictions at every reachable endpoint. The service returns current approved prices within the agreed freshness interval after a change.

D:

Implement idempotent event handling and durable progress controls for the SQL trigger binding. The service returns current approved prices within the agreed freshness interval after a change. Design appropriate cache freshness and invalidation semantics for the business price lifecycle.

Question 568

A developer asks a coding assistant to optimize a stored procedure and accepts generated SQL that removes a tenant filter to improve latency. Which observation is the strongest evidence for the reported problem?

  1. A code review finds customer identifiers and credential-like strings committed alongside instruction markdown.
  2. Authorized staff cannot access the expected assistant despite seeing it in a marketing demonstration.
  3. A proposed query runs faster in a developer test but returns records belonging to other tenants.
  4. MCP tool metadata shows privileges that include schema changes and unrelated sensitive tables.

Explanation

Correct Answer

C:

A proposed query runs faster in a developer test but returns records belonging to other tenants. AI-assisted development does not remove developer responsibility for SQL authorization and correctness.

Incorrect Answers

A:

A code review finds customer identifiers and credential-like strings committed alongside instruction markdown. AI-assisted development does not remove developer responsibility for SQL authorization and correctness. A proposed query runs faster in a developer test but returns records belonging to other tenants.

B:

Authorized staff cannot access the expected assistant despite seeing it in a marketing demonstration. AI-assisted development does not remove developer responsibility for SQL authorization and correctness. A proposed query runs faster in a developer test but returns records belonging to other tenants.

D:

MCP tool metadata shows privileges that include schema changes and unrelated sensitive tables. AI-assisted development does not remove developer responsibility for SQL authorization and correctness. A proposed query runs faster in a developer test but returns records belonging to other tenants.

Question 569

A batch embedding job calls a model endpoint without rate-limit handling and silently skips rows when throughput is exceeded. Which next step most directly resolves this SQL solution issue?

  1. Implement bounded retries, observability, idempotent row-level progress, and quota-aware batching.
  2. Benchmark a suitable supported model for structured output on representative invoices and enforce schema validation.
  3. Use an event-driven Azure Function SQL trigger pattern with durable retries and source version checks.
  4. Use Change Tracking or another supported change signal to queue reliable re-embedding of modified source records.

Explanation

Correct Answer

A:

Implement bounded retries, observability, idempotent row-level progress, and quota-aware batching. Reliable embedding generation needs operational controls beyond issuing model requests.

Incorrect Answers

B:

Benchmark a suitable supported model for structured output on representative invoices and enforce schema validation. Reliable embedding generation needs operational controls beyond issuing model requests. Implement bounded retries, observability, idempotent row-level progress, and quota-aware batching.

C:

Use an event-driven Azure Function SQL trigger pattern with durable retries and source version checks. Reliable embedding generation needs operational controls beyond issuing model requests. Implement bounded retries, observability, idempotent row-level progress, and quota-aware batching.

D:

Use Change Tracking or another supported change signal to queue reliable re-embedding of modified source records. Reliable embedding generation needs operational controls beyond issuing model requests. Implement bounded retries, observability, idempotent row-level progress, and quota-aware batching.

Question 570

A multitenant database serves a tiny customer and a giant enterprise through the same stored procedure; one cached plan is poor for the other. Which clue best distinguishes this issue from similar incidents?

  1. The plan includes hundreds of thousands of lookups for columns absent from the nonclustered index.
  2. The captured plan was compiled with a tiny tenant ID and scans badly when reused for a huge tenant.
  3. Performance traces show no index scan regression but rebuild operations consume hours of I/O.
  4. Resource charts show high CPU while the team has no ranked list of query costs.

Explanation

Correct Answer

B:

The captured plan was compiled with a tiny tenant ID and scans badly when reused for a huge tenant. Cardinality skew can make a single cached plan suboptimal across parameter values.

Incorrect Answers

A:

The plan includes hundreds of thousands of lookups for columns absent from the nonclustered index. Cardinality skew can make a single cached plan suboptimal across parameter values. The captured plan was compiled with a tiny tenant ID and scans badly when reused for a huge tenant.

C:

Performance traces show no index scan regression but rebuild operations consume hours of I/O. Cardinality skew can make a single cached plan suboptimal across parameter values. The captured plan was compiled with a tiny tenant ID and scans badly when reused for a huge tenant.

D:

Resource charts show high CPU while the team has no ranked list of query costs. Cardinality skew can make a single cached plan suboptimal across parameter values. The captured plan was compiled with a tiny tenant ID and scans badly when reused for a huge tenant.

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