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

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.

Question 761

A CRM team compares names with common prefix and transcription variations and wants an explainable candidate ranking. Which next step most directly resolves this SQL solution issue?

  1. Evaluate REGEXP_REPLACE with a narrowly tested account-token pattern and independent sensitive-data detection.
  2. Extract the required JSON property and convert it to an appropriate numeric type with invalid-data handling.
  3. Benchmark JARO_WINKLER_DISTANCE or related supported measures against labeled name pairs.
  4. Use OPENJSON with an explicit schema to expand validated line items into relational rows.

Explanation

Correct Answer

C:

Benchmark JARO_WINKLER_DISTANCE or related supported measures against labeled name pairs. String similarity metrics have different sensitivities and must be matched to actual data.

Incorrect Answers

A:

Evaluate REGEXP_REPLACE with a narrowly tested account-token pattern and independent sensitive-data detection. String similarity metrics have different sensitivities and must be matched to actual data. Benchmark JARO_WINKLER_DISTANCE or related supported measures against labeled name pairs.

B:

Extract the required JSON property and convert it to an appropriate numeric type with invalid-data handling. String similarity metrics have different sensitivities and must be matched to actual data. Benchmark JARO_WINKLER_DISTANCE or related supported measures against labeled name pairs.

D:

Use OPENJSON with an explicit schema to expand validated line items into relational rows. String similarity metrics have different sensitivities and must be matched to actual data. Benchmark JARO_WINKLER_DISTANCE or related supported measures against labeled name pairs.

Question 762

A catalog stores JSON tags for products and users need to filter records containing a specified membership value without substring false positives. Which observation is the strongest evidence for the reported problem?

  1. Current substring slicing returns invalid tokens when the prefix appears in narrative words.
  2. Rows containing empty or whitespace-only tags cause incorrect references after import.
  3. The current scoring treats harmless name variations and unrelated records as equally likely duplicates.
  4. A text LIKE filter accidentally matches a partial tag inside an unrelated attribute.

Explanation

Correct Answer

D:

A text LIKE filter accidentally matches a partial tag inside an unrelated attribute. JSON membership semantics differ from arbitrary text matching and depend on feature support.

Incorrect Answers

A:

Current substring slicing returns invalid tokens when the prefix appears in narrative words. JSON membership semantics differ from arbitrary text matching and depend on feature support. A text LIKE filter accidentally matches a partial tag inside an unrelated attribute.

B:

Rows containing empty or whitespace-only tags cause incorrect references after import. JSON membership semantics differ from arbitrary text matching and depend on feature support. A text LIKE filter accidentally matches a partial tag inside an unrelated attribute.

C:

The current scoring treats harmless name variations and unrelated records as equally likely duplicates. JSON membership semantics differ from arbitrary text matching and depend on feature support. A text LIKE filter accidentally matches a partial tag inside an unrelated attribute.

Question 763

A finance assistant must answer questions about changing payment policy and the team proposes updating model weights whenever the policy changes. What should the database developer verify to confirm the suspected cause?

  1. The generated exception is absent from all retrieved approved policy records.
  2. After a policy update the model repeats the previous threshold because its context is stale.
  3. Orders with quotes or line breaks break the payload and some item boundaries disappear.
  4. Inspection shows the outbound JSON contains unrelated customer identifiers from the table.

Explanation

Correct Answer

B:

After a policy update the model repeats the previous threshold because its context is stale. RAG supplies current grounded evidence without encoding every business fact in model weights.

Incorrect Answers

A:

The generated exception is absent from all retrieved approved policy records. RAG supplies current grounded evidence without encoding every business fact in model weights. After a policy update the model repeats the previous threshold because its context is stale.

C:

Orders with quotes or line breaks break the payload and some item boundaries disappear. RAG supplies current grounded evidence without encoding every business fact in model weights. After a policy update the model repeats the previous threshold because its context is stale.

D:

Inspection shows the outbound JSON contains unrelated customer identifiers from the table. RAG supplies current grounded evidence without encoding every business fact in model weights. After a policy update the model repeats the previous threshold because its context is stale.

Question 764

A subscription report needs the difference between current and prior month revenue per product without a complex self-join. Which concept should guide the database developer in this situation?

  1. Regular expressions are useful for pattern-based text operations but require careful definitions and performance tests.
  2. Window offset functions simplify ordered comparisons but do not create missing time periods.
  3. JSON membership semantics differ from arbitrary text matching and depend on feature support.
  4. Regex substitution supports structured redaction only when patterns are thoroughly validated.

Explanation

Correct Answer

B:

