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

Question 140

Several services must assign database-generated batch identifiers without assuming they are gapless when transactions roll back. Which technical principle explains the correct response?

  1. Ledger features provide tamper-evidence verification but do not replace authorization or backups.
  2. Memory-optimized designs address specific concurrency patterns and require explicit durability tradeoffs.
  3. Index alignment and constraints are part of a working partition-maintenance design.
  4. Sequences generate values independently of row identity and do not guarantee gapless numbering.

Explanation

Correct Answer

D:

Sequences generate values independently of row identity and do not guarantee gapless numbering.

Incorrect Answers

A:

Ledger features provide tamper-evidence verification but do not replace authorization or backups. Sequences generate values independently of row identity and do not guarantee gapless numbering.

B:

Memory-optimized designs address specific concurrency patterns and require explicit durability tradeoffs. Sequences generate values independently of row identity and do not guarantee gapless numbering.

C:

Index alignment and constraints are part of a working partition-maintenance design. Sequences generate values independently of row identity and do not guarantee gapless numbering.

Question 141

A SQL Database Project changes a discount procedure but the pipeline has only build success checks and no tests of edge-case numeric outputs. Select TWO: the best action and the outcome that confirms it worked.

  1. The pipeline rejects the faulty change and accepts the corrected procedure with verified results.
  2. Add end-to-end integration tests using compatible staged SQL schema and actual API configuration.
  3. Both old and new clients function through the transition and rollback works in a rehearsed test.
  4. Add unit tests covering normal orders, null inputs, boundary discounts, and rollbacks before deployment.
  5. Parameterize supported deployment settings and enforce environment-scoped identity and target confirmation.

Explanation

Correct Answers

A:

The pipeline rejects the faulty change and accepts the corrected procedure with verified results. Add unit tests covering normal orders, null inputs, boundary discounts, and rollbacks before deployment.

D:

Add unit tests covering normal orders, null inputs, boundary discounts, and rollbacks before deployment.

Incorrect Answers

B:

Add end-to-end integration tests using compatible staged SQL schema and actual API configuration. Add unit tests covering normal orders, null inputs, boundary discounts, and rollbacks before deployment. The pipeline rejects the faulty change and accepts the corrected procedure with verified results.

C:

Both old and new clients function through the transition and rollback works in a rehearsed test. Add unit tests covering normal orders, null inputs, boundary discounts, and rollbacks before deployment. The pipeline rejects the faulty change and accepts the corrected procedure with verified results.

E:

Parameterize supported deployment settings and enforce environment-scoped identity and target confirmation. Add unit tests covering normal orders, null inputs, boundary discounts, and rollbacks before deployment. The pipeline rejects the faulty change and accepts the corrected procedure with verified results.

Question 142

A procedure filters customers by region, usually returns ten rows but occasionally one region contains half the table; a cached plan performs poorly for the outlier. Which corrective action best fits the observed symptoms?

  1. Enforce database-side authorization for the invoking identity and validate tenant access rather than trust the function argument alone.
  2. Design a parameterized inline table-valued function with a verified query plan and security boundary.
  3. Keep granular permissions as the access barrier and implement carefully tested triggers only for appropriate data-change auditing.
  4. Investigate parameter-sensitive plans and choose an engine-supported mitigation after measuring both workloads.

Explanation

Correct Answer

D:

Investigate parameter-sensitive plans and choose an engine-supported mitigation after measuring both workloads. Procedure performance can vary with parameter cardinality even when SQL text is unchanged.

Incorrect Answers

A:

Enforce database-side authorization for the invoking identity and validate tenant access rather than trust the function argument alone. Procedure performance can vary with parameter cardinality even when SQL text is unchanged. Investigate parameter-sensitive plans and choose an engine-supported mitigation after measuring both workloads.

B:

Design a parameterized inline table-valued function with a verified query plan and security boundary. Procedure performance can vary with parameter cardinality even when SQL text is unchanged. Investigate parameter-sensitive plans and choose an engine-supported mitigation after measuring both workloads.

C:

Keep granular permissions as the access barrier and implement carefully tested triggers only for appropriate data-change auditing. Procedure performance can vary with parameter cardinality even when SQL text is unchanged. Investigate parameter-sensitive plans and choose an engine-supported mitigation after measuring both workloads.

Question 143

A team switches between hosted models in a coding assistant and assumes all model endpoints have identical data handling terms. What technical finding would substantiate this root cause?

  1. A dry-run prompt selects the production connection for an intended test schema query.
  2. AI-generated changes repeatedly use direct destructive alterations instead of the required deployment-project workflow.
  3. A test configuration points at an unapproved external model endpoint while developers paste production schema details.
  4. The query explanation shows proposed changes but the database still contains the original stored procedure.

Explanation

Correct Answer

C:

A test configuration points at an unapproved external model endpoint while developers paste production schema details. Model choice is part of data governance, not merely a response-quality preference.

Incorrect Answers

A:

A dry-run prompt selects the production connection for an intended test schema query. Model choice is part of data governance, not merely a response-quality preference. A test configuration points at an unapproved external model endpoint while developers paste production schema details.

B:

AI-generated changes repeatedly use direct destructive alterations instead of the required deployment-project workflow. Model choice is part of data governance, not merely a response-quality preference. A test configuration points at an unapproved external model endpoint while developers paste production schema details.

D:

The query explanation shows proposed changes but the database still contains the original stored procedure. Model choice is part of data governance, not merely a response-quality preference. A test configuration points at an unapproved external model endpoint while developers paste production schema details.

Question 144

A procedure posts an invoice and then calls a failing validation routine; the customer balance remains changed because the error is swallowed. What should the database developer verify to confirm the suspected cause?

  1. Rows containing empty or whitespace-only tags cause incorrect references after import.
  2. Sample narratives show a token appearing in quoted prose but not as an actual tag.
  3. A deliberately invalid item raises an error but leaves an altered ledger balance.
  4. The database stores one row per shipment but cannot query per-item quantities or product codes.

Explanation

Correct Answer

C:

A deliberately invalid item raises an error but leaves an altered ledger balance. T-SQL error handling must preserve transaction atomicity rather than merely log exceptions.

Incorrect Answers

A:

Rows containing empty or whitespace-only tags cause incorrect references after import. T-SQL error handling must preserve transaction atomicity rather than merely log exceptions. A deliberately invalid item raises an error but leaves an altered ledger balance.

B:

Sample narratives show a token appearing in quoted prose but not as an actual tag. T-SQL error handling must preserve transaction atomicity rather than merely log exceptions. A deliberately invalid item raises an error but leaves an altered ledger balance.

D:

The database stores one row per shipment but cannot query per-item quantities or product codes. T-SQL error handling must preserve transaction atomicity rather than merely log exceptions. A deliberately invalid item raises an error but leaves an altered ledger balance.

Question 145

An operator hot-fixes a production stored procedure outside version control and the next release unexpectedly overwrites the fix. Which TWO options together specify a corrective step and a meaningful test?

  1. Require appropriate protected branches, successful CI, environment approvals, and traceable release gates.
  2. A staging API test executes representative authorized queries against deployed schema before promotion.
  3. The drift is reviewed, either incorporated or reverted, and deployment reports no unexplained difference.
  4. Use schema drift detection against the authoritative SQL Database Project and reconcile the change before deployment.
  5. Add unit tests covering normal orders, null inputs, boundary discounts, and rollbacks before deployment.

Explanation

Correct Answers

C:

The drift is reviewed, either incorporated or reverted, and deployment reports no unexplained difference. Use schema drift detection against the authoritative SQL Database Project and reconcile the change before deployment.

D:

Use schema drift detection against the authoritative SQL Database Project and reconcile the change before deployment.

Incorrect Answers

A:

Require appropriate protected branches, successful CI, environment approvals, and traceable release gates. Use schema drift detection against the authoritative SQL Database Project and reconcile the change before deployment. The drift is reviewed, either incorporated or reverted, and deployment reports no unexplained difference.

B:

A staging API test executes representative authorized queries against deployed schema before promotion. Use schema drift detection against the authoritative SQL Database Project and reconcile the change before deployment. The drift is reviewed, either incorporated or reverted, and deployment reports no unexplained difference.

E:

Add unit tests covering normal orders, null inputs, boundary discounts, and rollbacks before deployment. Use schema drift detection against the authoritative SQL Database Project and reconcile the change before deployment. The drift is reviewed, either incorporated or reverted, and deployment reports no unexplained difference.

Question 146

A customer service team enables temporal history for profile rows but forgets that privacy deletion requests also apply to history. Which corrective action best fits the observed symptoms?

  1. Use a suitable native JSON type or a validity check supported on the target database engine.
  2. Assess supported external table capabilities and data-source credentials for the chosen SQL platform.
  3. Design a governed temporal retention and deletion procedure across current and historical data.
  4. Evaluate normalized, JSON, or sparse-column designs against actual query needs and engine support.

Explanation

Correct Answer

C:

Design a governed temporal retention and deletion procedure across current and historical data. Historical convenience does not bypass privacy and records lifecycle requirements.

Incorrect Answers

A:

Use a suitable native JSON type or a validity check supported on the target database engine. Historical convenience does not bypass privacy and records lifecycle requirements. Design a governed temporal retention and deletion procedure across current and historical data.

B:

Assess supported external table capabilities and data-source credentials for the chosen SQL platform. Historical convenience does not bypass privacy and records lifecycle requirements. Design a governed temporal retention and deletion procedure across current and historical data.

D:

Evaluate normalized, JSON, or sparse-column designs against actual query needs and engine support. Historical convenience does not bypass privacy and records lifecycle requirements. Design a governed temporal retention and deletion procedure across current and historical data.

Question 147

