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 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?
Explanation
Correct Answer
The graph identifies reversed lock acquisition order for the two transactions. Consistent lock acquisition and bounded transactions can reduce application deadlocks.
Incorrect Answers
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.
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.
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?
Explanation
Correct Answer
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 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.
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.
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?
Explanation
Correct Answer
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
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.
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.
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.
Explanation
Correct Answers
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.
Investigate parameter-sensitive plans and choose an engine-supported mitigation after measuring both workloads.
Incorrect Answers
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.
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.
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.
Explanation
Correct Answers
Enforce authorized tenant scoping through backend policies and service identity rather than trust the caller's filter.
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
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.
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.
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.
Explanation
Correct Answers
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.
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
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.
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.
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?
Explanation
Correct Answer
Query Store provides historical query-plan evidence and supports evidence-based regression diagnosis.
Incorrect Answers
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.
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.
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?
Explanation
Correct Answers
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. The service returns current approved prices within the agreed freshness interval after a change.
Incorrect Answers
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.
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.
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?
Explanation
Correct Answer
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 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.
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.
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?
Explanation
Correct Answer
Implement bounded retries, observability, idempotent row-level progress, and quota-aware batching. Reliable embedding generation needs operational controls beyond issuing model requests.
Incorrect Answers
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.
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.
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?
Explanation
Correct Answer
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
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.
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.
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
- Microsoft DP-800 Practice Test 55 - 10 Questions (Last Reviewed 23-Sep-2026)
- Microsoft DP-800 Practice Test 56 - 10 Questions (Last Reviewed 22-Sep-2026)
- Microsoft DP-800 Practice Test 57 - 10 Questions (Last Reviewed 17-Nov-2026)
- 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)