Window offset functions simplify ordered comparisons but do not create missing time periods.

Incorrect Answers

A:

Regular expressions are useful for pattern-based text operations but require careful definitions and performance tests. Window offset functions simplify ordered comparisons but do not create missing time periods.

C:

JSON membership semantics differ from arbitrary text matching and depend on feature support. Window offset functions simplify ordered comparisons but do not create missing time periods.

D:

Regex substitution supports structured redaction only when patterns are thoroughly validated. Window offset functions simplify ordered comparisons but do not create missing time periods.

Question 765

A regulated benefits application calls a model through SQL but stores only the final generated sentence, leaving no way to reconstruct cited source versions or model configuration. What is the underlying reason for the corrective step?

  1. External model responses are untrusted service results and need robust parsing and error handling.
  2. Grounded answers require verifiable provenance, not merely retrieval in the background.
  3. RAG context assembly trades completeness, relevance, cost, and model window constraints.
  4. Auditability of RAG responses depends on controlled provenance and review records across components.

Explanation

Correct Answer

D:

Auditability of RAG responses depends on controlled provenance and review records across components.

Incorrect Answers

A:

External model responses are untrusted service results and need robust parsing and error handling. Auditability of RAG responses depends on controlled provenance and review records across components.

B:

Grounded answers require verifiable provenance, not merely retrieval in the background. Auditability of RAG responses depends on controlled provenance and review records across components.

C:

RAG context assembly trades completeness, relevance, cost, and model window constraints. Auditability of RAG responses depends on controlled provenance and review records across components.

Question 766

A database team knows only that an Azure SQL service is slower after peak traffic but does not know which query consumes resources. Which TWO options together specify a corrective step and a meaningful test?

  1. The analysis identifies specific statements and a tested change reduces peak resource use.
  2. Measure actual fragmentation, page density, workload plans, and maintenance impact before a rebuild policy.
  3. Use an atomic update or optimistic concurrency check to prevent lost updates.
  4. The validated remedy shortens lock waits and separate deadlock monitoring remains stable.
  5. Use available query performance insights, Query Store, and relevant DMVs to identify the top regressed statements.

Explanation

Correct Answers

A:

The analysis identifies specific statements and a tested change reduces peak resource use. A database team knows only that an Azure SQL service is slower after peak traffic but does not know which query consumes resources. Use available query performance insights, Query Store, and relevant DMVs to identify the top regressed statements.

E:

Use available query performance insights, Query Store, and relevant DMVs to identify the top regressed statements. A database team knows only that an Azure SQL service is slower after peak traffic but does not know which query consumes resources.

Incorrect Answers

B:

Measure actual fragmentation, page density, workload plans, and maintenance impact before a rebuild policy. A database team knows only that an Azure SQL service is slower after peak traffic but does not know which query consumes resources. The analysis identifies specific statements and a tested change reduces peak resource use.

C:

Use an atomic update or optimistic concurrency check to prevent lost updates. A database team knows only that an Azure SQL service is slower after peak traffic but does not know which query consumes resources. Use available query performance insights, Query Store, and relevant DMVs to identify the top regressed statements.

D:

The validated remedy shortens lock waits and separate deadlock monitoring remains stable. A database team knows only that an Azure SQL service is slower after peak traffic but does not know which query consumes resources. The analysis identifies specific statements and a tested change reduces peak resource use.

Question 767

A shipment search API permits filtering on private customer fields that are not part of its documented public data contract. Which test result would demonstrate the fix worked?

  1. The published API exposes only the expected shipment fields and rejects forbidden routes.
  2. The feed reproduces intended changes in order and survives a consumer restart.
  3. Allowed requests invoke the intended procedure and crafted SQL payloads are rejected.
  4. The endpoint rejects unapproved filters and returns correct authorized shipment matches.

Explanation

Correct Answer

D:

The endpoint rejects unapproved filters and returns correct authorized shipment matches.

Incorrect Answers

A:

The published API exposes only the expected shipment fields and rejects forbidden routes. The endpoint rejects unapproved filters and returns correct authorized shipment matches.

B:

The feed reproduces intended changes in order and survives a consumer restart. The endpoint rejects unapproved filters and returns correct authorized shipment matches.

C:

Allowed requests invoke the intended procedure and crafted SQL payloads are rejected. The endpoint rejects unapproved filters and returns correct authorized shipment matches.

Question 768

