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 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.
Explanation
Correct Answers
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.
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
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.
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.
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?
Explanation
Correct Answer
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
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.
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.
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?
Explanation
Correct Answer
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
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.
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.
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?
Explanation
Correct Answer
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
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.
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.
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?
Explanation
Correct Answer
Window offset functions simplify ordered comparisons but do not create missing time periods.
Incorrect Answers
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.
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.
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?
Explanation
Correct Answer
Auditability of RAG responses depends on controlled provenance and review records across components.
Incorrect Answers
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.
Grounded answers require verifiable provenance, not merely retrieval in the background. Auditability of RAG responses depends on controlled provenance and review records across components.
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?
Explanation
Correct Answers
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.
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
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.
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.
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?
Explanation
Correct Answer
The endpoint rejects unapproved filters and returns correct authorized shipment matches.
Incorrect Answers
The published API exposes only the expected shipment fields and rejects forbidden routes. The endpoint rejects unapproved filters and returns correct authorized shipment matches.
The feed reproduces intended changes in order and survives a consumer restart. The endpoint rejects unapproved filters and returns correct authorized shipment matches.
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.
Explanation
Correct Answers
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.
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
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.
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.
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?
Explanation
Correct Answer
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
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.
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.
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?
Explanation
Correct Answer
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
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.
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.
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
- Microsoft DP-800 Practice Test 75 - 10 Questions (Last Reviewed 30-Oct-2026)
- Microsoft DP-800 Practice Test 76 - 10 Questions (Last Reviewed 29-Oct-2026)
- Microsoft DP-800 Practice Test 77 - 10 Questions (Last Reviewed 28-Oct-2026)
- Microsoft DP-800 Practice Test 78 - 10 Questions (Last Reviewed 27-Oct-2026)
- Microsoft DP-800 Practice Test 79 - 10 Questions (Last Reviewed 26-Oct-2026)