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

Question 750

A device catalog adds hundreds of mostly empty optional fields as standard columns and read performance is deteriorating. Which TWO options together specify a corrective step and a meaningful test?

  1. The revised schema supports required searches while reducing unnecessary storage and migration burden.
  2. Checkout transaction latency remains stable while reporting queries use purpose-built structures.
  3. Design JSON access and indexing according to the engine's supported JSON features and test the predicate.
  4. Evaluate normalized, JSON, or sparse-column designs against actual query needs and engine support.
  5. Add supported CHECK and DEFAULT constraints consistent with the application contract.

Explanation

Correct Answers

A:

The revised schema supports required searches while reducing unnecessary storage and migration burden. Evaluate normalized, JSON, or sparse-column designs against actual query needs and engine support.

D:

Evaluate normalized, JSON, or sparse-column designs against actual query needs and engine support.

Incorrect Answers

B:

Checkout transaction latency remains stable while reporting queries use purpose-built structures. Evaluate normalized, JSON, or sparse-column designs against actual query needs and engine support. The revised schema supports required searches while reducing unnecessary storage and migration burden.

C:

Design JSON access and indexing according to the engine's supported JSON features and test the predicate. Evaluate normalized, JSON, or sparse-column designs against actual query needs and engine support.

E:

Add supported CHECK and DEFAULT constraints consistent with the application contract. Evaluate normalized, JSON, or sparse-column designs against actual query needs and engine support. The revised schema supports required searches while reducing unnecessary storage and migration burden.

Question 751

An AI-enabled SQL workflow calls a model service with an API key stored in a database object accessible to developers. Choose TWO statements: a suitable intervention and evidence of its success.

  1. Add appropriate query/activity monitoring and tested audit correlation without logging unnecessary sensitive payloads.
  2. Choose an approved managed identity access route for the model endpoint where supported and restrict configuration readers.
  3. Authorized model calls succeed with least privilege and no plaintext key is exposed to unrelated readers.
  4. Compromised low-privilege identities cannot read unrelated protected data in a controlled test.
  5. Enforce authorized tenant scoping through backend policies and service identity rather than trust the caller's filter.

Explanation

Correct Answers

B:

Choose an approved managed identity access route for the model endpoint where supported and restrict configuration readers.

C:

Authorized model calls succeed with least privilege and no plaintext key is exposed to unrelated readers. Choose an approved managed identity access route for the model endpoint where supported and restrict configuration readers.

Incorrect Answers

A:

Add appropriate query/activity monitoring and tested audit correlation without logging unnecessary sensitive payloads. Choose an approved managed identity access route for the model endpoint where supported and restrict configuration readers. Authorized model calls succeed with least privilege and no plaintext key is exposed to unrelated readers.

D:

Compromised low-privilege identities cannot read unrelated protected data in a controlled test. Choose an approved managed identity access route for the model endpoint where supported and restrict configuration readers. Authorized model calls succeed with least privilege and no plaintext key is exposed to unrelated readers.

E:

Enforce authorized tenant scoping through backend policies and service identity rather than trust the caller's filter. Choose an approved managed identity access route for the model endpoint where supported and restrict configuration readers.

Question 752

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. How should the SQL engineering team confirm the issue is truly resolved?

  1. Approved sessions use an allowed endpoint and unapproved configurations are blocked or corrected.
  2. The assistant ignores the embedded command and logs no attempt to access the secret table.
  3. Tests confirm exact expected totals for refunds, null values, and normal billing records.
  4. New suggestions follow the documented conventions and still pass independent pull-request review.

Explanation

Correct Answer

B:

The assistant ignores the embedded command and logs no attempt to access the secret table. The operating rule is: Untrusted tool output must not acquire higher instruction priority than authorized developer intent.

Incorrect Answers

A:

Approved sessions use an allowed endpoint and unapproved configurations are blocked or corrected. The operating rule is: Untrusted tool output must not acquire higher instruction priority than authorized developer intent. The assistant ignores the embedded command and logs no attempt to access the secret table.

C:

