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 67
Question 660
A document search system builds vectors from entire customer records including social identifiers and confidential notes, despite requiring only product descriptions. What technical finding would substantiate this root cause?
Explanation
Correct Answer
Embedding input logs show private identifiers unrelated to the search task. Embedding input selection is part of both relevance engineering and data minimization.
Incorrect Answers
Job logs show throttled responses while the completion report claims all records were embedded. Embedding input selection is part of both relevance engineering and data minimization. Embedding input logs show private identifiers unrelated to the search task.
Client inserts slow down when synchronous model calls run inside the database write path. Embedding input selection is part of both relevance engineering and data minimization. Embedding input logs show private identifiers unrelated to the search task.
The pipeline receives an image input but no compatible image representation is produced. Embedding input selection is part of both relevance engineering and data minimization. Embedding input logs show private identifiers unrelated to the search task.
Question 661
A bank needs to reconstruct the prior values of an account preference after customer service overwrote a row and the current table only stores the latest state. Which outcome shows the requirement is met without introducing a new risk?
Explanation
Correct Answer
A time-based query returns the correct historical version and retention follows policy. The supporting symptom is: Investigators cannot determine what preference was effective before the latest update from the current table.
Incorrect Answers
Representative analytics become faster while ingestion and operational lookups remain within their agreed limits. The supporting symptom is: Investigators cannot determine what preference was effective before the latest update from the current table. A time-based query returns the correct historical version and retention follows policy.
The targeted query performs a selective seek with fewer reads and without an unacceptable write penalty. The supporting symptom is: Investigators cannot determine what preference was effective before the latest update from the current table. A time-based query returns the correct historical version and retention follows policy.
Checkout transaction latency remains stable while reporting queries use purpose-built structures. The supporting symptom is: Investigators cannot determine what preference was effective before the latest update from the current table. A time-based query returns the correct historical version and retention follows policy.
Question 662
An Azure-hosted service connects to Azure SQL with a long-lived database password embedded in a configuration file and rotates credentials infrequently. Select TWO: the best action and the outcome that confirms it worked.
Explanation
Correct Answers
The application connects with its scoped identity while no reusable database password is stored in code. The accompanying action is to use a suitable managed identity and Microsoft Entra authorization path supported by the SQL service.
Use a suitable managed identity and Microsoft Entra authorization path supported by the SQL service. The application connects with its scoped identity while no reusable database password is stored in code.
Incorrect Answers
Grant the function only the change-data access it requires and review its output destination. The application connects with its scoped identity while no reusable database password is stored in code. Use a suitable managed identity and Microsoft Entra authorization path supported by the SQL service.
The rotation completes without lost access and recovered data can still be decrypted by authorized services. The application connects with its scoped identity while no reusable database password is stored in code.
Configure appropriate SQL auditing to a protected destination with tested retention and access reviews. The application connects with its scoped identity while no reusable database password is stored in code. Use a suitable managed identity and Microsoft Entra authorization path supported by the SQL service.
Question 663
A SQL database invokes an external model that is replaced by the provider without a tested compatibility plan. Choose TWO statements: a suitable intervention and evidence of its success.
Explanation
Correct Answers
Version the model configuration and compare outputs, latency, and contracts before controlled replacement. A SQL database invokes an external model that is replaced by the provider without a tested compatibility plan.
A staged migration passes regression benchmarks and retains a clear rollback route. A SQL database invokes an external model that is replaced by the provider without a tested compatibility plan. Version the model configuration and compare outputs, latency, and contracts before controlled replacement.
Incorrect Answers
Benchmark a suitable supported model for structured output on representative invoices and enforce schema validation. A SQL database invokes an external model that is replaced by the provider without a tested compatibility plan. Version the model configuration and compare outputs, latency, and contracts before controlled replacement.
The model returns schema-valid fields with acceptable extraction accuracy and appropriate human review. A SQL database invokes an external model that is replaced by the provider without a tested compatibility plan. Version the model configuration and compare outputs, latency, and contracts before controlled replacement.
Create a compatible versioned embedding migration with dimension checks and rebuild the affected index where required. A SQL database invokes an external model that is replaced by the provider without a tested compatibility plan. Version the model configuration and compare outputs, latency, and contracts before controlled replacement.
Question 664
Several services must assign database-generated batch identifiers without assuming they are gapless when transactions roll back. Which next step most directly resolves this SQL solution issue?
Explanation
Correct Answer
Use a SEQUENCE object and document its caching and gap behavior for consumers. Sequences generate values independently of row identity and do not guarantee gapless numbering.
Incorrect Answers
Evaluate ledger table capabilities and secure digest verification while maintaining role-based write controls. Sequences generate values independently of row identity and do not guarantee gapless numbering. Use a SEQUENCE object and document its caching and gap behavior for consumers.
Add supported CHECK and DEFAULT constraints consistent with the application contract. Sequences generate values independently of row identity and do not guarantee gapless numbering. Use a SEQUENCE object and document its caching and gap behavior for consumers.
Consider supported graph node and edge tables and evaluate query readability and performance against relational alternatives. Sequences generate values independently of row identity and do not guarantee gapless numbering. Use a SEQUENCE object and document its caching and gap behavior for consumers.
Question 665
A reporting service needs current invoice totals but must not expose underlying customer identifiers and the API currently queries raw tables directly. Which test result would demonstrate the fix worked?
Explanation
Correct Answer
The service can query approved totals and receives an authorization error for direct sensitive table reads. The operating rule is: Views can present controlled data shapes but underlying permissions must still enforce security.
Incorrect Answers
A cross-tenant negative test returns no forbidden records while authorized calls still work. The operating rule is: Views can present controlled data shapes but underlying permissions must still enforce security. The service can query approved totals and receives an authorization error for direct sensitive table reads.
Running the same deployment twice produces the expected reference rows without duplication. The operating rule is: Views can present controlled data shapes but underlying permissions must still enforce security. The service can query approved totals and receives an authorization error for direct sensitive table reads.
Either the complete authorized order is committed or the entire unit of work is rolled back. The operating rule is: Views can present controlled data shapes but underlying permissions must still enforce security. The service can query approved totals and receives an authorization error for direct sensitive table reads.
Question 666
A customer portal query became slow immediately after a SQL compatibility change and operators cannot reproduce the older fast plan from memory. Choose TWO: one correct response and one verification of success.
Explanation
Correct Answers
Use Query Store to compare recorded plans and runtime metrics, then test an appropriate plan-correction strategy. This gives the verification result for the issue: A customer portal query became slow immediately after a SQL compatibility change and operators cannot reproduce the older fast plan from memory.
A controlled plan correction restores target latency without regressing other parameters. This gives the verification result for the issue: A customer portal query became slow immediately after a SQL compatibility change and operators cannot reproduce the older fast plan from memory.
Incorrect Answers
Use available query performance insights, Query Store, and relevant DMVs to identify the top regressed statements. This gives the verification result for the issue: A customer portal query became slow immediately after a SQL compatibility change and operators cannot reproduce the older fast plan from memory. Use Query Store to compare recorded plans and runtime metrics, then test an appropriate plan-correction strategy.
Analyze the deadlock graph and standardize access order or shorten transactions based on evidence. This gives the verification result for the issue: A customer portal query became slow immediately after a SQL compatibility change and operators cannot reproduce the older fast plan from memory. A controlled plan correction restores target latency without regressing other parameters.
The analysis identifies specific statements and a tested change reduces peak resource use. This gives the verification result for the issue: A customer portal query became slow immediately after a SQL compatibility change and operators cannot reproduce the older fast plan from memory. A controlled plan correction restores target latency without regressing other parameters.
Question 667
A regulated SQL system must reconstruct who changed permission grants last week but the database has no retained audit evidence. Choose TWO statements: a suitable intervention and evidence of its success.
Explanation
Correct Answers
Configure appropriate SQL auditing to a protected destination with tested retention and access reviews. A test privilege change creates a protected timestamped audit record tied to the correct identity.
A test privilege change creates a protected timestamped audit record tied to the correct identity.
Incorrect Answers
Bind the session context to trusted authenticated identity and prevent untrusted tenant switching. A test privilege change creates a protected timestamped audit record tied to the correct identity.
Apply DAB roles, entity permissions, and backend identity least privilege with negative tests. A test privilege change creates a protected timestamped audit record tied to the correct identity. Configure appropriate SQL auditing to a protected destination with tested retention and access reviews.
The endpoint returns permitted entities and rejects unauthorized resource and operation combinations. A test privilege change creates a protected timestamped audit record tied to the correct identity.
Question 668
A SQL-based document assistant splits contracts every fixed number of characters and frequently separates a clause from its exception and heading. Which concept should guide the database developer in this situation?
Explanation
Correct Answer
Chunking should preserve semantically necessary context instead of merely maximizing ingestion speed.
Incorrect Answers
Embedding metadata enables quality monitoring, reconciliation, and safe model evolution. Chunking should preserve semantically necessary context instead of merely maximizing ingestion speed.
Synchronous external calls inside write transactions can couple availability to a remote inference service. Chunking should preserve semantically necessary context instead of merely maximizing ingestion speed.
Reliable embedding generation needs operational controls beyond issuing model requests. Chunking should preserve semantically necessary context instead of merely maximizing ingestion speed.
Question 669
A support API requests top five nearest results but applies an incompatible filter after the query and often receives zero results for small tenants. Which corrective action best fits the observed symptoms?
Explanation
Correct Answer
Review supported filter placement and retrieve enough authorized candidates before ranking as appropriate. Top-k selection and filtering order affect both relevance and security.
Incorrect Answers
Use a supported SQL vector type with dimension compatibility checks and an appropriate data design. Top-k selection and filtering order affect both relevance and security. Review supported filter placement and retrieve enough authorized candidates before ranking as appropriate.
Benchmark a multilingual embedding/retrieval strategy and compare language-specific recall. Top-k selection and filtering order affect both relevance and security. Review supported filter placement and retrieve enough authorized candidates before ranking as appropriate.
Compare ANN and exact-nearest-neighbor methods using agreed recall and latency thresholds. Top-k selection and filtering order affect both relevance and security. Review supported filter placement and retrieve enough authorized candidates before ranking as appropriate.
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.
Developing AI-Enabled Database Solutions (DP-800) Practice Tests
- Microsoft DP-800 Practice Test 65 - 10 Questions (Last Reviewed 09-Nov-2026)
- 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)