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

Question 60

A telemetry ingestion service sees hot-row latch contention in a small transient state table during bursty writes. What would be a valid post-database-change verification?

  1. The SQL query reads the correct current permitted external records with monitored latency and access controls.
  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 load test shows lower contention without unacceptable loss of required durable records.

Explanation

Correct Answer

D:

A load test shows lower contention without unacceptable loss of required durable records.

Incorrect Answers

A:

The SQL query reads the correct current permitted external records with monitored latency and access controls. A load test shows lower contention without unacceptable loss of required durable records.

B:

The targeted query performs a selective seek with fewer reads and without an unacceptable write penalty. A load test shows lower contention without unacceptable loss of required durable records.

C:

Checkout transaction latency remains stable while reporting queries use purpose-built structures. A load test shows lower contention without unacceptable loss of required durable records.

Question 61

A coding assistant recommends several indexes on an order database without seeing production write frequency or storage quotas. What is the MOST appropriate initial remediation?

  1. Treat the suggestion as untrusted code and require code review, data access tests, and execution plan analysis.
  2. Replace live values with safe synthetic examples and enforce repository secret and privacy scanning.
  3. Use explicit environment labels, scoped credentials, and approval boundaries for each endpoint.
  4. Compare recommendations with actual workload plans, maintenance costs, and performance tests before approval.

Explanation

Correct Answer

D:

Compare recommendations with actual workload plans, maintenance costs, and performance tests before approval. AI suggestions must be benchmarked against production-like workload tradeoffs rather than adopted by confidence.

Incorrect Answers

A:

Treat the suggestion as untrusted code and require code review, data access tests, and execution plan analysis. AI suggestions must be benchmarked against production-like workload tradeoffs rather than adopted by confidence. Compare recommendations with actual workload plans, maintenance costs, and performance tests before approval.

B:

Replace live values with safe synthetic examples and enforce repository secret and privacy scanning. AI suggestions must be benchmarked against production-like workload tradeoffs rather than adopted by confidence. Compare recommendations with actual workload plans, maintenance costs, and performance tests before approval.

C:

Use explicit environment labels, scoped credentials, and approval boundaries for each endpoint. AI suggestions must be benchmarked against production-like workload tradeoffs rather than adopted by confidence. Compare recommendations with actual workload plans, maintenance costs, and performance tests before approval.

Question 62

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. What should the database developer verify to confirm the suspected cause?

  1. A test prompt asks for one dataset but the tool can enumerate unrelated workspace objects.
  2. A proposed query runs faster in a developer test but returns records belonging to other tenants.
  3. The malicious instruction appears in a database comment rather than an approved developer request.
  4. The query explanation shows proposed changes but the database still contains the original stored procedure.

Explanation

Correct Answer

C:

The malicious instruction appears in a database comment rather than an approved developer request. Untrusted tool output must not acquire higher instruction priority than authorized developer intent.

Incorrect Answers

A:

A test prompt asks for one dataset but the tool can enumerate unrelated workspace objects. Untrusted tool output must not acquire higher instruction priority than authorized developer intent. The malicious instruction appears in a database comment rather than an approved developer request.

B:

A proposed query runs faster in a developer test but returns records belonging to other tenants. Untrusted tool output must not acquire higher instruction priority than authorized developer intent. The malicious instruction appears in a database comment rather than an approved developer request.

D:

The query explanation shows proposed changes but the database still contains the original stored procedure. Untrusted tool output must not acquire higher instruction priority than authorized developer intent. The malicious instruction appears in a database comment rather than an approved developer request.

Question 63

A retailer's analytical orders table holds hundreds of millions of immutable rows and monthly reports scan most columns while the original rowstore design causes excessive I/O. Which next step most directly resolves this SQL solution issue?

  1. Evaluate a columnstore index and validate load patterns and query performance before choosing the final storage design.
  2. Evaluate system-versioned temporal tables with history retention and appropriate access controls.
  3. Check native JSON indexing support or use a supported indexed computed-property strategy where appropriate.
  4. Use a SEQUENCE object and document its caching and gap behavior for consumers.

Explanation

Correct Answer

A:

Evaluate a columnstore index and validate load patterns and query performance before choosing the final storage design. Columnstore storage can improve scan-heavy analytics but its operational tradeoffs must be tested.

Incorrect Answers

B:

Evaluate system-versioned temporal tables with history retention and appropriate access controls. Columnstore storage can improve scan-heavy analytics but its operational tradeoffs must be tested. Evaluate a columnstore index and validate load patterns and query performance before choosing the final storage design.

C:

