Microsoft DP-800 Practice Test 35 - 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 35

Question 340

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 corrective action best fits the observed symptoms?

  1. Evaluate system-versioned temporal tables with history retention and appropriate access controls.
  2. Use a suitable native JSON type or a validity check supported on the target database engine.
  3. Design date-aligned partitions and a tested retention or sliding-window maintenance procedure.
  4. Evaluate a columnstore index and validate load patterns and query performance before choosing the final storage design.

Explanation

Correct Answer

A:

Evaluate system-versioned temporal tables with history retention and appropriate access controls. Temporal history tracks row versions for point-in-time inspection rather than relying on audit guesses.

Incorrect Answers

B:

Use a suitable native JSON type or a validity check supported on the target database engine. Temporal history tracks row versions for point-in-time inspection rather than relying on audit guesses. Evaluate system-versioned temporal tables with history retention and appropriate access controls.

C:

Design date-aligned partitions and a tested retention or sliding-window maintenance procedure. Temporal history tracks row versions for point-in-time inspection rather than relying on audit guesses. Evaluate system-versioned temporal tables with history retention and appropriate access controls.

D:

Evaluate a columnstore index and validate load patterns and query performance before choosing the final storage design. Temporal history tracks row versions for point-in-time inspection rather than relying on audit guesses. Evaluate system-versioned temporal tables with history retention and appropriate access controls.

Question 341

An operator hot-fixes a production stored procedure outside version control and the next release unexpectedly overwrites the fix. What technical finding would substantiate this root cause?

  1. Staging API calls fail immediately after the database rename while some clients cannot update overnight.
  2. Predeployment comparison shows the live procedure body differs from the reviewed project model.
  3. Pipeline logs identify the wrong connection target for a reviewed release.
  4. The merge compiles each branch separately but produces conflicting definitions in the combined model.

Explanation

Correct Answer

B:

Predeployment comparison shows the live procedure body differs from the reviewed project model. Schema drift must be detected before a declarative project deployment changes production objects.

Incorrect Answers

A:

Staging API calls fail immediately after the database rename while some clients cannot update overnight. Schema drift must be detected before a declarative project deployment changes production objects. Predeployment comparison shows the live procedure body differs from the reviewed project model.

C:

Pipeline logs identify the wrong connection target for a reviewed release. Schema drift must be detected before a declarative project deployment changes production objects. Predeployment comparison shows the live procedure body differs from the reviewed project model.

D:

The merge compiles each branch separately but produces conflicting definitions in the combined model. Schema drift must be detected before a declarative project deployment changes production objects. Predeployment comparison shows the live procedure body differs from the reviewed project model.

Question 342

A SQL project tracks application tables but lookup status codes are manually edited in production, causing different values across environments. Which technical principle explains the correct response?

  1. Static reference data can be part of database release reproducibility and should be governed.
  2. Database project source code must include secure authorization decisions, not just schema shapes.
  3. Integration tests detect cross-component contracts that isolated builds do not verify.
  4. Automated deployment identities should be scoped to the resources and actions they operate.

Explanation

Correct Answer

A:

Static reference data can be part of database release reproducibility and should be governed.

Incorrect Answers

B:

Database project source code must include secure authorization decisions, not just schema shapes. Static reference data can be part of database release reproducibility and should be governed.

C:

Integration tests detect cross-component contracts that isolated builds do not verify. Static reference data can be part of database release reproducibility and should be governed.

D:

Automated deployment identities should be scoped to the resources and actions they operate. Static reference data can be part of database release reproducibility and should be governed.

Question 343

A frequently executed dashboard query filters a narrow index but retrieves many extra columns through repeated key lookups. What should the database developer do FIRST within approved procedures?

  1. Assess a covering index or query projection change with real selectivity and write overhead.
  2. Choose transactional locking or isolation that enforces the reservation invariant under concurrency.
  3. Use live DMVs, wait information, and deadlock evidence to distinguish blocking chains from actual cyclic deadlocks.
  4. Use an atomic update or optimistic concurrency check to prevent lost updates.

Explanation

Correct Answer

A:

Assess a covering index or query projection change with real selectivity and write overhead. Covering access paths may avoid repeated lookups but extra index width has costs.

Incorrect Answers

B:

Choose transactional locking or isolation that enforces the reservation invariant under concurrency. Covering access paths may avoid repeated lookups but extra index width has costs. Assess a covering index or query projection change with real selectivity and write overhead.

C:

Use live DMVs, wait information, and deadlock evidence to distinguish blocking chains from actual cyclic deadlocks. Covering access paths may avoid repeated lookups but extra index width has costs. Assess a covering index or query projection change with real selectivity and write overhead.

D:

Use an atomic update or optimistic concurrency check to prevent lost updates. Covering access paths may avoid repeated lookups but extra index width has costs. Assess a covering index or query projection change with real selectivity and write overhead.

Question 344

A semantic search endpoint scans every vector on each request even when the dataset has grown to millions of chunks. Which test result would demonstrate the fix worked?

  1. Tenant-specific queries return relevant permitted results within a bounded cost.
  2. A representative query meets latency while returning acceptable nearest-neighbor quality.
  3. Exact product-code queries retrieve their matching rows while conceptual requests remain useful.
  4. The selected retrieval method meets the required accuracy and response-time targets for each workload.

Explanation

Correct Answer

B:

A representative query meets latency while returning acceptable nearest-neighbor quality.

Incorrect Answers

A:

Tenant-specific queries return relevant permitted results within a bounded cost. A representative query meets latency while returning acceptable nearest-neighbor quality.

C:

Exact product-code queries retrieve their matching rows while conceptual requests remain useful. A representative query meets latency while returning acceptable nearest-neighbor quality.

D:

The selected retrieval method meets the required accuracy and response-time targets for each workload. A representative query meets latency while returning acceptable nearest-neighbor quality.

Question 345

An Azure-hosted service connects to Azure SQL with a long-lived database password embedded in a configuration file and rotates credentials infrequently. Which outcome shows the requirement is met without introducing a new risk?

  1. A test privilege change creates a protected timestamped audit record tied to the correct identity.
  2. The application connects with its scoped identity while no reusable database password is stored in code.
  3. Authorized payroll clients read correct values while database operators cannot recover plaintext by ordinary SELECT.
  4. Ordinary operators view masked fields while authorized limited workflows follow explicit permissions.

Explanation

Correct Answer

B:

The application connects with its scoped identity while no reusable database password is stored in code.

Incorrect Answers

A:

A test privilege change creates a protected timestamped audit record tied to the correct identity. The application connects with its scoped identity while no reusable database password is stored in code.

C:

Authorized payroll clients read correct values while database operators cannot recover plaintext by ordinary SELECT. The application connects with its scoped identity while no reusable database password is stored in code.

D:

Ordinary operators view masked fields while authorized limited workflows follow explicit permissions. The application connects with its scoped identity while no reusable database password is stored in code.

Question 346

A developer asks Copilot to fix a production query and reports that the database is repaired because the chat returned corrected code. Which outcome shows the requirement is met without introducing a new risk?

  1. Tests confirm exact expected totals for refunds, null values, and normal billing records.
  2. A reviewed migration is applied through the authorized pipeline and subsequent tests confirm the changed procedure.
  3. New suggestions follow the documented conventions and still pass independent pull-request review.
  4. A permission test limits the tool to permitted read or approved write scopes and blocks forbidden actions.

Explanation

Correct Answer

B:

A reviewed migration is applied through the authorized pipeline and subsequent tests confirm the changed procedure.

Incorrect Answers

A:

Tests confirm exact expected totals for refunds, null values, and normal billing records. A reviewed migration is applied through the authorized pipeline and subsequent tests confirm the changed procedure.

C:

New suggestions follow the documented conventions and still pass independent pull-request review. A reviewed migration is applied through the authorized pipeline and subsequent tests confirm the changed procedure.

D:

A permission test limits the tool to permitted read or approved write scopes and blocks forbidden actions. A reviewed migration is applied through the authorized pipeline and subsequent tests confirm the changed procedure.

Question 347

A developer configures both test and production SQL MCP endpoints with nearly identical names in the same assistant session. What technical finding would substantiate this root cause?

  1. A code review finds customer identifiers and credential-like strings committed alongside instruction markdown.
  2. The suggested indexes improve one sample query but double write latency during batch imports.
  3. Authorized staff cannot access the expected assistant despite seeing it in a marketing demonstration.
  4. A dry-run prompt selects the production connection for an intended test schema query.

