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 79
Question 780
A mobile application needs to learn which customer IDs changed since its last successful sync without storing complete before-and-after value history. Which next step most directly resolves this SQL solution issue?
Explanation
Correct Answer
Use supported Change Tracking with a version watermark and controlled rehydration of current rows. Change Tracking is suited to changed-row identification rather than full change payload history.
Incorrect Answers
Implement idempotent event handling and durable progress controls for the SQL trigger binding. Change Tracking is suited to changed-row identification rather than full change payload history. Use supported Change Tracking with a version watermark and controlled rehydration of current rows.
Use a suitable Logic Apps or event-triggered integration with narrow filters and approved recipients. Change Tracking is suited to changed-row identification rather than full change payload history. Use supported Change Tracking with a version watermark and controlled rehydration of current rows.
Enable suitable Application Insights and Log Analytics telemetry with correlation IDs and safe logging. Change Tracking is suited to changed-row identification rather than full change payload history. Use supported Change Tracking with a version watermark and controlled rehydration of current rows.
Question 781
A distributed team uses GitHub Copilot for SQL project changes but suggestions repeatedly violate the team's migration and naming conventions. What should the database developer verify to confirm the suspected cause?
Explanation
Correct Answer
AI-generated changes repeatedly use direct destructive alterations instead of the required deployment-project workflow. Repository instructions can guide assistance but do not replace automated checks or accountable reviewers.
Incorrect Answers
The faster version silently drops refunds because a new INNER JOIN filters unmatched rows. Repository instructions can guide assistance but do not replace automated checks or accountable reviewers. AI-generated changes repeatedly use direct destructive alterations instead of the required deployment-project workflow.
MCP tool metadata shows privileges that include schema changes and unrelated sensitive tables. Repository instructions can guide assistance but do not replace automated checks or accountable reviewers. AI-generated changes repeatedly use direct destructive alterations instead of the required deployment-project workflow.
A code review finds customer identifiers and credential-like strings committed alongside instruction markdown. Repository instructions can guide assistance but do not replace automated checks or accountable reviewers. AI-generated changes repeatedly use direct destructive alterations instead of the required deployment-project workflow.
Question 782
A team puts a remote inference call inside a database trigger so every customer update must wait for an embedding service response. Which technical principle explains the correct response?
Explanation
Correct Answer
Synchronous external calls inside write transactions can couple availability to a remote inference service.
Incorrect Answers
Chunking should preserve semantically necessary context instead of merely maximizing ingestion speed. Synchronous external calls inside write transactions can couple availability to a remote inference service.
Vector dimensions and model spaces must be compatible for meaningful similarity calculations. Synchronous external calls inside write transactions can couple availability to a remote inference service.
Embedding metadata enables quality monitoring, reconciliation, and safe model evolution. Synchronous external calls inside write transactions can couple availability to a remote inference service.
Question 783
A product support database must find tickets containing exact hardware model codes and a proposal uses semantic vector matching alone. Which outcome shows the requirement is met without introducing a new risk?
Explanation
Correct Answer
Exact product-code queries retrieve their matching rows while conceptual requests remain useful. A product support database must find tickets containing exact hardware model codes and a proposal uses semantic vector matching alone.
Incorrect Answers
The selected retrieval method meets the required accuracy and response-time targets for each workload. A product support database must find tickets containing exact hardware model codes and a proposal uses semantic vector matching alone. Exact product-code queries retrieve their matching rows while conceptual requests remain useful.
A benchmark reaches minimum relevant top-k hit rates while respecting service latency. A product support database must find tickets containing exact hardware model codes and a proposal uses semantic vector matching alone. Exact product-code queries retrieve their matching rows while conceptual requests remain useful.
A representative query meets latency while returning acceptable nearest-neighbor quality. A product support database must find tickets containing exact hardware model codes and a proposal uses semantic vector matching alone. Exact product-code queries retrieve their matching rows while conceptual requests remain useful.
Question 784
A regulated supplier wants independently verifiable evidence that recorded transaction adjustments have not been silently altered after approval. Choose TWO statements: a suitable intervention and evidence of its success.
Explanation
Correct Answers
Evaluate ledger table capabilities and secure digest verification while maintaining role-based write controls.
An authorized verifier detects simulated unauthorized modifications using a trusted ledger digest. Evaluate ledger table capabilities and secure digest verification while maintaining role-based write controls.
Incorrect Answers
Evaluate system-versioned temporal tables with history retention and appropriate access controls. Evaluate ledger table capabilities and secure digest verification while maintaining role-based write controls.
The revised schema supports required searches while reducing unnecessary storage and migration burden. Evaluate ledger table capabilities and secure digest verification while maintaining role-based write controls. An authorized verifier detects simulated unauthorized modifications using a trusted ledger digest.
Review partition alignment and required uniqueness keys for all indexes involved in maintenance. Evaluate ledger table capabilities and secure digest verification while maintaining role-based write controls.
Question 785
A customer portal query became slow immediately after a SQL compatibility change and operators cannot reproduce the older fast plan from memory. Which observation is the strongest evidence for the reported problem?
Explanation
Correct Answer
Query Store shows the same query hash shifted to a more expensive plan after deployment. Query Store provides historical query-plan evidence and supports evidence-based regression diagnosis.
Incorrect Answers
Read workloads show shared/exclusive lock contention during a legitimate batch update. Query Store provides historical query-plan evidence and supports evidence-based regression diagnosis. Query Store shows the same query hash shifted to a more expensive plan after deployment.
A parallel test leaves inventory higher than the total number of fulfilled orders implies. Query Store provides historical query-plan evidence and supports evidence-based regression diagnosis. Query Store shows the same query hash shifted to a more expensive plan after deployment.
Resource charts show high CPU while the team has no ranked list of query costs. Query Store provides historical query-plan evidence and supports evidence-based regression diagnosis. Query Store shows the same query hash shifted to a more expensive plan after deployment.
Question 786
Two feature branches independently modify the same customer table and the merged migration accidentally drops a required column. Choose TWO statements: a suitable intervention and evidence of its success.
Explanation
Correct Answers
Resolve schema conflicts with a model diff and tests before approving the combined pull request.
The merged project builds and a staged migration preserves all approved fields. Resolve schema conflicts with a model diff and tests before approving the combined pull request.
Incorrect Answers
Add end-to-end integration tests using compatible staged SQL schema and actual API configuration. Resolve schema conflicts with a model diff and tests before approving the combined pull request.
Add unit tests covering normal orders, null inputs, boundary discounts, and rollbacks before deployment. Resolve schema conflicts with a model diff and tests before approving the combined pull request.
A clean rebuild and incremental deployment produce identical authorized lookup mappings. Resolve schema conflicts with a model diff and tests before approving the combined pull request.
Question 787
A team exposes SQL data through Data API builder but assumes API authentication alone prevents access to every table. Which observation is the strongest evidence for the reported problem?
Explanation
Correct Answer
An API caller can request an unintended entity that the deployment identity can also read. API exposure needs authorization at both application endpoint and SQL permission layers.
Incorrect Answers
Changing a query parameter returns records for another tenant in a replay test. API exposure needs authorization at both application endpoint and SQL permission layers. An API caller can request an unintended entity that the deployment identity can also read.
A database support login can read every salary directly in plaintext despite lacking a payroll role. API exposure needs authorization at both application endpoint and SQL permission layers. An API caller can request an unintended entity that the deployment identity can also read.
A test role derives confidential values through unrestricted filters despite seeing masked display columns. API exposure needs authorization at both application endpoint and SQL permission layers. An API caller can request an unintended entity that the deployment identity can also read.
Question 788
A regulated organization's pipeline automatically deploys SQL schema changes to production immediately when a developer pushes to a feature branch. Choose TWO: one correct response and one verification of success.
Explanation
Correct Answers
Require appropriate protected branches, successful CI, environment approvals, and traceable release gates.
Only authorized approved pull requests and release approvals can reach production. Require appropriate protected branches, successful CI, environment approvals, and traceable release gates.
Incorrect Answers
Resolve schema conflicts with a model diff and tests before approving the combined pull request. Require appropriate protected branches, successful CI, environment approvals, and traceable release gates.
Add unit tests covering normal orders, null inputs, boundary discounts, and rollbacks before deployment. Require appropriate protected branches, successful CI, environment approvals, and traceable release gates.
A clean rebuild and incremental deployment produce identical authorized lookup mappings. Require appropriate protected branches, successful CI, environment approvals, and traceable release gates.
Question 789
Two concurrent booking transactions check an available seat count then both reserve the final seat because the availability predicate is not protected. What is the underlying reason for the corrective step?
Explanation
Correct Answer
Concurrency design must preserve business invariants, not just avoid individual row conflicts.
Incorrect Answers
Business data consistency requires protecting read-modify-write sequences. Concurrency design must preserve business invariants, not just avoid individual row conflicts.
Performance tuning should begin with measured high-impact queries rather than random configuration changes. Concurrency design must preserve business invariants, not just avoid individual row conflicts.
Blocking is waiting for locks; a deadlock involves a cycle that SQL Server must resolve. Concurrency design must preserve business invariants, not just avoid individual row conflicts.
Question 790
A product catalog API must retrieve a product with its authorized variants in one GraphQL request but the relationship mapping is not configured. Which outcome shows the requirement is met without introducing a new risk?
Explanation
Correct Answer
An authorized nested query returns correct variants while excluded records remain inaccessible. A product catalog API must retrieve a product with its authorized variants in one GraphQL request but the relationship mapping is not configured.
Incorrect Answers
The endpoint rejects unapproved filters and returns correct authorized shipment matches. A product catalog API must retrieve a product with its authorized variants in one GraphQL request but the relationship mapping is not configured. An authorized nested query returns correct variants while excluded records remain inaccessible.
Allowed requests invoke the intended procedure and crafted SQL payloads are rejected. A product catalog API must retrieve a product with its authorized variants in one GraphQL request but the relationship mapping is not configured. An authorized nested query returns correct variants while excluded records remain inaccessible.
A bounded query or optimized mapping meets latency targets under representative load. A product catalog API must retrieve a product with its authorized variants in one GraphQL request but the relationship mapping is not configured. An authorized nested query returns correct variants while excluded records remain inaccessible.
Developing AI-Enabled Database Solutions (DP-800) Practice Tests
- 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)
- Microsoft DP-800 Practice Test 80 - 10 Questions (Last Reviewed 25-Oct-2026)