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 68
Question 670
Two feature branches independently modify the same customer table and the merged migration accidentally drops a required column. What is the MOST appropriate initial remediation?
Explanation
Correct Answer
Resolve schema conflicts with a model diff and tests before approving the combined pull request. Database merge conflicts can affect schema semantics beyond textual file overlap.
Incorrect Answers
Rotate the exposed credential and move secrets to an approved secret store with restricted pipeline identity. Database merge conflicts can affect schema semantics beyond textual file overlap. Resolve schema conflicts with a model diff and tests before approving the combined pull request.
Use schema drift detection against the authoritative SQL Database Project and reconcile the change before deployment. Database merge conflicts can affect schema semantics beyond textual file overlap. Resolve schema conflicts with a model diff and tests before approving the combined pull request.
Add end-to-end integration tests using compatible staged SQL schema and actual API configuration. Database merge conflicts can affect schema semantics beyond textual file overlap. Resolve schema conflicts with a model diff and tests before approving the combined pull request.
Question 671
A legal research system chooses approximate nearest-neighbor search for speed but a small high-stakes sample requires exhaustive top-k accuracy. What distinction makes the recommended approach appropriate?
Explanation
Correct Answer
Approximate search gains speed by accepting possible recall loss relative to exact search.
Incorrect Answers
Lexical and semantic relevance target different retrieval needs and are often complementary. Approximate search gains speed by accepting possible recall loss relative to exact search.
Hybrid search can combine complementary lexical precision and semantic recall. Approximate search gains speed by accepting possible recall loss relative to exact search.
Search quality depends on keeping index state synchronized with current vector records. Approximate search gains speed by accepting possible recall loss relative to exact search.
Question 672
A batch embedding job calls a model endpoint without rate-limit handling and silently skips rows when throughput is exceeded. Which observation is the strongest evidence for the reported problem?
Explanation
Correct Answer
Job logs show throttled responses while the completion report claims all records were embedded. Reliable embedding generation needs operational controls beyond issuing model requests.
Incorrect Answers
Queries in one language miss conceptually matching incident notes written in another. Reliable embedding generation needs operational controls beyond issuing model requests. Job logs show throttled responses while the completion report claims all records were embedded.
The vector table retains deleted product entries and lacks vectors for recent updates. Reliable embedding generation needs operational controls beyond issuing model requests. Job logs show throttled responses while the completion report claims all records were embedded.
After endpoint upgrade structured responses no longer satisfy the application's JSON schema. Reliable embedding generation needs operational controls beyond issuing model requests. Job logs show throttled responses while the completion report claims all records were embedded.
Question 673
An invoice line table accepts a nonexistent invoice identifier and accounting totals include orphaned lines after imports. What distinction makes the recommended approach appropriate?
Explanation
Correct Answer
Referential constraints express durable relationships more reliably than application-only checks.
Incorrect Answers
Temporal history tracks row versions for point-in-time inspection rather than relying on audit guesses. Referential constraints express durable relationships more reliably than application-only checks.
Semi-structured JSON still needs deliberate schema validation and indexing for predictable filtering. Referential constraints express durable relationships more reliably than application-only checks.
Ledger features provide tamper-evidence verification but do not replace authorization or backups. Referential constraints express durable relationships more reliably than application-only checks.
Question 674
A regulated app writes SQL audit logs to short-lived storage and a retention job removes investigation evidence before the mandated period. How should the SQL engineering team confirm the issue is truly resolved?
Explanation
Correct Answer
Test audit events remain retrievable and immutable for the required retention period. The operating rule is: Audit coverage is incomplete without secure durable retention and controlled access.
Incorrect Answers
Only approved fields are embedded and unauthorized users cannot retrieve protected source or embedding records. The operating rule is: Audit coverage is incomplete without secure durable retention and controlled access. Test audit events remain retrievable and immutable for the required retention period.
Unauthorized context switching is rejected and each user remains restricted to their approved tenant. The operating rule is: Audit coverage is incomplete without secure durable retention and controlled access. Test audit events remain retrievable and immutable for the required retention period.
The function processes authorized events while negative access tests deny unrelated tables. The operating rule is: Audit coverage is incomplete without secure durable retention and controlled access. Test audit events remain retrievable and immutable for the required retention period.
Question 675
A SQL MCP tool returns a table comment that instructs an AI coding assistant to read a secret table and send data to another endpoint. Choose TWO statements: a suitable intervention and evidence of its success.
Explanation
Correct Answers
The assistant ignores the embedded command and logs no attempt to access the secret table. Treat retrieved schema documentation as untrusted task data and block unauthorized tool calls.
Treat retrieved schema documentation as untrusted task data and block unauthorized tool calls.
Incorrect Answers
Reconfigure the MCP endpoint with least-privilege access and narrow approved operations before any production execution. Treat retrieved schema documentation as untrusted task data and block unauthorized tool calls. The assistant ignores the embedded command and logs no attempt to access the secret table.
A reviewed migration is applied through the authorized pipeline and subsequent tests confirm the changed procedure. Treat retrieved schema documentation as untrusted task data and block unauthorized tool calls. The assistant ignores the embedded command and logs no attempt to access the secret table.
Treat the suggestion as untrusted code and require code review, data access tests, and execution plan analysis. Treat retrieved schema documentation as untrusted task data and block unauthorized tool calls. The assistant ignores the embedded command and logs no attempt to access the secret table.
Question 676
An API that calls Azure SQL has intermittent timeouts but the team monitors only average SQL CPU and cannot tie failures to individual requests. Which TWO options together specify a corrective step and a meaningful test?
Explanation
Correct Answers
Enable suitable Application Insights and Log Analytics telemetry with correlation IDs and safe logging. An API that calls Azure SQL has intermittent timeouts but the team monitors only average SQL CPU and cannot tie failures to individual requests.
A test request can be traced across API and SQL dependencies to the failing span. An API that calls Azure SQL has intermittent timeouts but the team monitors only average SQL CPU and cannot tie failures to individual requests. Enable suitable Application Insights and Log Analytics telemetry with correlation IDs and safe logging.
Incorrect Answers
Design appropriate cache freshness and invalidation semantics for the business price lifecycle. An API that calls Azure SQL has intermittent timeouts but the team monitors only average SQL CPU and cannot tie failures to individual requests. Enable suitable Application Insights and Log Analytics telemetry with correlation IDs and safe logging.
Allowed requests invoke the intended procedure and crafted SQL payloads are rejected. An API that calls Azure SQL has intermittent timeouts but the team monitors only average SQL CPU and cannot tie failures to individual requests. A test request can be traced across API and SQL dependencies to the failing span.
Restrict exposed fields and filtering operations to approved entity properties. An API that calls Azure SQL has intermittent timeouts but the team monitors only average SQL CPU and cannot tie failures to individual requests. Enable suitable Application Insights and Log Analytics telemetry with correlation IDs and safe logging.
Question 677
An AI-enabled SQL workflow calls a model service with an API key stored in a database object accessible to developers. How should the SQL engineering team confirm the issue is truly resolved?
Explanation
Correct Answer
Authorized model calls succeed with least privilege and no plaintext key is exposed to unrelated readers. The supporting symptom is: Source inspection exposes a credential that can invoke the model service outside the approved workflow.
Incorrect Answers
Test audit events remain retrievable and immutable for the required retention period. The supporting symptom is: Source inspection exposes a credential that can invoke the model service outside the approved workflow. Authorized model calls succeed with least privilege and no plaintext key is exposed to unrelated readers.
The application connects with its scoped identity while no reusable database password is stored in code. The supporting symptom is: Source inspection exposes a credential that can invoke the model service outside the approved workflow. Authorized model calls succeed with least privilege and no plaintext key is exposed to unrelated readers.
The web application runs normal queries while an attempted schema modification is denied. The supporting symptom is: Source inspection exposes a credential that can invoke the model service outside the approved workflow. Authorized model calls succeed with least privilege and no plaintext key is exposed to unrelated readers.
Question 678
A multilingual knowledge base stores English-only embeddings and assumes a translated query produces equivalent relevance in all supported locales. What distinction makes the recommended approach appropriate?
Explanation
Correct Answer
Vector semantic performance is model and language dependent, not guaranteed by storing numbers.
Incorrect Answers
Full-text search provides token-aware retrieval beyond ordinary substring filters. Vector semantic performance is model and language dependent, not guaranteed by storing numbers.
Typed vector storage is preferable to ad hoc serialization when supported by the SQL engine. Vector semantic performance is model and language dependent, not guaranteed by storing numbers.
Hybrid search can combine complementary lexical precision and semantic recall. Vector semantic performance is model and language dependent, not guaranteed by storing numbers.
Question 679
A fraud analyst stores account-device links in graph tables but manually joins three edge tables to detect accounts connected through a shared device. What distinction makes the recommended approach appropriate?
Explanation
Correct Answer
MATCH expresses graph patterns across documented node and edge relationships.
Incorrect Answers
Native JSON functions help create valid structured output instead of fragile manual string concatenation. MATCH expresses graph patterns across documented node and edge relationships.
Regex substitution supports structured redaction only when patterns are thoroughly validated. MATCH expresses graph patterns across documented node and edge relationships.
Window offset functions simplify ordered comparisons but do not create missing time periods. MATCH expresses graph patterns across documented node and edge relationships.
Question 680
A semantic search service compares embedding vectors with inconsistent magnitudes and treats raw dot-product scores as comparable cosine similarity. What should the database developer do FIRST within approved procedures?
Explanation
Correct Answer
Apply an appropriate normalization strategy such as VECTOR_NORMALIZE and verify the chosen similarity metric. Vector normalization and distance metrics must be consistent across indexing and querying.
Incorrect Answers
Use a supported SQL vector type with dimension compatibility checks and an appropriate data design. Vector normalization and distance metrics must be consistent across indexing and querying. Apply an appropriate normalization strategy such as VECTOR_NORMALIZE and verify the chosen similarity metric.
Align index metric, query scoring, and model expectations; validate on labeled relevant pairs. Vector normalization and distance metrics must be consistent across indexing and querying. Apply an appropriate normalization strategy such as VECTOR_NORMALIZE and verify the chosen similarity metric.
Review supported filter placement and retrieve enough authorized candidates before ranking as appropriate. Vector normalization and distance metrics must be consistent across indexing and querying. Apply an appropriate normalization strategy such as VECTOR_NORMALIZE and verify the chosen similarity metric.
Developing AI-Enabled Database Solutions (DP-800) Practice Tests
- Microsoft DP-800 Practice Test 66 - 10 Questions (Last Reviewed 08-Nov-2026)
- Microsoft DP-800 Practice Test 67 - 10 Questions (Last Reviewed 07-Nov-2026)
- Microsoft DP-800 Practice Test 68 - 10 Questions (Last Reviewed 06-Nov-2026)
- Microsoft DP-800 Practice Test 69 - 10 Questions (Last Reviewed 05-Nov-2026)
- Microsoft DP-800 Practice Test 70 - 10 Questions (Last Reviewed 04-Nov-2026)