Check native JSON indexing support or use a supported indexed computed-property strategy where appropriate. Columnstore storage can improve scan-heavy analytics but its operational tradeoffs must be tested. Evaluate a columnstore index and validate load patterns and query performance before choosing the final storage design.

D:

Use a SEQUENCE object and document its caching and gap behavior for consumers. Columnstore storage can improve scan-heavy analytics but its operational tradeoffs must be tested. Evaluate a columnstore index and validate load patterns and query performance before choosing the final storage design.

Question 64

An application wants new FAQ entries to receive embeddings soon after insertion without embedding generation blocking the user-facing SQL transaction. How should the SQL engineering team confirm the issue is truly resolved?

  1. The model returns schema-valid fields with acceptable extraction accuracy and appropriate human review.
  2. The FAQ write commits promptly and a background worker creates a matching authorized vector.
  3. A held-out multilingual search set meets retrieval quality targets across required languages.
  4. Authorized calls work and no unapproved identity can use the integration to retrieve or generate protected content.

Explanation

Correct Answer

B:

The FAQ write commits promptly and a background worker creates a matching authorized vector.

Incorrect Answers

A:

The model returns schema-valid fields with acceptable extraction accuracy and appropriate human review. The FAQ write commits promptly and a background worker creates a matching authorized vector.

C:

A held-out multilingual search set meets retrieval quality targets across required languages. The FAQ write commits promptly and a background worker creates a matching authorized vector.

D:

Authorized calls work and no unapproved identity can use the integration to retrieve or generate protected content. The FAQ write commits promptly and a background worker creates a matching authorized vector.

Question 65

A financial database uses customer-managed keys but operators rotate the key without considering dependent clients or recovery. Choose TWO: one correct response and one verification of success.

  1. Apply service authentication, tool allowlists, scoped SQL permissions, and approval for state changes.
  2. Plan coordinated key rotation and recovery testing before replacing or retiring key material.
  3. The rotation completes without lost access and recovered data can still be decrypted by authorized services.
  4. Constrain query permissions and review inference risks rather than treating masking as sufficient protection.
  5. The negative test remains denied and generates a protected record adequate for investigation.

Explanation

Correct Answers

B:

Plan coordinated key rotation and recovery testing before replacing or retiring key material. This gives the verification result for the issue: A financial database uses customer-managed keys but operators rotate the key without considering dependent clients or recovery.

C:

The rotation completes without lost access and recovered data can still be decrypted by authorized services. This gives the verification result for the issue: A financial database uses customer-managed keys but operators rotate the key without considering dependent clients or recovery.

Incorrect Answers

A:

Apply service authentication, tool allowlists, scoped SQL permissions, and approval for state changes. This gives the verification result for the issue: A financial database uses customer-managed keys but operators rotate the key without considering dependent clients or recovery. Plan coordinated key rotation and recovery testing before replacing or retiring key material.

D:

Constrain query permissions and review inference risks rather than treating masking as sufficient protection. This gives the verification result for the issue: A financial database uses customer-managed keys but operators rotate the key without considering dependent clients or recovery. The rotation completes without lost access and recovered data can still be decrypted by authorized services.

E:

The negative test remains denied and generates a protected record adequate for investigation. This gives the verification result for the issue: A financial database uses customer-managed keys but operators rotate the key without considering dependent clients or recovery. The rotation completes without lost access and recovered data can still be decrypted by authorized services.

Question 66

A support role sees masked card numbers but can execute broad aggregate and comparison queries that might reveal protected details. Which outcome shows the requirement is met without introducing a new risk?

  1. Least-privilege queries return only approved aggregates without unintended reconstruction routes.
  2. The negative test remains denied and generates a protected record adequate for investigation.
  3. The endpoint returns permitted entities and rejects unauthorized resource and operation combinations.
  4. The web application runs normal queries while an attempted schema modification is denied.

Explanation

Correct Answer

A:

Least-privilege queries return only approved aggregates without unintended reconstruction routes.

Incorrect Answers

B:

The negative test remains denied and generates a protected record adequate for investigation. Least-privilege queries return only approved aggregates without unintended reconstruction routes.

C:

The endpoint returns permitted entities and rejects unauthorized resource and operation combinations. Least-privilege queries return only approved aggregates without unintended reconstruction routes.

D:

The web application runs normal queries while an attempted schema modification is denied. Least-privilege queries return only approved aggregates without unintended reconstruction routes.

Question 67

A billing service reports connection timeouts and the team labels every wait a deadlock without inspecting lock ownership. What would be a valid post-database-change verification?

  1. The new configuration reduces read blocking while reports avoid uncommitted data and temp/version costs are monitored.
  2. The chosen change lowers total reads without an unacceptable index maintenance penalty.
  3. The validated remedy shortens lock waits and separate deadlock monitoring remains stable.
  4. The analysis identifies specific statements and a tested change reduces peak resource use.

