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 28
Question 270
A SQL deployment runs a stored procedure that seeds lookup codes and each replay inserts duplicate reference rows. What would be a valid post-database-change verification?
Explanation
Correct Answer
Running the same deployment twice produces the expected reference rows without duplication.
Incorrect Answers
A clean rebuild and incremental deployment produce identical authorized lookup mappings. Running the same deployment twice produces the expected reference rows without duplication.
Tests return the same correctly scoped rows for all clients without a substantial plan regression. Running the same deployment twice produces the expected reference rows without duplication.
Unauthorized selects are blocked by permissions and legitimate data changes produce reliable audit records. Running the same deployment twice produces the expected reference rows without duplication.
Question 271
A distributed team uses GitHub Copilot for SQL project changes but suggestions repeatedly violate the team's migration and naming conventions. How should the SQL engineering team confirm the issue is truly resolved?
Explanation
Correct Answer
New suggestions follow the documented conventions and still pass independent pull-request review. A distributed team uses GitHub Copilot for SQL project changes but suggestions repeatedly violate the team's migration and naming conventions.
Incorrect Answers
The tool returns only approved lakehouse metadata and rejects unauthorized workspace access. A distributed team uses GitHub Copilot for SQL project changes but suggestions repeatedly violate the team's migration and naming conventions. New suggestions follow the documented conventions and still pass independent pull-request review.
Approved sessions use an allowed endpoint and unapproved configurations are blocked or corrected. A distributed team uses GitHub Copilot for SQL project changes but suggestions repeatedly violate the team's migration and naming conventions. New suggestions follow the documented conventions and still pass independent pull-request review.
The assisted workflow operates against the expected test environment and refuses unapproved production operations. A distributed team uses GitHub Copilot for SQL project changes but suggestions repeatedly violate the team's migration and naming conventions. New suggestions follow the documented conventions and still pass independent pull-request review.
Question 272
A billing dashboard needs a cumulative balance by account across transaction dates and the current solution recalculates all preceding rows in correlated subqueries. Which next step most directly resolves this SQL solution issue?
Explanation
Correct Answer
Use a suitable SUM window ordered by transaction event and a deterministic secondary key. Ordered window aggregates express running calculations without repeated per-row rescans.
Incorrect Answers
Use supported edit-distance similarity functions to rank candidates and preserve a human confirmation step. Ordered window aggregates express running calculations without repeated per-row rescans. Use a suitable SUM window ordered by transaction event and a deterministic secondary key.
Use an appropriate window rank and secondary order according to the published tie rule. Ordered window aggregates express running calculations without repeated per-row rescans. Use a suitable SUM window ordered by transaction event and a deterministic secondary key.
Use a common table expression to define the intermediate eligible set once and validate its filters. Ordered window aggregates express running calculations without repeated per-row rescans. Use a suitable SUM window ordered by transaction event and a deterministic secondary key.
Question 273
A GitHub Copilot chat connects to a SQL MCP server configured with a broad administrator identity and developers plan to run generated queries against production. Which outcome shows the requirement is met without introducing a new risk?
Explanation
Correct Answer
A permission test limits the tool to permitted read or approved write scopes and blocks forbidden actions.
Incorrect Answers
A negative tenant-access test fails safely while approved queries retain correct row scope and performance. A permission test limits the tool to permitted read or approved write scopes and blocks forbidden actions.
The instruction file remains useful without protected records or live secrets, and scanners pass. A permission test limits the tool to permitted read or approved write scopes and blocks forbidden actions.
A selected index improves target queries without breaching transactional and storage budgets. A permission test limits the tool to permitted read or approved write scopes and blocks forbidden actions.
Question 274
A Data API builder endpoint accepts unvalidated client-side tenant parameters while backend queries use an all-tenant database identity. Which clue best distinguishes this issue from similar incidents?
Explanation
Correct Answer
Changing a query parameter returns records for another tenant in a replay test. Security boundaries must be enforced even when clients can freely modify requests.
Incorrect Answers
A test login with broad permissions can still see original values despite masking being configured. Security boundaries must be enforced even when clients can freely modify requests. Changing a query parameter returns records for another tenant in a replay test.
A test role derives confidential values through unrestricted filters despite seeing masked display columns. Security boundaries must be enforced even when clients can freely modify requests. Changing a query parameter returns records for another tenant in a replay test.
A nearest-neighbor query or reconstruction-related audit reveals sensitive customer-derived content in search results. Security boundaries must be enforced even when clients can freely modify requests. Changing a query parameter returns records for another tenant in a replay test.
Question 275
A CRM team compares names with common prefix and transcription variations and wants an explainable candidate ranking. Which technical principle explains the correct response?
Explanation
Correct Answer
String similarity metrics have different sensitivities and must be matched to actual data.
Incorrect Answers
JSON_VALUE returns scalar text semantics, so downstream typing should match the intended operation. String similarity metrics have different sensitivities and must be matched to actual data.
Regular expressions are useful for pattern-based text operations but require careful definitions and performance tests. String similarity metrics have different sensitivities and must be matched to actual data.
T-SQL error handling must preserve transaction atomicity rather than merely log exceptions. String similarity metrics have different sensitivities and must be matched to actual data.
Question 276
A Data API builder release works with mocked SQL queries but fails in staging because its real entity mapping differs from deployed database schema. What is the underlying reason for the corrective step?
Explanation
Correct Answer
Integration tests detect cross-component contracts that isolated builds do not verify.
Incorrect Answers
Schema evolution should account for clients with independent deployment cycles. Integration tests detect cross-component contracts that isolated builds do not verify.
Schema drift must be detected before a declarative project deployment changes production objects. Integration tests detect cross-component contracts that isolated builds do not verify.
CI/CD governance starts with source-control policy and controlled approval boundaries. Integration tests detect cross-component contracts that isolated builds do not verify.
Question 277
A warehouse wants ordered row changes including before-and-after data for a reporting feed, and current timestamp polling misses rapid updates. Choose TWO statements: a suitable intervention and evidence of its success.
Explanation
Correct Answers
Evaluate SQL change data capture availability and retention with a durable consumer checkpoint.
The feed reproduces intended changes in order and survives a consumer restart. Evaluate SQL change data capture availability and retention with a durable consumer checkpoint.
Incorrect Answers
Require and test appropriate service-level authentication and network restrictions at every reachable endpoint. Evaluate SQL change data capture availability and retention with a durable consumer checkpoint. The feed reproduces intended changes in order and survives a consumer restart.
Define a narrowly scoped DAB configuration with explicit entities, operations, and role-based permissions. Evaluate SQL change data capture availability and retention with a durable consumer checkpoint. The feed reproduces intended changes in order and survives a consumer restart.
A test request can be traced across API and SQL dependencies to the failing span. Evaluate SQL change data capture availability and retention with a durable consumer checkpoint. The feed reproduces intended changes in order and survives a consumer restart.
Question 278
A pull request changes a large NVARCHAR column to a smaller type and the deployment tool warns of potential data truncation. Which corrective action best fits the observed symptoms?
Explanation
Correct Answer
Block promotion until data impact and an approved migration strategy are verified. Schema changes can be structurally valid yet unsafe for existing data.
Incorrect Answers
Add a versioned compatible database-model reference and restore dependencies in a clean environment. Schema changes can be structurally valid yet unsafe for existing data. Block promotion until data impact and an approved migration strategy are verified.
Parameterize supported deployment settings and enforce environment-scoped identity and target confirmation. Schema changes can be structurally valid yet unsafe for existing data. Block promotion until data impact and an approved migration strategy are verified.
Version reference data in a reviewed idempotent deployment process with migration tests. Schema changes can be structurally valid yet unsafe for existing data. Block promotion until data impact and an approved migration strategy are verified.
Question 279
An ecommerce API filters orders by tenant and status then sorts by creation time but its primary-key index alone does not support that access path. What distinction makes the recommended approach appropriate?
Explanation
Correct Answer
Indexes should match useful predicates and sort requirements rather than being added indiscriminately.
Incorrect Answers
Historical convenience does not bypass privacy and records lifecycle requirements. Indexes should match useful predicates and sort requirements rather than being added indiscriminately.
Columnstore storage can improve scan-heavy analytics but its operational tradeoffs must be tested. Indexes should match useful predicates and sort requirements rather than being added indiscriminately.
Temporal history tracks row versions for point-in-time inspection rather than relying on audit guesses. Indexes should match useful predicates and sort requirements rather than being added indiscriminately.
Question 280
An administrator uses a DML trigger to log unauthorized table changes and assumes the trigger alone prevents data exfiltration. Which technical principle explains the correct response?
Explanation
Correct Answer
Triggers can react to data modifications but are not a substitute for least-privilege reads.
Incorrect Answers
Table-valued functions encapsulate reusable relational logic and must be tested for parameter behavior. Triggers can react to data modifications but are not a substitute for least-privilege reads.
Triggers execute within database write workflows and need safeguards against recursion and broad unintended effects. Triggers can react to data modifications but are not a substitute for least-privilege reads.
A stored procedure can enforce a coherent transaction boundary for related database changes. Triggers can react to data modifications but are not a substitute for least-privilege reads.
Developing AI-Enabled Database Solutions (DP-800) Practice Tests
- Microsoft DP-800 Practice Test 26 - 10 Questions (Last Reviewed 22-Oct-2026)
- Microsoft DP-800 Practice Test 27 - 10 Questions (Last Reviewed 21-Oct-2026)
- Microsoft DP-800 Practice Test 28 - 10 Questions (Last Reviewed 20-Oct-2026)
- Microsoft DP-800 Practice Test 29 - 10 Questions (Last Reviewed 19-Oct-2026)
- Microsoft DP-800 Practice Test 30 - 10 Questions (Last Reviewed 18-Oct-2026)