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 66
Question 650
A data migration receives a semi-structured comma-separated tag field where individual tags must be validated before loading. What should the database developer do FIRST within approved procedures?
Explanation
Correct Answer
Use supported REGEXP_SPLIT_TO_TABLE or a safe parsing alternative with trimming and invalid-token checks. Converting free-form values to rows requires explicit delimiter and validation semantics.
Incorrect Answers
Evaluate a graph MATCH query against the node and edge model and check result completeness. Converting free-form values to rows requires explicit delimiter and validation semantics. Use supported REGEXP_SPLIT_TO_TABLE or a safe parsing alternative with trimming and invalid-token checks.
Use LAG partitioned by product and ordered by report month, then check handling for missing months. Converting free-form values to rows requires explicit delimiter and validation semantics. Use supported REGEXP_SPLIT_TO_TABLE or a safe parsing alternative with trimming and invalid-token checks.
Use OPENJSON with an explicit schema to expand validated line items into relational rows. Converting free-form values to rows requires explicit delimiter and validation semantics. Use supported REGEXP_SPLIT_TO_TABLE or a safe parsing alternative with trimming and invalid-token checks.
Question 651
A pull request changes a large NVARCHAR column to a smaller type and the deployment tool warns of potential data truncation. Which concept should guide the database developer in this situation?
Explanation
Correct Answer
Schema changes can be structurally valid yet unsafe for existing data.
Incorrect Answers
Automated deployment identities should be scoped to the resources and actions they operate. Schema changes can be structurally valid yet unsafe for existing data.
Deployment configuration and identity should jointly prevent cross-environment mistakes. Schema changes can be structurally valid yet unsafe for existing data.
A database project compiles and validates schema dependencies, not merely stores scripts. Schema changes can be structurally valid yet unsafe for existing data.
Question 652
Developers can push directly to the default branch and deploy payment-table changes without review or security testing. Which corrective action best fits the observed symptoms?
Explanation
Correct Answer
Enforce branch policies, required reviewers, and successful SQL project validation before merge. CI/CD governance starts with source-control policy and controlled approval boundaries.
Incorrect Answers
Reject the broad grant and model only narrowly required role permissions in reviewed project files. CI/CD governance starts with source-control policy and controlled approval boundaries. Enforce branch policies, required reviewers, and successful SQL project validation before merge.
Add unit tests covering normal orders, null inputs, boundary discounts, and rollbacks before deployment. CI/CD governance starts with source-control policy and controlled approval boundaries. Enforce branch policies, required reviewers, and successful SQL project validation before merge.
Configure the supported SDK-style project, dependencies, and build validation in CI. CI/CD governance starts with source-control policy and controlled approval boundaries. Enforce branch policies, required reviewers, and successful SQL project validation before merge.
Question 653
A public inventory endpoint returns an unbounded number of rows and one client can exhaust resources by requesting the entire catalog. Choose TWO statements: a suitable intervention and evidence of its success.
Explanation
Correct Answers
An API test enforces page size and returns deterministic next pages without missing or duplicating items. The accompanying action is to configure appropriate pagination, result limits, and role-level filtering in DAB.
Configure appropriate pagination, result limits, and role-level filtering in DAB. An API test enforces page size and returns deterministic next pages without missing or duplicating items.
Incorrect Answers
Restrict exposed fields and filtering operations to approved entity properties. An API test enforces page size and returns deterministic next pages without missing or duplicating items. Configure appropriate pagination, result limits, and role-level filtering in DAB.
Expose only approved procedure or entity operations through supported DAB configuration with authorization. An API test enforces page size and returns deterministic next pages without missing or duplicating items.
Allowed requests invoke the intended procedure and crafted SQL payloads are rejected. An API test enforces page size and returns deterministic next pages without missing or duplicating items.
Question 654
An IoT staging table includes duplicate device readings and analysts need the latest reading per device without deleting historical evidence. Choose TWO statements: a suitable intervention and evidence of its success.
Explanation
Correct Answers
The query selects exactly one deterministic latest record per device and keeps history intact. An IoT staging table includes duplicate device readings and analysts need the latest reading per device without deleting historical evidence. Use ROW_NUMBER over a device partition with a deterministic timestamp and tie-breaking order.
Use ROW_NUMBER over a device partition with a deterministic timestamp and tie-breaking order. An IoT staging table includes duplicate device readings and analysts need the latest reading per device without deleting historical evidence.
Incorrect Answers
Evaluate a graph MATCH query against the node and edge model and check result completeness. An IoT staging table includes duplicate device readings and analysts need the latest reading per device without deleting historical evidence. Use ROW_NUMBER over a device partition with a deterministic timestamp and tie-breaking order.
Benchmark JARO_WINKLER_DISTANCE or related supported measures against labeled name pairs. An IoT staging table includes duplicate device readings and analysts need the latest reading per device without deleting historical evidence. The query selects exactly one deterministic latest record per device and keeps history intact.
A reviewed query handles absent or malformed values and computes numerical results accurately. An IoT staging table includes duplicate device readings and analysts need the latest reading per device without deleting historical evidence. The query selects exactly one deterministic latest record per device and keeps history intact. Use ROW_NUMBER over a device partition with a deterministic timestamp and tie-breaking order.
Question 655
A customer service team enables temporal history for profile rows but forgets that privacy deletion requests also apply to history. Which outcome shows the requirement is met without introducing a new risk?
Explanation
Correct Answer
The reviewed process handles personal data in both periods according to retention obligations. The operating rule is: Historical convenience does not bypass privacy and records lifecycle requirements.
Incorrect Answers
The targeted query performs a selective seek with fewer reads and without an unacceptable write penalty. The operating rule is: Historical convenience does not bypass privacy and records lifecycle requirements. The reviewed process handles personal data in both periods according to retention obligations.
Malformed inputs are rejected and valid representative payloads remain queryable. The operating rule is: Historical convenience does not bypass privacy and records lifecycle requirements. The reviewed process handles personal data in both periods according to retention obligations.
Queries find the correct risk values with less CPU and no loss of document validity. The operating rule is: Historical convenience does not bypass privacy and records lifecycle requirements. The reviewed process handles personal data in both periods according to retention obligations.
Question 656
A development team runs Data API builder with a local configuration but its production container lacks the approved connection settings and role maps. Which observation is the strongest evidence for the reported problem?
Explanation
Correct Answer
The production service starts with a default configuration missing the intended entity permissions. Deployable API configuration is part of the governed application artifact.
Incorrect Answers
A test can call the DAB backend URL directly without the gateway's identity checks. Deployable API configuration is part of the governed application artifact. The production service starts with a default configuration missing the intended entity permissions.
API discovery lists internal employee and financial tables unrelated to shipment tracking. Deployable API configuration is part of the governed application artifact. The production service starts with a default configuration missing the intended entity permissions.
A test change in a confidential row triggers an unrelated external notification. Deployable API configuration is part of the governed application artifact. The production service starts with a default configuration missing the intended entity permissions.
Question 657
A customer call-center uses Dynamic Data Masking to conceal phone numbers but grants a reporting service an overly privileged login and treats masking as encryption. Which concept should guide the database developer in this situation?
Explanation
Correct Answer
Dynamic Data Masking limits incidental exposure but does not encrypt storage or replace granular authorization.
Incorrect Answers
Passwordless managed identity can reduce secret distribution when authorization is configured correctly. Dynamic Data Masking limits incidental exposure but does not encrypt storage or replace granular authorization.
A friendly UI never substitutes for server-side field and entity access controls. Dynamic Data Masking limits incidental exposure but does not encrypt storage or replace granular authorization.
MCP tools expand the attack surface and require standard service and database authorization. Dynamic Data Masking limits incidental exposure but does not encrypt storage or replace granular authorization.
Question 658
An internal workflow needs a controlled request to invoke a narrowly scoped SQL procedure but developers expose ad hoc SQL execution through REST. Which concept should guide the database developer in this situation?
Explanation
Correct Answer
An API contract should expose bounded domain operations rather than unrestricted SQL execution.
Incorrect Answers
Caching must respect correctness and freshness requirements for mutable business records. An API contract should expose bounded domain operations rather than unrestricted SQL execution.
Event-driven consumers need replay-safe logic even when the source binding tracks changes. An API contract should expose bounded domain operations rather than unrestricted SQL execution.
Performance diagnosis should correlate API request complexity with SQL execution work. An API contract should expose bounded domain operations rather than unrestricted SQL execution.
Question 659
A hybrid search service combines full-text and vector result rankings by adding raw scores that have incompatible scales. Choose TWO: one correct response and one verification of success.
Explanation
Correct Answers
The combined ranking balances relevant candidates from both lists according to measured relevance.
Use reciprocal rank fusion or another validated rank combination approach after separate retrieval stages. The combined ranking balances relevant candidates from both lists according to measured relevance.
Incorrect Answers
Tenant-specific queries return relevant permitted results within a bounded cost. The combined ranking balances relevant candidates from both lists according to measured relevance.
Align index metric, query scoring, and model expectations; validate on labeled relevant pairs. The combined ranking balances relevant candidates from both lists according to measured relevance.
Benchmark a multilingual embedding/retrieval strategy and compare language-specific recall. The combined ranking balances relevant candidates from both lists according to measured relevance.
Question 660
A document search system builds vectors from entire customer records including social identifiers and confidential notes, despite requiring only product descriptions. What technical finding would substantiate this root cause?
Explanation
Correct Answer
Embedding input logs show private identifiers unrelated to the search task. Embedding input selection is part of both relevance engineering and data minimization.
Incorrect Answers
Job logs show throttled responses while the completion report claims all records were embedded. Embedding input selection is part of both relevance engineering and data minimization. Embedding input logs show private identifiers unrelated to the search task.
Client inserts slow down when synchronous model calls run inside the database write path. Embedding input selection is part of both relevance engineering and data minimization. Embedding input logs show private identifiers unrelated to the search task.
The pipeline receives an image input but no compatible image representation is produced. Embedding input selection is part of both relevance engineering and data minimization. Embedding input logs show private identifiers unrelated to the search task.
Developing AI-Enabled Database Solutions (DP-800) Practice Tests
- Microsoft DP-800 Practice Test 64 - 10 Questions (Last Reviewed 10-Nov-2026)
- Microsoft DP-800 Practice Test 65 - 10 Questions (Last Reviewed 09-Nov-2026)
- Microsoft DP-800 Practice Test 66 - 10 Questions (Last Reviewed 08-Nov-2026)
- Microsoft DP-800 Practice Test 67 - 10 Questions (Last Reviewed 07-Nov-2026)
- Microsoft DP-800 Practice Test 68 - 10 Questions (Last Reviewed 06-Nov-2026)