Explanation

Correct Answer

C:

The validated remedy shortens lock waits and separate deadlock monitoring remains stable. A billing service reports connection timeouts and the team labels every wait a deadlock without inspecting lock ownership.

Incorrect Answers

A:

The new configuration reduces read blocking while reports avoid uncommitted data and temp/version costs are monitored. A billing service reports connection timeouts and the team labels every wait a deadlock without inspecting lock ownership. The validated remedy shortens lock waits and separate deadlock monitoring remains stable.

B:

The chosen change lowers total reads without an unacceptable index maintenance penalty. A billing service reports connection timeouts and the team labels every wait a deadlock without inspecting lock ownership. The validated remedy shortens lock waits and separate deadlock monitoring remains stable.

D:

The analysis identifies specific statements and a tested change reduces peak resource use. A billing service reports connection timeouts and the team labels every wait a deadlock without inspecting lock ownership. The validated remedy shortens lock waits and separate deadlock monitoring remains stable.

Question 68

An API that calls Azure SQL has intermittent timeouts but the team monitors only average SQL CPU and cannot tie failures to individual requests. What distinction makes the recommended approach appropriate?

  1. API gateways do not automatically secure bypassable backend endpoints.
  2. Correlated telemetry can reveal failures that resource-average monitoring alone misses.
  3. Protecting data includes constraining searchable predicates as well as displayed columns.
  4. Change event streaming separates producer tables from subscriber access when correctly configured.

Explanation

Correct Answer

B:

Correlated telemetry can reveal failures that resource-average monitoring alone misses.

Incorrect Answers

A:

API gateways do not automatically secure bypassable backend endpoints. Correlated telemetry can reveal failures that resource-average monitoring alone misses.

C:

Protecting data includes constraining searchable predicates as well as displayed columns. Correlated telemetry can reveal failures that resource-average monitoring alone misses.

D:

Change event streaming separates producer tables from subscriber access when correctly configured. Correlated telemetry can reveal failures that resource-average monitoring alone misses.

Question 69

A payroll application stores compensation values in Azure SQL but database administrators should not see their plaintext through routine SQL queries. Which test result would demonstrate the fix worked?

  1. Least-privilege queries return only approved aggregates without unintended reconstruction routes.
  2. Authorized payroll clients read correct values while database operators cannot recover plaintext by ordinary SELECT.
  3. The negative test remains denied and generates a protected record adequate for investigation.
  4. Attempted destructive actions are blocked and permitted read tools function for authorized identities.

Explanation

Correct Answer

B:

Authorized payroll clients read correct values while database operators cannot recover plaintext by ordinary SELECT.

Incorrect Answers

A:

Least-privilege queries return only approved aggregates without unintended reconstruction routes. Authorized payroll clients read correct values while database operators cannot recover plaintext by ordinary SELECT.

C:

The negative test remains denied and generates a protected record adequate for investigation. Authorized payroll clients read correct values while database operators cannot recover plaintext by ordinary SELECT.

D:

Attempted destructive actions are blocked and permitted read tools function for authorized identities. Authorized payroll clients read correct values while database operators cannot recover plaintext by ordinary SELECT.

Question 70

A regulated organization's pipeline automatically deploys SQL schema changes to production immediately when a developer pushes to a feature branch. Which next step most directly resolves this SQL solution issue?

  1. Require appropriate protected branches, successful CI, environment approvals, and traceable release gates.
  2. Block promotion until data impact and an approved migration strategy are verified.
  3. Parameterize supported deployment settings and enforce environment-scoped identity and target confirmation.
  4. Rotate the exposed credential and move secrets to an approved secret store with restricted pipeline identity.

Explanation

Correct Answer

A:

Require appropriate protected branches, successful CI, environment approvals, and traceable release gates. Database CI/CD needs separation of development activity from production authorization.

Incorrect Answers

B:

Block promotion until data impact and an approved migration strategy are verified. Database CI/CD needs separation of development activity from production authorization. Require appropriate protected branches, successful CI, environment approvals, and traceable release gates.

C:

Parameterize supported deployment settings and enforce environment-scoped identity and target confirmation. Database CI/CD needs separation of development activity from production authorization. Require appropriate protected branches, successful CI, environment approvals, and traceable release gates.

D:

Rotate the exposed credential and move secrets to an approved secret store with restricted pipeline identity. Database CI/CD needs separation of development activity from production authorization. Require appropriate protected branches, successful CI, environment approvals, and traceable release gates.

Developing AI-Enabled Database Solutions (DP-800) Practice Tests