Microsoft DP-800 Practice Test 76
Question 750
BrightPath Studios is responsible for an Azure SQL or Microsoft SQL workload. A new hybrid search system looks fast but returns irrelevant top results. Operational evidence: Latency metric alone says nothing about retrieval quality. What operational condition would provide the earliest useful regression warning?
- Monitor model dimension drift
- Monitor zero vectors and normalization failures
- Monitor drift in search quality and zero-result rates
- Monitor fusion parameter effects and result stability
Explanation
Correct Answer
C:
Latency metric alone says nothing about retrieval quality. Monitor drift in search quality and zero-result rates.
Incorrect Answers
A:
“Monitor model dimension drift” concerns Queries fail during similarity calculation; the reported problem instead is Latency metric alone says nothing about retrieval quality. Monitor drift in search quality and zero-result rates.
B:
“Monitor zero vectors and normalization failures” concerns Magnitude dominates scores when direction matters; the reported problem instead is Latency metric alone says nothing about retrieval quality. Monitor drift in search quality and zero-result rates.
D:
“Monitor fusion parameter effects and result stability” concerns Raw score addition unfairly favors one system; the reported problem instead is Latency metric alone says nothing about retrieval quality. Monitor drift in search quality and zero-result rates.
Question 751
At Lakeview Services, a staff assistant must answer using internal policy documents. The observed constraint is: Model alone invents rules not in corporate source. What initial check best narrows the technical cause without altering business data?
- Inspect chunk IDs, document versions and citation metadata
- Inspect retrieval relevance threshold and abstention criteria
- Inspect data classification and outbound prompt payload
- Inspect groundedness requirement and available authorized documents
Explanation
Correct Answer
D:
Model alone invents rules not in corporate source. Inspect groundedness requirement and available authorized documents.
Incorrect Answers
A:
“Inspect chunk IDs, document versions and citation metadata” concerns Assistant answers without linking supporting source rows; the reported problem instead is Model alone invents rules not in corporate source. Inspect groundedness requirement and available authorized documents.
B:
“Inspect retrieval relevance threshold and abstention criteria” concerns Model invents an answer despite no relevant retrieved evidence; the reported problem instead is Model alone invents rules not in corporate source. Inspect groundedness requirement and available authorized documents.
C:
“Inspect data classification and outbound prompt payload” concerns Unneeded PII would be sent to external language model; the reported problem instead is Model alone invents rules not in corporate source. Inspect groundedness requirement and available authorized documents.
Question 752
A database engineer at Crownridge Travel is investigating this case: A staff assistant must answer using internal policy documents. The relevant finding is: Model alone invents rules not in corporate source. Which proposed change is the most suitable response to the observed constraint?
- Use supported SQL JSON generation for structured prompt payload
- Use RAG to retrieve relevant policy passages as context for generation
- Select relevant top-k chunks and apply a bounded token budget
- Include source IDs/versions in retrieval and require cited answer passages
Explanation
Correct Answer
B:
Model alone invents rules not in corporate source. Use RAG to retrieve relevant policy passages as context for generation.
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 Model alone invents rules not in corporate source. Use RAG to retrieve relevant policy passages as context for generation.
C:
“Select relevant top-k chunks and apply a bounded token budget” concerns Prompt exceeds deployment context/token budget; the reported problem instead is Model alone invents rules not in corporate source. Use RAG to retrieve relevant policy passages as context for generation.
D:
“Include source IDs/versions in retrieval and require cited answer passages” concerns Assistant answers without linking supporting source rows; the reported problem instead is Model alone invents rules not in corporate source. Use RAG to retrieve relevant policy passages as context for generation.
Question 753
Oakridge Advisors is responsible for an Azure SQL or Microsoft SQL workload. A staff assistant must answer using internal policy documents. Operational evidence: Model alone invents rules not in corporate source. What isolated pilot would provide the strongest evidence before rollout?
- Inject benign adversarial instruction in a mock retrieved document
- Ask sample question with conflicting old and new policies
- Ask fictional policy question with and without retrieved snippets
- Attempt permitted test request and forbidden off-policy request
Explanation
Correct Answer
C:
Model alone invents rules not in corporate source. Ask fictional policy question with and without retrieved snippets.
Incorrect Answers
A:
“Inject benign adversarial instruction in a mock retrieved document” concerns Untrusted document text could influence agent behavior; the reported problem instead is Model alone invents rules not in corporate source. Ask fictional policy question with and without retrieved snippets.
B:
“Ask sample question with conflicting old and new policies” concerns Assistant answers without linking supporting source rows; the reported problem instead is Model alone invents rules not in corporate source. Ask fictional policy question with and without retrieved snippets.
D:
“Attempt permitted test request and forbidden off-policy request” concerns Any SQL login could exfiltrate data if broad EXEC rights are granted; the reported problem instead is Model alone invents rules not in corporate source. Ask fictional policy question with and without retrieved snippets.
Question 754
At Horizon Communications, a staff assistant must answer using internal policy documents. The observed constraint is: Model alone invents rules not in corporate source. Assume the authorized current policy passages contain a clear, complete answer and no conflicting clauses. Which positive-result acceptance check proves the assistant cited relevant evidence rather than inventing policy requirements?
- Answer points to current referenced source and flags conflict
- Answer text is extracted correctly or errors reported safely
- System clearly reports insufficient evidence rather than fabricating policy
- Grounded answer cites appropriate source instead of unsupported claims
Explanation
Correct Answer
D:
Model alone invents rules not in corporate source. Grounded answer cites appropriate source instead of unsupported claims.
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 Model alone invents rules not in corporate source. Grounded answer cites appropriate source instead of unsupported claims.
B:
“Answer text is extracted correctly or errors reported safely” concerns SQL code treats whole response envelope as plain answer; the reported problem instead is Model alone invents rules not in corporate source. Grounded answer cites appropriate source instead of unsupported claims.
C:
Abstaining with an insufficient-evidence message is correct when documentation is absent or contradictory, but this test explicitly supplies adequate and consistent authorized passages. The acceptance condition is a supported affirmative answer with relevant citations, as in D.
Question 755
A database engineer at Brookfield Labs is investigating this case: A staff assistant must answer using internal policy documents. The relevant finding is: Model alone invents rules not in corporate source. What operational condition would provide the earliest useful regression warning?
- Monitor context overflows and truncated citations
- Monitor stale citations and source deletion
- Monitor hallucination and missing citations
- Monitor unsupported-answer rate and recall gaps
Explanation
Correct Answer
C:
Model alone invents rules not in corporate source. Monitor hallucination and missing citations.
Incorrect Answers
A:
“Monitor context overflows and truncated citations” concerns Prompt exceeds deployment context/token budget; the reported problem instead is Model alone invents rules not in corporate source. Monitor hallucination and missing citations.
B:
“Monitor stale citations and source deletion” concerns Assistant answers without linking supporting source rows; the reported problem instead is Model alone invents rules not in corporate source. Monitor hallucination and missing citations.
D:
“Monitor unsupported-answer rate and recall gaps” concerns Model invents an answer despite no relevant retrieved evidence; the reported problem instead is Model alone invents rules not in corporate source. Monitor hallucination and missing citations.
Question 756
Cascade Manufacturing is responsible for an Azure SQL or Microsoft SQL workload. A SQL RAG procedure must call a model hosted behind HTTPS. Operational evidence: Any SQL login could exfiltrate data if broad EXEC rights are granted. What initial check best narrows the technical cause without altering business data?
- Inspect response structure and error branches
- Inspect retrieval count, chunk sizes and endpoint token limits
- Inspect HTTP status, retry-after headers and execution permissions
- Review EXECUTE ANY EXTERNAL ENDPOINT permissions and approved host allowlists
Explanation
Correct Answer
D:
Any SQL login could exfiltrate data if broad EXEC rights are granted. Review EXECUTE ANY EXTERNAL ENDPOINT permissions and approved host allowlists.
Incorrect Answers
A:
“Inspect response structure and error branches” concerns SQL code treats whole response envelope as plain answer; the reported problem instead is Any SQL login could exfiltrate data if broad EXEC rights are granted. Review EXECUTE ANY EXTERNAL ENDPOINT permissions and approved host allowlists.
B:
“Inspect retrieval count, chunk sizes and endpoint token limits” concerns Prompt exceeds deployment context/token budget; the reported problem instead is Any SQL login could exfiltrate data if broad EXEC rights are granted. Review EXECUTE ANY EXTERNAL ENDPOINT permissions and approved host allowlists.
C:
“Inspect HTTP status, retry-after headers and execution permissions” concerns Blind retries duplicate charges or overload endpoint; the reported problem instead is Any SQL login could exfiltrate data if broad EXEC rights are granted. Review EXECUTE ANY EXTERNAL ENDPOINT permissions and approved host allowlists.
Question 757
At Clearwater Utilities, a SQL RAG procedure must call a model hosted behind HTTPS. The observed constraint is: Any SQL login could exfiltrate data if broad EXEC rights are granted. Which proposed change is the most suitable response to the observed constraint?
- Use bounded backoff and idempotent request handling where supported
- Grant minimum permissions and approved endpoint access to service identity
- Parse returned JSON response fields with validated paths
- Delimit retrieved content as untrusted data and restrict tool capabilities
Explanation
Correct Answer
B:
Any SQL login could exfiltrate data if broad EXEC rights are granted. Grant minimum permissions and approved endpoint access to service identity.
Incorrect Answers
A:
“Use bounded backoff and idempotent request handling where supported” concerns Blind retries duplicate charges or overload endpoint; the reported problem instead is Any SQL login could exfiltrate data if broad EXEC rights are granted. Grant minimum permissions and approved endpoint access to service identity.
C:
“Parse returned JSON response fields with validated paths” concerns SQL code treats whole response envelope as plain answer; the reported problem instead is Any SQL login could exfiltrate data if broad EXEC rights are granted. Grant minimum permissions and approved endpoint access to service identity.
D:
“Delimit retrieved content as untrusted data and restrict tool capabilities” concerns Untrusted document text could influence agent behavior; the reported problem instead is Any SQL login could exfiltrate data if broad EXEC rights are granted. Grant minimum permissions and approved endpoint access to service identity.
Question 758
A database engineer at Cedarbridge Health is investigating this case: A SQL RAG procedure must call a model hosted behind HTTPS. The relevant finding is: Any SQL login could exfiltrate data if broad EXEC rights are granted. What isolated pilot would provide the strongest evidence before rollout?
- Attempt permitted test request and forbidden off-policy request
- Ask fictional policy question with and without retrieved snippets
- Use synthetic success and error endpoint responses
- Simulate 429 and transient errors through approved test service
Explanation
Correct Answer
A:
Any SQL login could exfiltrate data if broad EXEC rights are granted. Attempt permitted test request and forbidden off-policy request.
Incorrect Answers
B:
“Ask fictional policy question with and without retrieved snippets” concerns Model alone invents rules not in corporate source; the reported problem instead is Any SQL login could exfiltrate data if broad EXEC rights are granted. Attempt permitted test request and forbidden off-policy request.
C:
“Use synthetic success and error endpoint responses” concerns SQL code treats whole response envelope as plain answer; the reported problem instead is Any SQL login could exfiltrate data if broad EXEC rights are granted. Attempt permitted test request and forbidden off-policy request.
D:
“Simulate 429 and transient errors through approved test service” concerns Blind retries duplicate charges or overload endpoint; the reported problem instead is Any SQL login could exfiltrate data if broad EXEC rights are granted. Attempt permitted test request and forbidden off-policy request.
Question 759
Ashwood Solutions is responsible for an Azure SQL or Microsoft SQL workload. A SQL RAG procedure must call a model hosted behind HTTPS. Operational evidence: Any SQL login could exfiltrate data if broad EXEC rights are granted. Which acceptance result most directly demonstrates the requirement has been satisfied?
- Answer text is extracted correctly or errors reported safely
- Assistant follows authorized task and does not execute injected instructions
- Allowed invocation works while unauthorized call is denied
- Payload parses correctly and contains only allowed fields
Explanation
Correct Answer
C:
Any SQL login could exfiltrate data if broad EXEC rights are granted. Allowed invocation works while unauthorized call is denied.
Incorrect Answers
A:
“Answer text is extracted correctly or errors reported safely” concerns SQL code treats whole response envelope as plain answer; the reported problem instead is Any SQL login could exfiltrate data if broad EXEC rights are granted. Allowed invocation works while unauthorized call is denied.
B:
“Assistant follows authorized task and does not execute injected instructions” concerns Untrusted document text could influence agent behavior; the reported problem instead is Any SQL login could exfiltrate data if broad EXEC rights are granted. Allowed invocation works while unauthorized call is denied.
D:
“Payload parses correctly and contains only allowed fields” concerns String concatenation produces malformed JSON when text contains quotes; the reported problem instead is Any SQL login could exfiltrate data if broad EXEC rights are granted. Allowed invocation works while unauthorized call is denied.
Question 760
At Seabrook University, a SQL RAG procedure must call a model hosted behind HTTPS. The observed constraint is: Any SQL login could exfiltrate data if broad EXEC rights are granted. What operational condition would provide the earliest useful regression warning?
- Monitor outbound endpoint audit events
- Monitor schema changes and parsing failures
- Monitor outbound payload policy violations
- Monitor anomalous tool calls and injection detections
Explanation
Correct Answer
A:
Any SQL login could exfiltrate data if broad EXEC rights are granted. Monitor outbound endpoint audit events.
Incorrect Answers
B:
“Monitor schema changes and parsing failures” concerns SQL code treats whole response envelope as plain answer; the reported problem instead is Any SQL login could exfiltrate data if broad EXEC rights are granted. Monitor outbound endpoint audit events.
C:
“Monitor outbound payload policy violations” concerns Unneeded PII would be sent to external language model; the reported problem instead is Any SQL login could exfiltrate data if broad EXEC rights are granted. Monitor outbound endpoint audit events.
D:
“Monitor anomalous tool calls and injection detections” concerns Untrusted document text could influence agent behavior; the reported problem instead is Any SQL login could exfiltrate data if broad EXEC rights are granted. Monitor outbound endpoint audit events.