Microsoft DP-800 Practice Test 79 - Prepaway
Practice Exams:

Pass Microsoft DP-800 Exam in First Attempt Guaranteed!

Get 100% Latest Exam Questions, Accurate & Verified Answers!

30 Days Free Updates, Instant Download!

Verified By Experts
Premium File
$69.99 $76.99

DP-800 Premium ETE File


  • Premium File 101 Questions & Answers. Last Update: Nov 06, 2026
Whats Included:
  • Latest Questions
  • 100% Accurate Answers
  • Fast Exam Updates

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?

  1. Implement idempotent event handling and durable progress controls for the SQL trigger binding.
  2. Use a suitable Logic Apps or event-triggered integration with narrow filters and approved recipients.
  3. Use supported Change Tracking with a version watermark and controlled rehydration of current rows.
  4. Enable suitable Application Insights and Log Analytics telemetry with correlation IDs and safe logging.

Explanation

Correct Answer

C:

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

A:

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.

B:

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.

D:

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?

  1. AI-generated changes repeatedly use direct destructive alterations instead of the required deployment-project workflow.
  2. The faster version silently drops refunds because a new INNER JOIN filters unmatched rows.
  3. MCP tool metadata shows privileges that include schema changes and unrelated sensitive tables.
  4. A code review finds customer identifiers and credential-like strings committed alongside instruction markdown.

Explanation

Correct Answer

A:

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

B:

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.

C:

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.

D:

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?

  1. Chunking should preserve semantically necessary context instead of merely maximizing ingestion speed.
  2. Vector dimensions and model spaces must be compatible for meaningful similarity calculations.
  3. Embedding metadata enables quality monitoring, reconciliation, and safe model evolution.
  4. Synchronous external calls inside write transactions can couple availability to a remote inference service.

Explanation

Correct Answer

D:

Synchronous external calls inside write transactions can couple availability to a remote inference service.

Incorrect Answers

A:

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.

B:

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.

C:

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?

  1. The selected retrieval method meets the required accuracy and response-time targets for each workload.
  2. A benchmark reaches minimum relevant top-k hit rates while respecting service latency.
  3. Exact product-code queries retrieve their matching rows while conceptual requests remain useful.
  4. A representative query meets latency while returning acceptable nearest-neighbor quality.

Explanation

Correct Answer

C:

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

A:

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.

B:

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.

D:

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.

  1. Evaluate ledger table capabilities and secure digest verification while maintaining role-based write controls.
  2. Evaluate system-versioned temporal tables with history retention and appropriate access controls.
  3. The revised schema supports required searches while reducing unnecessary storage and migration burden.
  4. An authorized verifier detects simulated unauthorized modifications using a trusted ledger digest.
  5. Review partition alignment and required uniqueness keys for all indexes involved in maintenance.

Explanation

Correct Answers

A:

Evaluate ledger table capabilities and secure digest verification while maintaining role-based write controls.

D:

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

B:

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.

C:

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.

E:

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?

  1. Read workloads show shared/exclusive lock contention during a legitimate batch update.
  2. A parallel test leaves inventory higher than the total number of fulfilled orders implies.
  3. Resource charts show high CPU while the team has no ranked list of query costs.
  4. Query Store shows the same query hash shifted to a more expensive plan after deployment.

Explanation

Correct Answer

D:

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

A:

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.

B:

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.

C:

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.

  1. Add end-to-end integration tests using compatible staged SQL schema and actual API configuration.
  2. Resolve schema conflicts with a model diff and tests before approving the combined pull request.
  3. Add unit tests covering normal orders, null inputs, boundary discounts, and rollbacks before deployment.
  4. A clean rebuild and incremental deployment produce identical authorized lookup mappings.
  5. The merged project builds and a staged migration preserves all approved fields.

Explanation

Correct Answers

B:

Resolve schema conflicts with a model diff and tests before approving the combined pull request.

E:

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

A:

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.

C:

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.

D:

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?

  1. Changing a query parameter returns records for another tenant in a replay test.
  2. An API caller can request an unintended entity that the deployment identity can also read.
  3. A database support login can read every salary directly in plaintext despite lacking a payroll role.
  4. A test role derives confidential values through unrestricted filters despite seeing masked display columns.

Explanation

Correct Answer

B:

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

A:

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.

C:

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.

D:

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.

  1. Require appropriate protected branches, successful CI, environment approvals, and traceable release gates.
  2. Resolve schema conflicts with a model diff and tests before approving the combined pull request.
  3. Add unit tests covering normal orders, null inputs, boundary discounts, and rollbacks before deployment.
  4. Only authorized approved pull requests and release approvals can reach production.
  5. A clean rebuild and incremental deployment produce identical authorized lookup mappings.

Explanation

Correct Answers

A:

Require appropriate protected branches, successful CI, environment approvals, and traceable release gates.

D:

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

B:

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.

C:

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.

E:

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?

  1. Business data consistency requires protecting read-modify-write sequences.
  2. Performance tuning should begin with measured high-impact queries rather than random configuration changes.
  3. Blocking is waiting for locks; a deadlock involves a cycle that SQL Server must resolve.
  4. Concurrency design must preserve business invariants, not just avoid individual row conflicts.

Explanation

Correct Answer

D:

Concurrency design must preserve business invariants, not just avoid individual row conflicts.

Incorrect Answers

A:

Business data consistency requires protecting read-modify-write sequences. Concurrency design must preserve business invariants, not just avoid individual row conflicts.

B:

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.

C:

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?

  1. An authorized nested query returns correct variants while excluded records remain inaccessible.
  2. The endpoint rejects unapproved filters and returns correct authorized shipment matches.
  3. Allowed requests invoke the intended procedure and crafted SQL payloads are rejected.
  4. A bounded query or optimized mapping meets latency targets under representative load.

Explanation

Correct Answer

A:

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

B:

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.

C:

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.

D:

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