A team deploys DAB behind a gateway and assumes the backend is safe because the gateway normally authenticates users. What is the underlying reason for the corrective step?

  1. Low-code automation must still enforce event selection, recipient controls, and auditability.
  2. Change event streaming separates producer tables from subscriber access when correctly configured.
  3. API gateways do not automatically secure bypassable backend endpoints.
  4. Protecting data includes constraining searchable predicates as well as displayed columns.

Explanation

Correct Answer

C:

API gateways do not automatically secure bypassable backend endpoints.

Incorrect Answers

A:

Low-code automation must still enforce event selection, recipient controls, and auditability. API gateways do not automatically secure bypassable backend endpoints.

B:

Change event streaming separates producer tables from subscriber access when correctly configured. API gateways do not automatically secure bypassable backend endpoints.

D:

Protecting data includes constraining searchable predicates as well as displayed columns. API gateways do not automatically secure bypassable backend endpoints.

Question 148

A database project adds a broad GRANT SELECT to PUBLIC because a generated SQL suggestion says it simplifies application connectivity. What should the database developer verify to confirm the suspected cause?

  1. Clean-build logs show an unresolved referenced object while the local workstation builds.
  2. A staged test user can query sensitive salary columns without being assigned an appropriate role.
  3. The repository contains SQL objects but no successful project build artifact or referenced model resolution.
  4. Staging rows contain values longer than the proposed target length.

Explanation

Correct Answer

B:

A staged test user can query sensitive salary columns without being assigned an appropriate role. Database project source code must include secure authorization decisions, not just schema shapes.

Incorrect Answers

A:

Clean-build logs show an unresolved referenced object while the local workstation builds. Database project source code must include secure authorization decisions, not just schema shapes. A staged test user can query sensitive salary columns without being assigned an appropriate role.

C:

The repository contains SQL objects but no successful project build artifact or referenced model resolution. Database project source code must include secure authorization decisions, not just schema shapes. A staged test user can query sensitive salary columns without being assigned an appropriate role.

D:

Staging rows contain values longer than the proposed target length. Database project source code must include secure authorization decisions, not just schema shapes. A staged test user can query sensitive salary columns without being assigned an appropriate role.

Question 149

A T-SQL workflow builds a prompt for an external language model but includes every row and confidential identifier regardless of question scope. Which observation is the strongest evidence for the reported problem?

  1. Inspection shows the outbound JSON contains unrelated customer identifiers from the table.
  2. The model proposes changing an invoice amount solely because the customer comment said to.
  3. Requests exceed model context budgets and irrelevant chunks dominate the prompt.
  4. During review the team cannot tell which policy revision or model produced an earlier recommendation.

Explanation

Correct Answer

A:

Inspection shows the outbound JSON contains unrelated customer identifiers from the table. External REST calls from SQL must minimize disclosed data and enforce endpoint security.

Incorrect Answers

B:

The model proposes changing an invoice amount solely because the customer comment said to. External REST calls from SQL must minimize disclosed data and enforce endpoint security. Inspection shows the outbound JSON contains unrelated customer identifiers from the table.

C:

Requests exceed model context budgets and irrelevant chunks dominate the prompt. External REST calls from SQL must minimize disclosed data and enforce endpoint security. Inspection shows the outbound JSON contains unrelated customer identifiers from the table.

D:

During review the team cannot tell which policy revision or model produced an earlier recommendation. External REST calls from SQL must minimize disclosed data and enforce endpoint security. Inspection shows the outbound JSON contains unrelated customer identifiers from the table.

Question 150

A finance report repeats a complicated eligibility expression in several joins and inconsistent copies give different quarter totals. Select TWO: the best action and the outcome that confirms it worked.

  1. Evaluate REGEXP_REPLACE with a narrowly tested account-token pattern and independent sensitive-data detection.
  2. Use a common table expression to define the intermediate eligible set once and validate its filters.
  3. The revised query uses one reviewed eligibility definition and reconciles all quarter totals.
  4. Use LAG partitioned by product and ordered by report month, then check handling for missing months.
  5. The validation error results in a fully consistent rollback and a diagnostic error response.

Explanation

Correct Answers

B:

Use a common table expression to define the intermediate eligible set once and validate its filters. The revised query uses one reviewed eligibility definition and reconciles all quarter totals.

C:

The revised query uses one reviewed eligibility definition and reconciles all quarter totals. The accompanying action is to use a common table expression to define the intermediate eligible set once and validate its filters.

Incorrect Answers

A:

Evaluate REGEXP_REPLACE with a narrowly tested account-token pattern and independent sensitive-data detection. The revised query uses one reviewed eligibility definition and reconciles all quarter totals. Use a common table expression to define the intermediate eligible set once and validate its filters.

D:

Use LAG partitioned by product and ordered by report month, then check handling for missing months. The revised query uses one reviewed eligibility definition and reconciles all quarter totals. Use a common table expression to define the intermediate eligible set once and validate its filters.

E:

The validation error results in a fully consistent rollback and a diagnostic error response. The revised query uses one reviewed eligibility definition and reconciles all quarter totals.

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