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 59
Question 580
A deployment script hardcodes a development database endpoint and CI unexpectedly connects to test during a production release. Which observation is the strongest evidence for the reported problem?
Explanation
Correct Answer
Pipeline logs identify the wrong connection target for a reviewed release. Deployment configuration and identity should jointly prevent cross-environment mistakes.
Incorrect Answers
Predeployment comparison shows the live procedure body differs from the reviewed project model. Deployment configuration and identity should jointly prevent cross-environment mistakes. Pipeline logs identify the wrong connection target for a reviewed release.
Repository history and build logs still contain the old secret even after the most recent file changes. Deployment configuration and identity should jointly prevent cross-environment mistakes. Pipeline logs identify the wrong connection target for a reviewed release.
The same stored credential can alter every production database regardless of the pipeline target. Deployment configuration and identity should jointly prevent cross-environment mistakes. Pipeline logs identify the wrong connection target for a reviewed release.
Question 581
A team switches between hosted models in a coding assistant and assumes all model endpoints have identical data handling terms. What should the database developer do FIRST within approved procedures?
Explanation
Correct Answer
Review each configured model's data processing, retention, region, and tenant policy before sending SQL schema or examples. Model choice is part of data governance, not merely a response-quality preference.
Incorrect Answers
Create reviewed repository instruction files that specify migration, test, and secure coding conventions without embedding secrets. Model choice is part of data governance, not merely a response-quality preference. Review each configured model's data processing, retention, region, and tenant policy before sending SQL schema or examples.
Add representative test data and assert the business outputs before accepting the generated change. Model choice is part of data governance, not merely a response-quality preference. Review each configured model's data processing, retention, region, and tenant policy before sending SQL schema or examples.
Reconfigure the MCP endpoint with least-privilege access and narrow approved operations before any production execution. Model choice is part of data governance, not merely a response-quality preference. Review each configured model's data processing, retention, region, and tenant policy before sending SQL schema or examples.
Question 582
A telemetry ingestion service sees hot-row latch contention in a small transient state table during bursty writes. What technical finding would substantiate this root cause?
Explanation
Correct Answer
Wait analysis shows repeated contention concentrated on the transient state table during spikes. Memory-optimized designs address specific concurrency patterns and require explicit durability tradeoffs.
Incorrect Answers
The plan scans many rows and performs a costly sort for a small tenant-specific result. Memory-optimized designs address specific concurrency patterns and require explicit durability tradeoffs. Wait analysis shows repeated contention concentrated on the transient state table during spikes.
Integrity checks identify line rows with identifiers missing from the invoice parent table. Memory-optimized designs address specific concurrency patterns and require explicit durability tradeoffs. Wait analysis shows repeated contention concentrated on the transient state table during spikes.
Storage inspection finds most optional attribute columns are NULL in nearly every row. Memory-optimized designs address specific concurrency patterns and require explicit durability tradeoffs. Wait analysis shows repeated contention concentrated on the transient state table during spikes.
Question 583
A mobile application needs to learn which customer IDs changed since its last successful sync without storing complete before-and-after value history. Which technical principle explains the correct response?
Explanation
Correct Answer
Change Tracking is suited to changed-row identification rather than full change payload history.
Incorrect Answers
Caching must respect correctness and freshness requirements for mutable business records. Change Tracking is suited to changed-row identification rather than full change payload history.
Deployable API configuration is part of the governed application artifact. Change Tracking is suited to changed-row identification rather than full change payload history.
GraphQL relationships need explicit API modeling beyond raw relational keys. Change Tracking is suited to changed-row identification rather than full change payload history.
Question 584
A deduplication service needs to propose likely duplicate customer names despite small spelling differences, but exact equality misses them. What should the database developer verify to confirm the suspected cause?
Explanation
Correct Answer
Two records for the same entity differ by a transposition while exact lookup finds neither as duplicates. Fuzzy matching helps generate candidates but scores are not proof of identity.
Incorrect Answers
A text LIKE filter accidentally matches a partial tag inside an unrelated attribute. Fuzzy matching helps generate candidates but scores are not proof of identity. Two records for the same entity differ by a transposition while exact lookup finds neither as duplicates.
A basic replace misses some token variations and leaves identifiers in test messages. Fuzzy matching helps generate candidates but scores are not proof of identity. Two records for the same entity differ by a transposition while exact lookup finds neither as duplicates.
Two tied sellers swap order across executions despite identical source revenue. Fuzzy matching helps generate candidates but scores are not proof of identity. Two records for the same entity differ by a transposition while exact lookup finds neither as duplicates.
Question 585
An Azure-hosted service connects to Azure SQL with a long-lived database password embedded in a configuration file and rotates credentials infrequently. Which corrective action best fits the observed symptoms?
Explanation
Correct Answer
Use a suitable managed identity and Microsoft Entra authorization path supported by the SQL service. Passwordless managed identity can reduce secret distribution when authorization is configured correctly.
Incorrect Answers
Implement database-enforced row-level security using an appropriate security predicate and trustworthy session identity. Passwordless managed identity can reduce secret distribution when authorization is configured correctly. Use a suitable managed identity and Microsoft Entra authorization path supported by the SQL service.
Add appropriate query/activity monitoring and tested audit correlation without logging unnecessary sensitive payloads. Passwordless managed identity can reduce secret distribution when authorization is configured correctly. Use a suitable managed identity and Microsoft Entra authorization path supported by the SQL service.
Apply row/object permissions or client-side protection appropriate to the threat model. Passwordless managed identity can reduce secret distribution when authorization is configured correctly. Use a suitable managed identity and Microsoft Entra authorization path supported by the SQL service.
Question 586
A vector ingestion pipeline occasionally receives model output with an unexpected shape and attempts to add it to a dimension-specific index. How should the SQL engineering team confirm the issue is truly resolved?
Explanation
Correct Answer
A pre-insert check identifies incompatible vectors and routes them to repair before indexing. The operating rule is: Vector metadata validation prevents mixing incompatible representations in search structures.
Incorrect Answers
The deployed index and benchmark use the same metric and meet target relevance. The operating rule is: Vector metadata validation prevents mixing incompatible representations in search structures. A pre-insert check identifies incompatible vectors and routes them to repair before indexing.
Negative cross-tenant searches reveal no unauthorized chunks or metadata. The operating rule is: Vector metadata validation prevents mixing incompatible representations in search structures. A pre-insert check identifies incompatible vectors and routes them to repair before indexing.
The selected retrieval method meets the required accuracy and response-time targets for each workload. The operating rule is: Vector metadata validation prevents mixing incompatible representations in search structures. A pre-insert check identifies incompatible vectors and routes them to repair before indexing.
Question 587
A document search system builds vectors from entire customer records including social identifiers and confidential notes, despite requiring only product descriptions. What distinction makes the recommended approach appropriate?
Explanation
Correct Answer
Embedding input selection is part of both relevance engineering and data minimization.
Incorrect Answers
Model integration security must cover both database identity and downstream inference access. Embedding input selection is part of both relevance engineering and data minimization.
Embedding metadata enables quality monitoring, reconciliation, and safe model evolution. Embedding input selection is part of both relevance engineering and data minimization.
Embedding stores need a maintenance strategy that follows authoritative source changes. Embedding input selection is part of both relevance engineering and data minimization.
Question 588
A semantic search service compares embedding vectors with inconsistent magnitudes and treats raw dot-product scores as comparable cosine similarity. What technical finding would substantiate this root cause?
Explanation
Correct Answer
The same semantic candidate changes rank mainly because of vector magnitude rather than meaning. Vector normalization and distance metrics must be consistent across indexing and querying.
Incorrect Answers
Execution plans show scans with wildcard matching against long FAQ text columns. Vector normalization and distance metrics must be consistent across indexing and querying. The same semantic candidate changes rank mainly because of vector magnitude rather than meaning.
One retrieval modality dominates because its arbitrary numeric score range is larger. Vector normalization and distance metrics must be consistent across indexing and querying. The same semantic candidate changes rank mainly because of vector magnitude rather than meaning.
A discontinued SKU scores high on semantic relevance and appears as an orderable suggestion. Vector normalization and distance metrics must be consistent across indexing and querying. The same semantic candidate changes rank mainly because of vector magnitude rather than meaning.
Question 589
A GraphQL API maps customer and invoice tables and a consumer can ask for sensitive fields not shown in the application UI. Which TWO options together specify a corrective step and a meaningful test?
Explanation
Correct Answers
Unapproved GraphQL fields remain unavailable while normal approved queries operate. The corresponding check is whether constrain GraphQL schema exposure and field/row authorization to approved data paths.
Constrain GraphQL schema exposure and field/row authorization to approved data paths. Unapproved GraphQL fields remain unavailable while normal approved queries operate.
Incorrect Answers
Implement database-enforced row-level security using an appropriate security predicate and trustworthy session identity. Unapproved GraphQL fields remain unavailable while normal approved queries operate.
Apply service authentication, tool allowlists, scoped SQL permissions, and approval for state changes. Unapproved GraphQL fields remain unavailable while normal approved queries operate.
Only approved fields are embedded and unauthorized users cannot retrieve protected source or embedding records. Unapproved GraphQL fields remain unavailable while normal approved queries operate.
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.
Developing AI-Enabled Database Solutions (DP-800) Practice Tests
- 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)
- 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)