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 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?
Explanation
Correct Answer
Sequences generate values independently of row identity and do not guarantee gapless numbering.
Incorrect Answers
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.
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.
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.
Explanation
Correct Answers
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.
Add unit tests covering normal orders, null inputs, boundary discounts, and rollbacks before deployment.
Incorrect Answers
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.
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.
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?
Explanation
Correct Answer
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
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.
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.
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?
Explanation
Correct Answer
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 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.
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.
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?
Explanation
Correct Answer
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
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.
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.
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?
Explanation
Correct Answers
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.
Use schema drift detection against the authoritative SQL Database Project and reconcile the change before deployment.
Incorrect Answers
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.
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.
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?
Explanation
Correct Answer
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
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.
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.
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?
Explanation
Correct Answer
API gateways do not automatically secure bypassable backend endpoints.
Incorrect Answers
Low-code automation must still enforce event selection, recipient controls, and auditability. API gateways do not automatically secure bypassable backend endpoints.
Change event streaming separates producer tables from subscriber access when correctly configured. API gateways do not automatically secure bypassable backend endpoints.
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?
Explanation
Correct Answer
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
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.
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.
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?
Explanation
Correct Answer
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
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.
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.
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.
Explanation
Correct Answers
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.
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
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.
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.
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
- Microsoft DP-800 Practice Test 13 - 10 Questions (Last Reviewed 04-Nov-2026)
- Microsoft DP-800 Practice Test 14 - 10 Questions (Last Reviewed 03-Nov-2026)
- Microsoft DP-800 Practice Test 15 - 10 Questions (Last Reviewed 02-Nov-2026)
- Microsoft DP-800 Practice Test 16 - 10 Questions (Last Reviewed 01-Nov-2026)
- Microsoft DP-800 Practice Test 17 - 10 Questions (Last Reviewed 31-Oct-2026)