Tests confirm exact expected totals for refunds, null values, and normal billing records. The operating rule is: Untrusted tool output must not acquire higher instruction priority than authorized developer intent. The assistant ignores the embedded command and logs no attempt to access the secret table.

D:

New suggestions follow the documented conventions and still pass independent pull-request review. The operating rule is: Untrusted tool output must not acquire higher instruction priority than authorized developer intent. The assistant ignores the embedded command and logs no attempt to access the secret table.

Question 753

A security team wants to confirm that cross-tenant access attempts are detected, not only blocked by its new row-level security predicate. What should the database developer do FIRST within approved procedures?

  1. Configure appropriate SQL auditing to a protected destination with tested retention and access reviews.
  2. Plan coordinated key rotation and recovery testing before replacing or retiring key material.
  3. Choose an approved managed identity access route for the model endpoint where supported and restrict configuration readers.
  4. Add appropriate query/activity monitoring and tested audit correlation without logging unnecessary sensitive payloads.

Explanation

Correct Answer

D:

Add appropriate query/activity monitoring and tested audit correlation without logging unnecessary sensitive payloads. Access prevention and accountable security monitoring are complementary controls.

Incorrect Answers

A:

Configure appropriate SQL auditing to a protected destination with tested retention and access reviews. Access prevention and accountable security monitoring are complementary controls. Add appropriate query/activity monitoring and tested audit correlation without logging unnecessary sensitive payloads.

B:

Plan coordinated key rotation and recovery testing before replacing or retiring key material. Access prevention and accountable security monitoring are complementary controls. Add appropriate query/activity monitoring and tested audit correlation without logging unnecessary sensitive payloads.

C:

Choose an approved managed identity access route for the model endpoint where supported and restrict configuration readers. Access prevention and accountable security monitoring are complementary controls. Add appropriate query/activity monitoring and tested audit correlation without logging unnecessary sensitive payloads.

Question 754

A GraphQL response is slow for deeply nested selections and the team considers adding larger SQL capacity without identifying the expensive path. Select TWO: the best action and the outcome that confirms it worked.

  1. Use a suitable Logic Apps or event-triggered integration with narrow filters and approved recipients.
  2. Capture API query shapes and SQL dependency telemetry before scaling hardware.
  3. Configure the supported DAB GraphQL relationship mapping and test nested authorization across entities.
  4. A bounded query or optimized mapping meets latency targets under representative load.
  5. An API test enforces page size and returns deterministic next pages without missing or duplicating items.

Explanation

Correct Answers

B:

Capture API query shapes and SQL dependency telemetry before scaling hardware. A GraphQL response is slow for deeply nested selections and the team considers adding larger SQL capacity without identifying the expensive path.

D:

A bounded query or optimized mapping meets latency targets under representative load. A GraphQL response is slow for deeply nested selections and the team considers adding larger SQL capacity without identifying the expensive path. Capture API query shapes and SQL dependency telemetry before scaling hardware.

Incorrect Answers

A:

Use a suitable Logic Apps or event-triggered integration with narrow filters and approved recipients. A GraphQL response is slow for deeply nested selections and the team considers adding larger SQL capacity without identifying the expensive path. Capture API query shapes and SQL dependency telemetry before scaling hardware.

C:

Configure the supported DAB GraphQL relationship mapping and test nested authorization across entities. A GraphQL response is slow for deeply nested selections and the team considers adding larger SQL capacity without identifying the expensive path. Capture API query shapes and SQL dependency telemetry before scaling hardware.

E:

An API test enforces page size and returns deterministic next pages without missing or duplicating items. A GraphQL response is slow for deeply nested selections and the team considers adding larger SQL capacity without identifying the expensive path. Capture API query shapes and SQL dependency telemetry before scaling hardware.

Question 755

A pricing service caches DAB responses but customers continue receiving superseded prices after a time-sensitive promotion update. What technical finding would substantiate this root cause?

  1. A test can call the DAB backend URL directly without the gateway's identity checks.
  2. SQL shows the approved new price while the API still returns the old cached payload.
  3. The existing solution grants multiple consumers direct read access to core transactional tables.
  4. Users report timeouts while infrastructure charts show normal CPU and no request trace.

Explanation

Correct Answer

B:

