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

  1. Job logs show throttled responses while the completion report claims all records were embedded.
  2. Client inserts slow down when synchronous model calls run inside the database write path.
  3. The pipeline receives an image input but no compatible image representation is produced.
  4. Embedding input logs show private identifiers unrelated to the search task.

Explanation

Correct Answer

D:

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

A:

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.

B:

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.

C:

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?

  1. Representative analytics become faster while ingestion and operational lookups remain within their agreed limits.
  2. The targeted query performs a selective seek with fewer reads and without an unacceptable write penalty.
  3. Checkout transaction latency remains stable while reporting queries use purpose-built structures.
  4. A time-based query returns the correct historical version and retention follows policy.

Explanation

Correct Answer

D:

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

A:

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.

B:

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.

C:

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.

  1. Grant the function only the change-data access it requires and review its output destination.
  2. The rotation completes without lost access and recovered data can still be decrypted by authorized services.
  3. The application connects with its scoped identity while no reusable database password is stored in code.
  4. Use a suitable managed identity and Microsoft Entra authorization path supported by the SQL service.
  5. Configure appropriate SQL auditing to a protected destination with tested retention and access reviews.

Explanation

Correct Answers

C:

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.

D:

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

A:

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.

B:

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.

E:

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.

  1. Benchmark a suitable supported model for structured output on representative invoices and enforce schema validation.
  2. Version the model configuration and compare outputs, latency, and contracts before controlled replacement.
  3. The model returns schema-valid fields with acceptable extraction accuracy and appropriate human review.
  4. Create a compatible versioned embedding migration with dimension checks and rebuild the affected index where required.
  5. A staged migration passes regression benchmarks and retains a clear rollback route.

Explanation

Correct Answers

B:

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.

E:

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

A:

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.

C:

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.

D:

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?

  1. Evaluate ledger table capabilities and secure digest verification while maintaining role-based write controls.
  2. Add supported CHECK and DEFAULT constraints consistent with the application contract.
  3. Use a SEQUENCE object and document its caching and gap behavior for consumers.
  4. Consider supported graph node and edge tables and evaluate query readability and performance against relational alternatives.

Explanation

Correct Answer

C:

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

A:

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.

B:

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.

D:

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?

  1. The service can query approved totals and receives an authorization error for direct sensitive table reads.
  2. A cross-tenant negative test returns no forbidden records while authorized calls still work.
  3. Running the same deployment twice produces the expected reference rows without duplication.
  4. Either the complete authorized order is committed or the entire unit of work is rolled back.

Explanation

Correct Answer

A:

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

B:

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.

C:

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.

D:

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.

  1. Use available query performance insights, Query Store, and relevant DMVs to identify the top regressed statements.
  2. Use Query Store to compare recorded plans and runtime metrics, then test an appropriate plan-correction strategy.
  3. Analyze the deadlock graph and standardize access order or shorten transactions based on evidence.
  4. The analysis identifies specific statements and a tested change reduces peak resource use.
  5. A controlled plan correction restores target latency without regressing other parameters.

Explanation

Correct Answers

B:

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.

E:

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

A:

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.

C:

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.

D:

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.

  1. Configure appropriate SQL auditing to a protected destination with tested retention and access reviews.
  2. Bind the session context to trusted authenticated identity and prevent untrusted tenant switching.
  3. Apply DAB roles, entity permissions, and backend identity least privilege with negative tests.
  4. A test privilege change creates a protected timestamped audit record tied to the correct identity.
  5. The endpoint returns permitted entities and rejects unauthorized resource and operation combinations.

Explanation

Correct Answers

A:

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.

D:

A test privilege change creates a protected timestamped audit record tied to the correct identity.

Incorrect Answers

B:

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.

C:

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.

E:

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?

  1. Chunking should preserve semantically necessary context instead of merely maximizing ingestion speed.
  2. Embedding metadata enables quality monitoring, reconciliation, and safe model evolution.
  3. Synchronous external calls inside write transactions can couple availability to a remote inference service.
  4. Reliable embedding generation needs operational controls beyond issuing model requests.

Explanation

Correct Answer

A:

Chunking should preserve semantically necessary context instead of merely maximizing ingestion speed.

Incorrect Answers

B:

Embedding metadata enables quality monitoring, reconciliation, and safe model evolution. Chunking should preserve semantically necessary context instead of merely maximizing ingestion speed.

C:

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.

D:

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?

  1. Use a supported SQL vector type with dimension compatibility checks and an appropriate data design.
  2. Benchmark a multilingual embedding/retrieval strategy and compare language-specific recall.
  3. Compare ANN and exact-nearest-neighbor methods using agreed recall and latency thresholds.
  4. Review supported filter placement and retrieve enough authorized candidates before ranking as appropriate.

Explanation

Correct Answer

D:

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

A:

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.

B:

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.

C:

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?

  1. Rotate the exposed credential and move secrets to an approved secret store with restricted pipeline identity.
  2. Resolve schema conflicts with a model diff and tests before approving the combined pull request.
  3. Use schema drift detection against the authoritative SQL Database Project and reconcile the change before deployment.
  4. Add end-to-end integration tests using compatible staged SQL schema and actual API configuration.

Explanation

Correct Answer

B:

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

A:

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.

C:

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.

D:

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