A policy assistant cannot find an approved exception clause but generates a confident one from similarly worded historic notes. Choose TWO: one correct response and one verification of success.

  1. Convert the approved structured rows to valid JSON with supported SQL JSON construction functions.
  2. Test queries without evidence return a clearly marked gap and a human review route.
  3. Require an explicit evidence threshold and safe refusal or escalation when retrieval finds no current supporting clause.
  4. The request sends only approved fields and the model receives sufficient task context.
  5. Use sp_invoke_external_rest_endpoint only with an approved network and identity configuration and a minimal validated prompt payload.

Explanation

Correct Answers

B:

Test queries without evidence return a clearly marked gap and a human review route. This gives the verification result for the issue: A policy assistant cannot find an approved exception clause but generates a confident one from similarly worded historic notes.

C:

Require an explicit evidence threshold and safe refusal or escalation when retrieval finds no current supporting clause. This gives the verification result for the issue: A policy assistant cannot find an approved exception clause but generates a confident one from similarly worded historic notes.

Incorrect Answers

A:

Convert the approved structured rows to valid JSON with supported SQL JSON construction functions. This gives the verification result for the issue: A policy assistant cannot find an approved exception clause but generates a confident one from similarly worded historic notes. Require an explicit evidence threshold and safe refusal or escalation when retrieval finds no current supporting clause.

D:

The request sends only approved fields and the model receives sufficient task context. This gives the verification result for the issue: A policy assistant cannot find an approved exception clause but generates a confident one from similarly worded historic notes. Require an explicit evidence threshold and safe refusal or escalation when retrieval finds no current supporting clause.

E:

Use sp_invoke_external_rest_endpoint only with an approved network and identity configuration and a minimal validated prompt payload. This gives the verification result for the issue: A policy assistant cannot find an approved exception clause but generates a confident one from similarly worded historic notes. Test queries without evidence return a clearly marked gap and a human review route.

Question 769

An engineering help-desk needs exact error-code matching plus conceptually relevant troubleshooting articles and neither keyword nor vectors alone performs well. What is the MOST appropriate initial remediation?

  1. Apply an appropriate normalization strategy such as VECTOR_NORMALIZE and verify the chosen similarity metric.
  2. Combine lexical and vector retrieval under controlled filters and evaluate hybrid result quality.
  3. Align index metric, query scoring, and model expectations; validate on labeled relevant pairs.
  4. Evaluate supported VECTOR_SEARCH and suitable vector indexes with quality and latency benchmarking.

Explanation

Correct Answer

B:

Combine lexical and vector retrieval under controlled filters and evaluate hybrid result quality. Hybrid search can combine complementary lexical precision and semantic recall.

Incorrect Answers

A:

Apply an appropriate normalization strategy such as VECTOR_NORMALIZE and verify the chosen similarity metric. Hybrid search can combine complementary lexical precision and semantic recall. Combine lexical and vector retrieval under controlled filters and evaluate hybrid result quality.

C:

Align index metric, query scoring, and model expectations; validate on labeled relevant pairs. Hybrid search can combine complementary lexical precision and semantic recall. Combine lexical and vector retrieval under controlled filters and evaluate hybrid result quality.

D:

Evaluate supported VECTOR_SEARCH and suitable vector indexes with quality and latency benchmarking. Hybrid search can combine complementary lexical precision and semantic recall. Combine lexical and vector retrieval under controlled filters and evaluate hybrid result quality.

Question 770

A logistics service wants a read-only REST endpoint for approved shipment status but an API prototype exposes every warehouse table by default. What should the database developer do FIRST within approved procedures?

  1. Version the DAB configuration and use environment-specific secret injection and validation during deployment.
  2. Require and test appropriate service-level authentication and network restrictions at every reachable endpoint.
  3. Design appropriate cache freshness and invalidation semantics for the business price lifecycle.
  4. Define a narrowly scoped DAB configuration with explicit entities, operations, and role-based permissions.

Explanation

Correct Answer

D:

Define a narrowly scoped DAB configuration with explicit entities, operations, and role-based permissions. Data API builder configuration determines service surface and must follow least-privilege exposure.

Incorrect Answers

A:

Version the DAB configuration and use environment-specific secret injection and validation during deployment. Data API builder configuration determines service surface and must follow least-privilege exposure. Define a narrowly scoped DAB configuration with explicit entities, operations, and role-based permissions.

B:

Require and test appropriate service-level authentication and network restrictions at every reachable endpoint. Data API builder configuration determines service surface and must follow least-privilege exposure. Define a narrowly scoped DAB configuration with explicit entities, operations, and role-based permissions.

C:

Design appropriate cache freshness and invalidation semantics for the business price lifecycle. Data API builder configuration determines service surface and must follow least-privilege exposure. Define a narrowly scoped DAB configuration with explicit entities, operations, and role-based permissions.

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