Explanation

Correct Answer

D:

A dry-run prompt selects the production connection for an intended test schema query. Tool routing must be unambiguous when an AI assistant can reach multiple data environments.

Incorrect Answers

A:

A code review finds customer identifiers and credential-like strings committed alongside instruction markdown. Tool routing must be unambiguous when an AI assistant can reach multiple data environments. A dry-run prompt selects the production connection for an intended test schema query.

B:

The suggested indexes improve one sample query but double write latency during batch imports. Tool routing must be unambiguous when an AI assistant can reach multiple data environments. A dry-run prompt selects the production connection for an intended test schema query.

C:

Authorized staff cannot access the expected assistant despite seeing it in a marketing demonstration. Tool routing must be unambiguous when an AI assistant can reach multiple data environments. A dry-run prompt selects the production connection for an intended test schema query.

Question 348

A SQL deployment runs a stored procedure that seeds lookup codes and each replay inserts duplicate reference rows. What technical finding would substantiate this root cause?

  1. A plan reused from a selective parameter performs extensive key lookups for the large region.
  2. An injected failure leaves the order header committed while required detail lines are missing.
  3. One service omits a date filter and another returns rows from the wrong tenant.
  4. The second deployment creates more lookup codes than the first although the business catalog is unchanged.

Explanation

Correct Answer

D:

The second deployment creates more lookup codes than the first although the business catalog is unchanged. Database setup scripts should be repeatable across CI and recovery environments.

Incorrect Answers

A:

A plan reused from a selective parameter performs extensive key lookups for the large region. Database setup scripts should be repeatable across CI and recovery environments. The second deployment creates more lookup codes than the first although the business catalog is unchanged.

B:

An injected failure leaves the order header committed while required detail lines are missing. Database setup scripts should be repeatable across CI and recovery environments. The second deployment creates more lookup codes than the first although the business catalog is unchanged.

C:

One service omits a date filter and another returns rows from the wrong tenant. Database setup scripts should be repeatable across CI and recovery environments. The second deployment creates more lookup codes than the first although the business catalog is unchanged.

Question 349

A shipment search API permits filtering on private customer fields that are not part of its documented public data contract. Which technical principle explains the correct response?

  1. Correlated telemetry can reveal failures that resource-average monitoring alone misses.
  2. CDC captures change history that periodic current-state polling can miss.
  3. Protecting data includes constraining searchable predicates as well as displayed columns.
  4. Performance diagnosis should correlate API request complexity with SQL execution work.

Explanation

Correct Answer

C:

Protecting data includes constraining searchable predicates as well as displayed columns.

Incorrect Answers

A:

Correlated telemetry can reveal failures that resource-average monitoring alone misses. Protecting data includes constraining searchable predicates as well as displayed columns.

B:

CDC captures change history that periodic current-state polling can miss. Protecting data includes constraining searchable predicates as well as displayed columns.

D:

Performance diagnosis should correlate API request complexity with SQL execution work. Protecting data includes constraining searchable predicates as well as displayed columns.

Question 350

A mobile inventory API requires a JSON object per warehouse containing an array of item summaries, and string concatenation produces malformed output for quoted names. How should the SQL engineering team confirm the issue is truly resolved?

  1. Reviewers see plausible ranked candidates without automatic merges of unrelated customers.
  2. The emitted payload parses correctly and matches required warehouse/item associations.
  3. Repeated runs produce the expected ranking and tie handling for the same data.
  4. A test payload yields the correct line records and rejects invalid quantities without losing transaction consistency.

Explanation

Correct Answer

B:

The emitted payload parses correctly and matches required warehouse/item associations.

Incorrect Answers

A:

Reviewers see plausible ranked candidates without automatic merges of unrelated customers. The emitted payload parses correctly and matches required warehouse/item associations.

C:

Repeated runs produce the expected ranking and tie handling for the same data. The emitted payload parses correctly and matches required warehouse/item associations.

D:

A test payload yields the correct line records and rejects invalid quantities without losing transaction consistency. The emitted payload parses correctly and matches required warehouse/item associations.

Developing AI-Enabled Database Solutions (DP-800) Practice Tests