SQL shows the approved new price while the API still returns the old cached payload. Caching must respect correctness and freshness requirements for mutable business records.

Incorrect Answers

A:

A test can call the DAB backend URL directly without the gateway's identity checks. Caching must respect correctness and freshness requirements for mutable business records. SQL shows the approved new price while the API still returns the old cached payload.

C:

The existing solution grants multiple consumers direct read access to core transactional tables. Caching must respect correctness and freshness requirements for mutable business records. SQL shows the approved new price while the API still returns the old cached payload.

D:

Users report timeouts while infrastructure charts show normal CPU and no request trace. Caching must respect correctness and freshness requirements for mutable business records. SQL shows the approved new price while the API still returns the old cached payload.

Question 756

Readers wait behind frequent updates in an order system and staff propose dirty reads as a quick fix for business dashboards. Which concept should guide the database developer in this situation?

  1. Versioned reads can improve concurrency without exposing dirty values when correctly configured.
  2. Business data consistency requires protecting read-modify-write sequences.
  3. Query Store provides historical query-plan evidence and supports evidence-based regression diagnosis.
  4. Index maintenance should be justified by observed behavior and storage characteristics.

Explanation

Correct Answer

A:

Versioned reads can improve concurrency without exposing dirty values when correctly configured.

Incorrect Answers

B:

Business data consistency requires protecting read-modify-write sequences. Versioned reads can improve concurrency without exposing dirty values when correctly configured.

C:

Query Store provides historical query-plan evidence and supports evidence-based regression diagnosis. Versioned reads can improve concurrency without exposing dirty values when correctly configured.

D:

Index maintenance should be justified by observed behavior and storage characteristics. Versioned reads can improve concurrency without exposing dirty values when correctly configured.

Question 757

An application wants new FAQ entries to receive embeddings soon after insertion without embedding generation blocking the user-facing SQL transaction. Choose TWO statements: a suitable intervention and evidence of its success.

  1. A changed row's embedding is refreshed within the accepted time window and old results no longer dominate.
  2. Evaluate a CDC-based incremental vector update process with checkpoints and delete propagation.
  3. Move inference to an appropriate asynchronous change processing flow or tightly bound the operation after evaluating failure risk.
  4. The FAQ write commits promptly and a background worker creates a matching authorized vector.
  5. Use an event-driven Azure Function SQL trigger pattern with durable retries and source version checks.

Explanation

Correct Answers

D:

The FAQ write commits promptly and a background worker creates a matching authorized vector. An application wants new FAQ entries to receive embeddings soon after insertion without embedding generation blocking the user-facing SQL transaction.

E:

Use an event-driven Azure Function SQL trigger pattern with durable retries and source version checks. An application wants new FAQ entries to receive embeddings soon after insertion without embedding generation blocking the user-facing SQL transaction.

Incorrect Answers

A:

A changed row's embedding is refreshed within the accepted time window and old results no longer dominate. An application wants new FAQ entries to receive embeddings soon after insertion without embedding generation blocking the user-facing SQL transaction. The FAQ write commits promptly and a background worker creates a matching authorized vector.

B:

Evaluate a CDC-based incremental vector update process with checkpoints and delete propagation. An application wants new FAQ entries to receive embeddings soon after insertion without embedding generation blocking the user-facing SQL transaction. Use an event-driven Azure Function SQL trigger pattern with durable retries and source version checks.

C:

Move inference to an appropriate asynchronous change processing flow or tightly bound the operation after evaluating failure risk. An application wants new FAQ entries to receive embeddings soon after insertion without embedding generation blocking the user-facing SQL transaction. The FAQ write commits promptly and a background worker creates a matching authorized vector.

Question 758

An SQL-based RAG procedure sends hundreds of long retrieved chunks to a model and becomes expensive while often omitting the most relevant clauses due to context limits. Which TWO options together specify a corrective step and a meaningful test?

  1. Every material policy claim cites a current accessible source or is marked unsupported.
  2. Record authorized prompt/source version metadata, model identity, and approval outcome with appropriate privacy retention.
  3. Include controlled document identifiers, version metadata, and explicit citation requirements in the RAG prompt.
  4. The workflow meets token and latency budgets while citing the correct current clauses.
  5. Bound and rerank retrieved context, preserve meaningful chunk metadata, and benchmark answer coverage.

