Microsoft DP-800 Practice Test 79
Question 780
Brookfield Labs is responsible for an Azure SQL or Microsoft SQL workload. A model request fails because too many SQL rows are concatenated. Operational evidence: Prompt exceeds deployment context/token budget. What operational condition would provide the earliest useful regression warning?
- Monitor hallucination and missing citations
- Monitor context overflows and truncated citations
- Monitor schema changes and parsing failures
- Monitor stale citations and source deletion
Explanation
Correct Answer
B:
Prompt exceeds deployment context/token budget. Monitor context overflows and truncated citations.
Incorrect Answers
A:
“Monitor hallucination and missing citations” concerns Model alone invents rules not in corporate source; the reported problem instead is Prompt exceeds deployment context/token budget. Monitor context overflows and truncated citations.
C:
“Monitor schema changes and parsing failures” concerns SQL code treats whole response envelope as plain answer; the reported problem instead is Prompt exceeds deployment context/token budget. Monitor context overflows and truncated citations.
D:
“Monitor stale citations and source deletion” concerns Assistant answers without linking supporting source rows; the reported problem instead is Prompt exceeds deployment context/token budget. Monitor context overflows and truncated citations.
Question 781
At Cascade Manufacturing, external REST response returns nested JSON with answer and usage metadata. The observed constraint is: SQL code treats whole response envelope as plain answer. What initial check best narrows the technical cause without altering business data?
- Inspect retrieval provenance and role separation
- Inspect retrieval relevance threshold and abstention criteria
- Inspect data classification and outbound prompt payload
- Inspect response structure and error branches
Explanation
Correct Answer
D:
SQL code treats whole response envelope as plain answer. Inspect response structure and error branches.
Incorrect Answers
A:
“Inspect retrieval provenance and role separation” concerns Untrusted document text could influence agent behavior; the reported problem instead is SQL code treats whole response envelope as plain answer. Inspect response structure and error branches.
B:
“Inspect retrieval relevance threshold and abstention criteria” concerns Model invents an answer despite no relevant retrieved evidence; the reported problem instead is SQL code treats whole response envelope as plain answer. Inspect response structure and error branches.
C:
“Inspect data classification and outbound prompt payload” concerns Unneeded PII would be sent to external language model; the reported problem instead is SQL code treats whole response envelope as plain answer. Inspect response structure and error branches.
Question 782
A database engineer at Clearwater Utilities is investigating this case: External REST response returns nested JSON with answer and usage metadata. The relevant finding is: SQL code treats whole response envelope as plain answer. Which proposed change is the most suitable response to the observed constraint?
- Use supported SQL JSON generation for structured prompt payload
- Implement grounded-response gate that declines unsupported requests
- Project only permitted fields and redact sensitive columns before model call
- Parse returned JSON response fields with validated paths
Explanation
Correct Answer
D:
SQL code treats whole response envelope as plain answer. Parse returned JSON response fields with validated paths.
Incorrect Answers
A:
“Use supported SQL JSON generation for structured prompt payload” concerns String concatenation produces malformed JSON when text contains quotes; the reported problem instead is SQL code treats whole response envelope as plain answer. Parse returned JSON response fields with validated paths.
B:
“Implement grounded-response gate that declines unsupported requests” concerns Model invents an answer despite no relevant retrieved evidence; the reported problem instead is SQL code treats whole response envelope as plain answer. Parse returned JSON response fields with validated paths.
C:
“Project only permitted fields and redact sensitive columns before model call” concerns Unneeded PII would be sent to external language model; the reported problem instead is SQL code treats whole response envelope as plain answer. Parse returned JSON response fields with validated paths.
Question 783
Cedarbridge Health is responsible for an Azure SQL or Microsoft SQL workload. External REST response returns nested JSON with answer and usage metadata. Operational evidence: SQL code treats whole response envelope as plain answer. What isolated pilot would provide the strongest evidence before rollout?
- Use synthetic success and error endpoint responses
- Build prompt from masked synthetic customer records
- Ask a fictional question with zero matching snippets
- Query a large synthetic corpus and form limited prompt
Explanation
Correct Answer
A:
SQL code treats whole response envelope as plain answer. Use synthetic success and error endpoint responses.
Incorrect Answers
B:
“Build prompt from masked synthetic customer records” concerns Unneeded PII would be sent to external language model; the reported problem instead is SQL code treats whole response envelope as plain answer. Use synthetic success and error endpoint responses.
C:
“Ask a fictional question with zero matching snippets” concerns Model invents an answer despite no relevant retrieved evidence; the reported problem instead is SQL code treats whole response envelope as plain answer. Use synthetic success and error endpoint responses.
D:
“Query a large synthetic corpus and form limited prompt” concerns Prompt exceeds deployment context/token budget; the reported problem instead is SQL code treats whole response envelope as plain answer. Use synthetic success and error endpoint responses.
Question 784
At Ashwood Solutions, external REST response returns nested JSON with answer and usage metadata. The observed constraint is: SQL code treats whole response envelope as plain answer. Which acceptance result most directly demonstrates the requirement has been satisfied?
- Answer points to current referenced source and flags conflict
- Grounded answer cites appropriate source instead of unsupported claims
- Payload parses correctly and contains only allowed fields
- Answer text is extracted correctly or errors reported safely
Explanation
Correct Answer
D:
SQL code treats whole response envelope as plain answer. Answer text is extracted correctly or errors reported safely.
Incorrect Answers
A:
“Answer points to current referenced source and flags conflict” concerns Assistant answers without linking supporting source rows; the reported problem instead is SQL code treats whole response envelope as plain answer. Answer text is extracted correctly or errors reported safely.
B:
“Grounded answer cites appropriate source instead of unsupported claims” concerns Model alone invents rules not in corporate source; the reported problem instead is SQL code treats whole response envelope as plain answer. Answer text is extracted correctly or errors reported safely.
C:
“Payload parses correctly and contains only allowed fields” concerns String concatenation produces malformed JSON when text contains quotes; the reported problem instead is SQL code treats whole response envelope as plain answer. Answer text is extracted correctly or errors reported safely.
Question 785
A database engineer at Seabrook University is investigating this case: External REST response returns nested JSON with answer and usage metadata. The relevant finding is: SQL code treats whole response envelope as plain answer. What operational condition would provide the earliest useful regression warning?
- Monitor outbound endpoint audit events
- Monitor unsupported-answer rate and recall gaps
- Monitor hallucination and missing citations
- Monitor schema changes and parsing failures
Explanation
Correct Answer
D:
SQL code treats whole response envelope as plain answer. Monitor schema changes and parsing failures.
Incorrect Answers
A:
“Monitor outbound endpoint audit events” concerns Any SQL login could exfiltrate data if broad EXEC rights are granted; the reported problem instead is SQL code treats whole response envelope as plain answer. Monitor schema changes and parsing failures.
B:
“Monitor unsupported-answer rate and recall gaps” concerns Model invents an answer despite no relevant retrieved evidence; the reported problem instead is SQL code treats whole response envelope as plain answer. Monitor schema changes and parsing failures.
C:
“Monitor hallucination and missing citations” concerns Model alone invents rules not in corporate source; the reported problem instead is SQL code treats whole response envelope as plain answer. Monitor schema changes and parsing failures.
Question 786
Atlas Publishing is responsible for an Azure SQL or Microsoft SQL workload. A user asks a question absent from available policies. Operational evidence: Model invents an answer despite no relevant retrieved evidence. What initial check best narrows the technical cause without altering business data?
- Inspect retrieval provenance and role separation
- Inspect retrieval relevance threshold and abstention criteria
- Inspect retrieval count, chunk sizes and endpoint token limits
- Inspect groundedness requirement and available authorized documents
Explanation
Correct Answer
B:
Model invents an answer despite no relevant retrieved evidence. Inspect retrieval relevance threshold and abstention criteria.
Incorrect Answers
A:
“Inspect retrieval provenance and role separation” concerns Untrusted document text could influence agent behavior; the reported problem instead is Model invents an answer despite no relevant retrieved evidence. Inspect retrieval relevance threshold and abstention criteria.
C:
“Inspect retrieval count, chunk sizes and endpoint token limits” concerns Prompt exceeds deployment context/token budget; the reported problem instead is Model invents an answer despite no relevant retrieved evidence. Inspect retrieval relevance threshold and abstention criteria.
D:
“Inspect groundedness requirement and available authorized documents” concerns Model alone invents rules not in corporate source; the reported problem instead is Model invents an answer despite no relevant retrieved evidence. Inspect retrieval relevance threshold and abstention criteria.
Question 787
At Mountainview Realty, a user asks a question absent from available policies. The observed constraint is: Model invents an answer despite no relevant retrieved evidence. Which proposed change is the most suitable response to the observed constraint?
- Parse returned JSON response fields with validated paths
- Project only permitted fields and redact sensitive columns prior to model call
- Use RAG to retrieve relevant policy passages as context for generation
- Implement grounded-response gate that declines unsupported requests
Explanation
Correct Answer
D:
Model invents an answer despite no relevant retrieved evidence. Implement grounded-response gate that declines unsupported requests.
Incorrect Answers
A:
“Parse returned JSON response fields with validated paths” concerns SQL code treats whole response envelope as plain answer; the reported problem instead is Model invents an answer despite no relevant retrieved evidence. Implement grounded-response gate that declines unsupported requests.
B:
“Project only permitted fields and redact sensitive columns prior to model call” addresses the rag confidential-data minimization situation—unneeded PII would be sent to external language model. The observed failure is: Model invents an answer despite no relevant retrieved evidence. Implement grounded-response gate that declines unsupported requests.
C:
“Use RAG to retrieve relevant policy passages as context for generation” concerns Model alone invents rules not in corporate source; the reported problem instead is Model invents an answer despite no relevant retrieved evidence. Implement grounded-response gate that declines unsupported requests.
Question 788
A database engineer at Willow Creek Finance is investigating this case: A user asks a question absent from available policies. The relevant finding is: Model invents an answer despite no relevant retrieved evidence. What isolated pilot would provide the strongest evidence before rollout?
- Build prompt from masked synthetic customer records
- Ask a fictional question with zero matching snippets
- Use synthetic success and error endpoint responses
- Ask sample question with conflicting old and new policies
Explanation
Correct Answer
B:
Model invents an answer despite no relevant retrieved evidence. Ask a fictional question with zero matching snippets.
Incorrect Answers
A:
“Build prompt from masked synthetic customer records” concerns Unneeded PII would be sent to external language model; the reported problem instead is Model invents an answer despite no relevant retrieved evidence. Ask a fictional question with zero matching snippets.
C:
“Use synthetic success and error endpoint responses” concerns SQL code treats whole response envelope as plain answer; the reported problem instead is Model invents an answer despite no relevant retrieved evidence. Ask a fictional question with zero matching snippets.
D:
“Ask sample question with conflicting old and new policies” concerns Assistant answers without linking supporting source rows; the reported problem instead is Model invents an answer despite no relevant retrieved evidence. Ask a fictional question with zero matching snippets.
Question 789
Granite Ridge Technology is responsible for an Azure SQL or Microsoft SQL workload. A user asks a question absent from available policies. Operational evidence: Model invents an answer despite no relevant retrieved evidence. Which acceptance result most directly demonstrates the requirement has been satisfied?
- System clearly reports insufficient evidence rather than fabricating policy
- Payload fits context while retaining needed evidence
- Grounded answer cites appropriate source instead of unsupported claims
- Procedure retries within policy, does not duplicate business writes
Explanation
Correct Answer
A:
Model invents an answer despite no relevant retrieved evidence. System clearly reports insufficient evidence rather than fabricating policy.
Incorrect Answers
B:
“Payload fits context while retaining needed evidence” concerns Prompt exceeds deployment context/token budget; the reported problem instead is Model invents an answer despite no relevant retrieved evidence. System clearly reports insufficient evidence rather than fabricating policy.
C:
“Grounded answer cites appropriate source instead of unsupported claims” concerns Model alone invents rules not in corporate source; the reported problem instead is Model invents an answer despite no relevant retrieved evidence. System clearly reports insufficient evidence rather than fabricating policy.
D:
“Procedure retries within policy, does not duplicate business writes” concerns Blind retries duplicate charges or overload endpoint; the reported problem instead is Model invents an answer despite no relevant retrieved evidence. System clearly reports insufficient evidence rather than fabricating policy.
Question 790
At Pinecrest Operations, a user asks a question absent from available policies. The observed constraint is: Model invents an answer despite no relevant retrieved evidence. What operational condition would provide the earliest useful regression warning?
- Monitor retry rate, token cost and latency
- Monitor hallucination and missing citations
- Monitor unsupported-answer rate and recall gaps
- Monitor schema changes and parsing failures
Explanation
Correct Answer
C:
Model invents an answer despite no relevant retrieved evidence. Monitor unsupported-answer rate and recall gaps.
Incorrect Answers
A:
“Monitor retry rate, token cost and latency” concerns Blind retries duplicate charges or overload endpoint; the reported problem instead is Model invents an answer despite no relevant retrieved evidence. Monitor unsupported-answer rate and recall gaps.
B:
“Monitor hallucination and missing citations” concerns Model alone invents rules not in corporate source; the reported problem instead is Model invents an answer despite no relevant retrieved evidence. Monitor unsupported-answer rate and recall gaps.
D:
“Monitor schema changes and parsing failures” concerns SQL code treats whole response envelope as plain answer; the reported problem instead is Model invents an answer despite no relevant retrieved evidence. Monitor unsupported-answer rate and recall gaps.