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 61
Question 600
A finance platform wants SQL records from supplier invoices, but its chosen general chat model outputs inconsistent field names and free-form commentary. Which next step most directly resolves this SQL solution issue?
Explanation
Correct Answer
Benchmark a suitable supported model for structured output on representative invoices and enforce schema validation. Model choice should match structured output requirements rather than general language fluency alone.
Incorrect Answers
Design section-aware chunks with appropriate overlap and metadata, then measure answer evidence coverage. Model choice should match structured output requirements rather than general language fluency alone. Benchmark a suitable supported model for structured output on representative invoices and enforce schema validation.
Use Change Tracking or another supported change signal to queue reliable re-embedding of modified source records. Model choice should match structured output requirements rather than general language fluency alone. Benchmark a suitable supported model for structured output on representative invoices and enforce schema validation.
Evaluate multilingual embedding models against labeled cross-language retrieval tests and relevant privacy constraints. Model choice should match structured output requirements rather than general language fluency alone. Benchmark a suitable supported model for structured output on representative invoices and enforce schema validation.
Question 601
A support application builds a vector index using one distance metric while the embedding model recommendations and offline tests use another. Which outcome shows the requirement is met without introducing a new risk?
Explanation
Correct Answer
The deployed index and benchmark use the same metric and meet target relevance. The operating rule is: Vector indexes must apply consistent distance semantics from training evaluation to retrieval.
Incorrect Answers
Language-sliced tests retrieve authorized relevant records with accepted coverage. The operating rule is: Vector indexes must apply consistent distance semantics from training evaluation to retrieval. The deployed index and benchmark use the same metric and meet target relevance.
Relevant terms are found with improved latency and accepted linguistic precision. The operating rule is: Vector indexes must apply consistent distance semantics from training evaluation to retrieval. The deployed index and benchmark use the same metric and meet target relevance.
Exact product-code queries retrieve their matching rows while conceptual requests remain useful. The operating rule is: Vector indexes must apply consistent distance semantics from training evaluation to retrieval. The deployed index and benchmark use the same metric and meet target relevance.
Question 602
A SQL deployment runs a stored procedure that seeds lookup codes and each replay inserts duplicate reference rows. Which TWO options together specify a corrective step and a meaningful test?
Explanation
Correct Answers
Running the same deployment twice produces the expected reference rows without duplication. Make reference-data seeding idempotent using stable keys and transactional checks.
Make reference-data seeding idempotent using stable keys and transactional checks.
Incorrect Answers
A one-row and batch update test each produce only expected changes with bounded trigger work. Make reference-data seeding idempotent using stable keys and transactional checks. Running the same deployment twice produces the expected reference rows without duplication.
Assess supported scalar UDF inlining or rewrite the computation into a set-based expression. Make reference-data seeding idempotent using stable keys and transactional checks. Running the same deployment twice produces the expected reference rows without duplication.
Use a stored procedure with an explicit transaction, input validation, and appropriate error handling. Make reference-data seeding idempotent using stable keys and transactional checks. Running the same deployment twice produces the expected reference rows without duplication.
Question 603
A regulated organization's pipeline automatically deploys SQL schema changes to production immediately when a developer pushes to a feature branch. Which observation is the strongest evidence for the reported problem?
Explanation
Correct Answer
An unreviewed branch commit triggers a production database publish with no named approver. Database CI/CD needs separation of development activity from production authorization.
Incorrect Answers
Repository history and build logs still contain the old secret even after the most recent file changes. Database CI/CD needs separation of development activity from production authorization. An unreviewed branch commit triggers a production database publish with no named approver.
An unreviewed commit lands in the release branch despite failing a required migration test. Database CI/CD needs separation of development activity from production authorization. An unreviewed branch commit triggers a production database publish with no named approver.
The repository contains SQL objects but no successful project build artifact or referenced model resolution. Database CI/CD needs separation of development activity from production authorization. An unreviewed branch commit triggers a production database publish with no named approver.
Question 604
A billing dashboard needs a cumulative balance by account across transaction dates and the current solution recalculates all preceding rows in correlated subqueries. Which test result would demonstrate the fix worked?
Explanation
Correct Answer
A test reconciles cumulative balances with the ledger using explicit ordering.
Incorrect Answers
Every product row matches the latest approved price in its own region as of the test date. A test reconciles cumulative balances with the ledger using explicit ordering.
The report labels missing prior observations and computes deltas only when a comparison exists. A test reconciles cumulative balances with the ledger using explicit ordering.
The query selects exactly one deterministic latest record per device and keeps history intact. A test reconciles cumulative balances with the ledger using explicit ordering.
Question 605
Developers can push directly to the default branch and deploy payment-table changes without review or security testing. Which concept should guide the database developer in this situation?
Explanation
Correct Answer
CI/CD governance starts with source-control policy and controlled approval boundaries.
Incorrect Answers
A database project compiles and validates schema dependencies, not merely stores scripts. CI/CD governance starts with source-control policy and controlled approval boundaries.
Schema changes can be structurally valid yet unsafe for existing data. CI/CD governance starts with source-control policy and controlled approval boundaries.
Schema evolution should account for clients with independent deployment cycles. CI/CD governance starts with source-control policy and controlled approval boundaries.
Question 606
A high-volume retail database must publish changes to downstream near-real-time consumers without exposing operational credentials to every subscriber. Which outcome shows the requirement is met without introducing a new risk?
Explanation
Correct Answer
Consumers receive authorized change events and cannot read unrelated database records.
Incorrect Answers
The endpoint rejects unapproved filters and returns correct authorized shipment matches. Consumers receive authorized change events and cannot read unrelated database records.
A client retrieves only changed keys since its saved version and safely handles retention gaps. Consumers receive authorized change events and cannot read unrelated database records.
A test request can be traced across API and SQL dependencies to the failing span. Consumers receive authorized change events and cannot read unrelated database records.
Question 607
An Azure Function reacts to SQL changes and sometimes processes the same event more than once after retries. What should the database developer do FIRST within approved procedures?
Explanation
Correct Answer
Implement idempotent event handling and durable progress controls for the SQL trigger binding. Event-driven consumers need replay-safe logic even when the source binding tracks changes.
Incorrect Answers
Define a narrowly scoped DAB configuration with explicit entities, operations, and role-based permissions. Event-driven consumers need replay-safe logic even when the source binding tracks changes. Implement idempotent event handling and durable progress controls for the SQL trigger binding.
Capture API query shapes and SQL dependency telemetry before scaling hardware. Event-driven consumers need replay-safe logic even when the source binding tracks changes. Implement idempotent event handling and durable progress controls for the SQL trigger binding.
Require and test appropriate service-level authentication and network restrictions at every reachable endpoint. Event-driven consumers need replay-safe logic even when the source binding tracks changes. Implement idempotent event handling and durable progress controls for the SQL trigger binding.
Question 608
A pricing service caches DAB responses but customers continue receiving superseded prices after a time-sensitive promotion update. What would be a valid post-database-change verification?
Explanation
Correct Answer
The service returns current approved prices within the agreed freshness interval after a change. The operating rule is: Caching must respect correctness and freshness requirements for mutable business records.
Incorrect Answers
A clean deployment uses the reviewed configuration, passes tests, and stores no credentials in the image. The operating rule is: Caching must respect correctness and freshness requirements for mutable business records. The service returns current approved prices within the agreed freshness interval after a change.
A test request can be traced across API and SQL dependencies to the failing span. The operating rule is: Caching must respect correctness and freshness requirements for mutable business records. The service returns current approved prices within the agreed freshness interval after a change.
Consumers receive authorized change events and cannot read unrelated database records. The operating rule is: Caching must respect correctness and freshness requirements for mutable business records. The service returns current approved prices within the agreed freshness interval after a change.
Question 609
An internal workflow needs a controlled request to invoke a narrowly scoped SQL procedure but developers expose ad hoc SQL execution through REST. Which outcome shows the requirement is met without introducing a new risk?
Explanation
Correct Answer
Allowed requests invoke the intended procedure and crafted SQL payloads are rejected. The operating rule is: An API contract should expose bounded domain operations rather than unrestricted SQL execution.
Incorrect Answers
Consumers receive authorized change events and cannot read unrelated database records. The operating rule is: An API contract should expose bounded domain operations rather than unrestricted SQL execution. Allowed requests invoke the intended procedure and crafted SQL payloads are rejected.
A clean deployment uses the reviewed configuration, passes tests, and stores no credentials in the image. The operating rule is: An API contract should expose bounded domain operations rather than unrestricted SQL execution. Allowed requests invoke the intended procedure and crafted SQL payloads are rejected.
An authorized nested query returns correct variants while excluded records remain inaccessible. The operating rule is: An API contract should expose bounded domain operations rather than unrestricted SQL execution. Allowed requests invoke the intended procedure and crafted SQL payloads are rejected.
Question 610
An administrator uses a DML trigger to log unauthorized table changes and assumes the trigger alone prevents data exfiltration. Choose TWO: one correct response and one verification of success.
Explanation
Correct Answers
Unauthorized selects are blocked by permissions and legitimate data changes produce reliable audit records. Keep granular permissions as the access barrier and implement carefully tested triggers only for appropriate data-change auditing.
Keep granular permissions as the access barrier and implement carefully tested triggers only for appropriate data-change auditing.
Incorrect Answers
Enforce database-side authorization for the invoking identity and validate tenant access rather than trust the function argument alone. Keep granular permissions as the access barrier and implement carefully tested triggers only for appropriate data-change auditing. Unauthorized selects are blocked by permissions and legitimate data changes produce reliable audit records.
Create an appropriately permissioned view that projects only authorized aggregated fields. Keep granular permissions as the access barrier and implement carefully tested triggers only for appropriate data-change auditing. Unauthorized selects are blocked by permissions and legitimate data changes produce reliable audit records.
The service can query approved totals and receives an authorization error for direct sensitive table reads. Keep granular permissions as the access barrier and implement carefully tested triggers only for appropriate data-change auditing. Unauthorized selects are blocked by permissions and legitimate data changes produce reliable audit records.
Developing AI-Enabled Database Solutions (DP-800) Practice Tests
- Microsoft DP-800 Practice Test 59 - 10 Questions (Last Reviewed 15-Nov-2026)
- Microsoft DP-800 Practice Test 60 - 10 Questions (Last Reviewed 14-Nov-2026)
- Microsoft DP-800 Practice Test 61 - 10 Questions (Last Reviewed 13-Nov-2026)
- Microsoft DP-800 Practice Test 62 - 10 Questions (Last Reviewed 12-Nov-2026)
- Microsoft DP-800 Practice Test 63 - 10 Questions (Last Reviewed 11-Nov-2026)