Explanation

Correct Answers

D:

The workflow meets token and latency budgets while citing the correct current clauses. An SQL-based RAG procedure sends hundreds of long retrieved chunks to a model and becomes expensive while often omitting the most relevant clauses due to context limits.

E:

Bound and rerank retrieved context, preserve meaningful chunk metadata, and benchmark answer coverage. An SQL-based RAG procedure sends hundreds of long retrieved chunks to a model and becomes expensive while often omitting the most relevant clauses due to context limits.

Incorrect Answers

A:

Every material policy claim cites a current accessible source or is marked unsupported. An SQL-based RAG procedure sends hundreds of long retrieved chunks to a model and becomes expensive while often omitting the most relevant clauses due to context limits. The workflow meets token and latency budgets while citing the correct current clauses.

B:

Record authorized prompt/source version metadata, model identity, and approval outcome with appropriate privacy retention. An SQL-based RAG procedure sends hundreds of long retrieved chunks to a model and becomes expensive while often omitting the most relevant clauses due to context limits. The workflow meets token and latency budgets while citing the correct current clauses.

C:

Include controlled document identifiers, version metadata, and explicit citation requirements in the RAG prompt. An SQL-based RAG procedure sends hundreds of long retrieved chunks to a model and becomes expensive while often omitting the most relevant clauses due to context limits. The workflow meets token and latency budgets while citing the correct current clauses.

Question 759

An engineering help-desk needs exact error-code matching plus conceptually relevant troubleshooting articles and neither keyword nor vectors alone performs well. How should the SQL engineering team confirm the issue is truly resolved?

  1. The combined ranking balances relevant candidates from both lists according to measured relevance.
  2. A combined benchmark retrieves both precise code matches and relevant related explanations.
  3. A pre-insert check identifies incompatible vectors and routes them to repair before indexing.
  4. A tested query returns the expected nearest vector rows with reproducible distance values.

Explanation

Correct Answer

B:

A combined benchmark retrieves both precise code matches and relevant related explanations.

Incorrect Answers

A:

The combined ranking balances relevant candidates from both lists according to measured relevance. A combined benchmark retrieves both precise code matches and relevant related explanations.

C:

A pre-insert check identifies incompatible vectors and routes them to repair before indexing. A combined benchmark retrieves both precise code matches and relevant related explanations.

D:

A tested query returns the expected nearest vector rows with reproducible distance values. A combined benchmark retrieves both precise code matches and relevant related explanations.

Question 760

A customer analytics query calls an expensive scalar UDF for every row and slows dramatically during monthly aggregation. Select TWO: the best action and the outcome that confirms it worked.

  1. Assess supported scalar UDF inlining or rewrite the computation into a set-based expression.
  2. Either the complete authorized order is committed or the entire unit of work is rolled back.
  3. Make reference-data seeding idempotent using stable keys and transactional checks.
  4. A revised query returns identical outputs with materially less CPU under production-like data.
  5. Create an appropriately permissioned view that projects only authorized aggregated fields.

Explanation

Correct Answers

A:

Assess supported scalar UDF inlining or rewrite the computation into a set-based expression. A revised query returns identical outputs with materially less CPU under production-like data.

D:

A revised query returns identical outputs with materially less CPU under production-like data. The corresponding check is whether assess supported scalar UDF inlining or rewrite the computation into a set-based expression.

Incorrect Answers

B:

Either the complete authorized order is committed or the entire unit of work is rolled back. A revised query returns identical outputs with materially less CPU under production-like data. The corresponding check is whether assess supported scalar UDF inlining or rewrite the computation into a set-based expression.

C:

Make reference-data seeding idempotent using stable keys and transactional checks. A revised query returns identical outputs with materially less CPU under production-like data.

E:

Create an appropriately permissioned view that projects only authorized aggregated fields. A revised query returns identical outputs with materially less CPU under production-like data. Assess supported scalar UDF inlining or rewrite the computation into a set-based expression.

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