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 64
Question 630
A finance assistant must answer questions about changing payment policy and the team proposes updating model weights whenever the policy changes. What is the underlying reason for the corrective step?
Explanation
Correct Answer
RAG supplies current grounded evidence without encoding every business fact in model weights.
Incorrect Answers
Grounded answers require verifiable provenance, not merely retrieval in the background. RAG supplies current grounded evidence without encoding every business fact in model weights.
External model responses are untrusted service results and need robust parsing and error handling. RAG supplies current grounded evidence without encoding every business fact in model weights.
External REST calls from SQL must minimize disclosed data and enforce endpoint security. RAG supplies current grounded evidence without encoding every business fact in model weights.
Question 631
A bank needs to reconstruct the prior values of an account preference after customer service overwrote a row and the current table only stores the latest state. Which clue best distinguishes this issue from similar incidents?
Explanation
Correct Answer
Investigators cannot determine what preference was effective before the latest update from the current table. Temporal history tracks row versions for point-in-time inspection rather than relying on audit guesses.
Incorrect Answers
A test shows the old index rejects valid same-code invoices in different tenants but permits duplicate codes within one tenant under some paths. Temporal history tracks row versions for point-in-time inspection rather than relying on audit guesses. Investigators cannot determine what preference was effective before the latest update from the current table.
The plan scans many rows and performs a costly sort for a small tenant-specific result. Temporal history tracks row versions for point-in-time inspection rather than relying on audit guesses. Investigators cannot determine what preference was effective before the latest update from the current table.
Storage inspection finds most optional attribute columns are NULL in nearly every row. Temporal history tracks row versions for point-in-time inspection rather than relying on audit guesses. Investigators cannot determine what preference was effective before the latest update from the current table.
Question 632
A GraphQL API maps customer and invoice tables and a consumer can ask for sensitive fields not shown in the application UI. What distinction makes the recommended approach appropriate?
Explanation
Correct Answer
A friendly UI never substitutes for server-side field and entity access controls.
Incorrect Answers
Encryption strength and operational availability both depend on disciplined key lifecycle management. A friendly UI never substitutes for server-side field and entity access controls.
Model endpoints are security-sensitive downstream services and credentials must be governed. A friendly UI never substitutes for server-side field and entity access controls.
API exposure needs authorization at both application endpoint and SQL permission layers. A friendly UI never substitutes for server-side field and entity access controls.
Question 633
A multitenant billing application assumes invoice codes are globally unique but the actual rule requires uniqueness only within each tenant. Which corrective action best fits the observed symptoms?
Explanation
Correct Answer
Define a composite uniqueness constraint across the tenant identifier and invoice code. Uniqueness keys must encode the business scope of identity rather than an arbitrary column.
Incorrect Answers
Implement a correctly scoped foreign key and repair existing violations before enabling trusted enforcement. Uniqueness keys must encode the business scope of identity rather than an arbitrary column. Define a composite uniqueness constraint across the tenant identifier and invoice code.
Design a targeted nonclustered index with an appropriate key order and included output columns after measuring the workload. Uniqueness keys must encode the business scope of identity rather than an arbitrary column. Define a composite uniqueness constraint across the tenant identifier and invoice code.
Design JSON access and indexing according to the engine's supported JSON features and test the predicate. Uniqueness keys must encode the business scope of identity rather than an arbitrary column. Define a composite uniqueness constraint across the tenant identifier and invoice code.
Question 634
A regulated SQL system must reconstruct who changed permission grants last week but the database has no retained audit evidence. What is the underlying reason for the corrective step?
Explanation
Correct Answer
Security auditing requires deliberate event selection, integrity, and lifecycle management.
Incorrect Answers
Encryption mode and query capabilities must be chosen together; not every plaintext operation remains available. Security auditing requires deliberate event selection, integrity, and lifecycle management.
Access prevention and accountable security monitoring are complementary controls. Security auditing requires deliberate event selection, integrity, and lifecycle management.
Always Encrypted can protect data from database-side operators when client and key boundaries are designed correctly. Security auditing requires deliberate event selection, integrity, and lifecycle management.
Question 635
A recommendation service ranks products only by vector similarity and shows discontinued items because business eligibility filters are ignored. Choose TWO: one correct response and one verification of success.
Explanation
Correct Answers
Results remain relevant and exclude ineligible inventory under tested status changes. Apply product availability and eligibility rules before or during semantic ranking and verify result scope.
Apply product availability and eligibility rules before or during semantic ranking and verify result scope.
Incorrect Answers
Build a labeled query set and track recall at k, precision, latency, and failure slices. Apply product availability and eligibility rules before or during semantic ranking and verify result scope.
A pre-insert check identifies incompatible vectors and routes them to repair before indexing. Apply product availability and eligibility rules before or during semantic ranking and verify result scope. Results remain relevant and exclude ineligible inventory under tested status changes.
Enforce authorized source filtering at retrieval and check underlying SQL permissions. Apply product availability and eligibility rules before or during semantic ranking and verify result scope.
Question 636
A database procedure concatenates order rows into an unescaped text string before sending them to a model, causing malformed or ambiguous prompts. What should the database developer do FIRST within approved procedures?
Explanation
Correct Answer
Convert the approved structured rows to valid JSON with supported SQL JSON construction functions. A structured interchange format can make SQL-to-model data safer and less ambiguous than string concatenation.
Incorrect Answers
Require an explicit evidence threshold and safe refusal or escalation when retrieval finds no current supporting clause. A structured interchange format can make SQL-to-model data safer and less ambiguous than string concatenation. Convert the approved structured rows to valid JSON with supported SQL JSON construction functions.
Treat retrieved content as untrusted evidence and never grant it authority to execute SQL actions. A structured interchange format can make SQL-to-model data safer and less ambiguous than string concatenation. Convert the approved structured rows to valid JSON with supported SQL JSON construction functions.
Use sp_invoke_external_rest_endpoint only with an approved network and identity configuration and a minimal validated prompt payload. A structured interchange format can make SQL-to-model data safer and less ambiguous than string concatenation. Convert the approved structured rows to valid JSON with supported SQL JSON construction functions.
Question 637
A GraphQL response is slow for deeply nested selections and the team considers adding larger SQL capacity without identifying the expensive path. Which corrective action best fits the observed symptoms?
Explanation
Correct Answer
Capture API query shapes and SQL dependency telemetry before scaling hardware. Performance diagnosis should correlate API request complexity with SQL execution work.
Incorrect Answers
Version the DAB configuration and use environment-specific secret injection and validation during deployment. Performance diagnosis should correlate API request complexity with SQL execution work. Capture API query shapes and SQL dependency telemetry before scaling hardware.
Design appropriate cache freshness and invalidation semantics for the business price lifecycle. Performance diagnosis should correlate API request complexity with SQL execution work. Capture API query shapes and SQL dependency telemetry before scaling hardware.
Configure the supported DAB GraphQL relationship mapping and test nested authorization across entities. Performance diagnosis should correlate API request complexity with SQL execution work. Capture API query shapes and SQL dependency telemetry before scaling hardware.
Question 638
A SQL-centered maintenance application stores images and text descriptions of equipment failures and the team attempts to embed images with a text-only pipeline. Which outcome shows the requirement is met without introducing a new risk?
Explanation
Correct Answer
A test query retrieves authorized matching image and text records with validated accuracy.
Incorrect Answers
Database transactions remain available during a model outage and embeddings catch up after recovery. A test query retrieves authorized matching image and text records with validated accuracy.
A staged migration passes regression benchmarks and retains a clear rollback route. A test query retrieves authorized matching image and text records with validated accuracy.
Authorized calls work and no unapproved identity can use the integration to retrieve or generate protected content. A test query retrieves authorized matching image and text records with validated accuracy.
Question 639
A regulated app writes SQL audit logs to short-lived storage and a retention job removes investigation evidence before the mandated period. What is the MOST appropriate initial remediation?
Explanation
Correct Answer
Configure protected audit export and retention consistent with organizational policy. Audit coverage is incomplete without secure durable retention and controlled access.
Incorrect Answers
Enforce authorized tenant scoping through backend policies and service identity rather than trust the caller's filter. Audit coverage is incomplete without secure durable retention and controlled access. Configure protected audit export and retention consistent with organizational policy.
Evaluate Always Encrypted with appropriate client drivers and protected key management for sensitive salary columns. Audit coverage is incomplete without secure durable retention and controlled access. Configure protected audit export and retention consistent with organizational policy.
Configure appropriate SQL auditing to a protected destination with tested retention and access reviews. Audit coverage is incomplete without secure durable retention and controlled access. Configure protected audit export and retention consistent with organizational policy.
Question 640
An Azure Function consumes SQL change events with a credential that also grants access to unrelated financial tables. How should the SQL engineering team confirm the issue is truly resolved?
Explanation
Correct Answer
The function processes authorized events while negative access tests deny unrelated tables. The intended intervention is: Grant the function only the change-data access it requires and review its output destination.
Incorrect Answers
Unauthorized context switching is rejected and each user remains restricted to their approved tenant. The intended intervention is: Grant the function only the change-data access it requires and review its output destination. The function processes authorized events while negative access tests deny unrelated tables.
Attempted destructive actions are blocked and permitted read tools function for authorized identities. The intended intervention is: Grant the function only the change-data access it requires and review its output destination. The function processes authorized events while negative access tests deny unrelated tables.
Ordinary operators view masked fields while authorized limited workflows follow explicit permissions. The intended intervention is: Grant the function only the change-data access it requires and review its output destination. The function processes authorized events while negative access tests deny unrelated tables.
Developing AI-Enabled Database Solutions (DP-800) Practice Tests
- Microsoft DP-800 Practice Test 62 - 10 Questions (Last Reviewed 12-Nov-2026)
- Microsoft DP-800 Practice Test 63 - 10 Questions (Last Reviewed 11-Nov-2026)
- Microsoft DP-800 Practice Test 64 - 10 Questions (Last Reviewed 10-Nov-2026)
- Microsoft DP-800 Practice Test 65 - 10 Questions (Last Reviewed 09-Nov-2026)
- Microsoft DP-800 Practice Test 66 - 10 Questions (Last Reviewed 08-Nov-2026)