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 40
Question 390
An API accepts arbitrary malformed JSON in a text field and downstream reporting intermittently fails during JSON parsing. Which technical principle explains the correct response?
Explanation
Correct Answer
Data shape and validity should be enforced as close to ingestion as practical.
Incorrect Answers
Columnstore health depends on ingestion and modification patterns as well as index creation. Data shape and validity should be enforced as close to ingestion as practical.
A graph model can express connected entities but it is not automatically better for simple relational lookups. Data shape and validity should be enforced as close to ingestion as practical.
Ledger features provide tamper-evidence verification but do not replace authorization or backups. Data shape and validity should be enforced as close to ingestion as practical.
Question 391
A commerce API receives order metadata JSON and analysts need a numeric discount for calculations, but lexical comparisons sort values incorrectly. What should the database developer do FIRST within approved procedures?
Explanation
Correct Answer
Extract the required JSON property and convert it to an appropriate numeric type with invalid-data handling. JSON_VALUE returns scalar text semantics, so downstream typing should match the intended operation.
Incorrect Answers
Use a supported REGEXP_SUBSTR or related regex operation with input validation and cost review. JSON_VALUE returns scalar text semantics, so downstream typing should match the intended operation. Extract the required JSON property and convert it to an appropriate numeric type with invalid-data handling.
Use LAG partitioned by product and ordered by report month, then check handling for missing months. JSON_VALUE returns scalar text semantics, so downstream typing should match the intended operation. Extract the required JSON property and convert it to an appropriate numeric type with invalid-data handling.
Use a properly correlated subquery or APPLY pattern that ties price, region, approval status, and effective date together. JSON_VALUE returns scalar text semantics, so downstream typing should match the intended operation. Extract the required JSON property and convert it to an appropriate numeric type with invalid-data handling.
Question 392
A developer commits an Azure SQL connection string with a password into a pipeline YAML and then deletes the line after review. Which observation is the strongest evidence for the reported problem?
Explanation
Correct Answer
Repository history and build logs still contain the old secret even after the most recent file changes. Deleting a committed secret does not remove the exposure or replace credential rotation.
Incorrect Answers
Pipeline logs identify the wrong connection target for a reviewed release. Deleting a committed secret does not remove the exposure or replace credential rotation. Repository history and build logs still contain the old secret even after the most recent file changes.
A code review finds an untested branch that grants excessive discounts when a value is missing. Deleting a committed secret does not remove the exposure or replace credential rotation. Repository history and build logs still contain the old secret even after the most recent file changes.
The repository contains SQL objects but no successful project build artifact or referenced model resolution. Deleting a committed secret does not remove the exposure or replace credential rotation. Repository history and build logs still contain the old secret even after the most recent file changes.
Question 393
An administrator schedules frequent index rebuilds solely because a table is large and claims that rebuilds always improve application latency. Choose TWO statements: a suitable intervention and evidence of its success.
Explanation
Correct Answers
A selective maintenance plan avoids unnecessary work and preserves measured query service goal. Measure actual fragmentation, page density, workload plans, and maintenance impact before a rebuild policy.
Measure actual fragmentation, page density, workload plans, and maintenance impact before a rebuild policy.
Incorrect Answers
Assess a covering index or query projection change with real selectivity and write overhead. Measure actual fragmentation, page density, workload plans, and maintenance impact before a rebuild policy. A selective maintenance plan avoids unnecessary work and preserves measured query service goal.
Under concurrent replay at most one valid reservation commits and a clear retry result reaches the other caller. Measure actual fragmentation, page density, workload plans, and maintenance impact before a rebuild policy. A selective maintenance plan avoids unnecessary work and preserves measured query service goal.
Use an atomic update or optimistic concurrency check to prevent lost updates. Measure actual fragmentation, page density, workload plans, and maintenance impact before a rebuild policy. A selective maintenance plan avoids unnecessary work and preserves measured query service goal.
Question 394
A multiyear events table is partitioned by event date but a nonaligned reporting index makes partition switching unexpectedly difficult. Select TWO: the best action and the outcome that confirms it worked.
Explanation
Correct Answers
Review partition alignment and required uniqueness keys for all indexes involved in maintenance. A rehearsed partition switch completes and representative queries retain acceptable plans.
A rehearsed partition switch completes and representative queries retain acceptable plans. The accompanying action is to review partition alignment and required uniqueness keys for all indexes involved in maintenance.
Incorrect Answers
Use a SEQUENCE object and document its caching and gap behavior for consumers. A rehearsed partition switch completes and representative queries retain acceptable plans. Review partition alignment and required uniqueness keys for all indexes involved in maintenance.
Consider supported graph node and edge tables and evaluate query readability and performance against relational alternatives. A rehearsed partition switch completes and representative queries retain acceptable plans.
A load test shows lower contention without unacceptable loss of required durable records. A rehearsed partition switch completes and representative queries retain acceptable plans. The accompanying action is to review partition alignment and required uniqueness keys for all indexes involved in maintenance.
Question 395
A commerce API receives order metadata JSON and analysts need a numeric discount for calculations, but lexical comparisons sort values incorrectly. What technical finding would substantiate this root cause?
Explanation
Correct Answer
A query treats a discount string of 100 as lower than 20 under character ordering. JSON_VALUE returns scalar text semantics, so downstream typing should match the intended operation.
Incorrect Answers
Current substring slicing returns invalid tokens when the prefix appears in narrative words. JSON_VALUE returns scalar text semantics, so downstream typing should match the intended operation. A query treats a discount string of 100 as lower than 20 under character ordering.
The existing query performs repeated nested scans and does not order same-time events predictably. JSON_VALUE returns scalar text semantics, so downstream typing should match the intended operation. A query treats a discount string of 100 as lower than 20 under character ordering.
An item containing quotes causes the generated JSON string to fail a parser test. JSON_VALUE returns scalar text semantics, so downstream typing should match the intended operation. A query treats a discount string of 100 as lower than 20 under character ordering.
Question 396
A support API requests top five nearest results but applies an incompatible filter after the query and often receives zero results for small tenants. Select TWO: the best action and the outcome that confirms it worked.
Explanation
Correct Answers
Review supported filter placement and retrieve enough authorized candidates before ranking as appropriate.
Tenant-specific queries return relevant permitted results within a bounded cost. Review supported filter placement and retrieve enough authorized candidates before ranking as appropriate.
Incorrect Answers
A test accepts valid vectors, rejects inconsistent dimensions, and reduces conversion work. Review supported filter placement and retrieve enough authorized candidates before ranking as appropriate. Tenant-specific queries return relevant permitted results within a bounded cost.
Apply product availability and eligibility rules before or during semantic ranking and verify result scope. Review supported filter placement and retrieve enough authorized candidates before ranking as appropriate.
Enforce authorized source filtering at retrieval and check underlying SQL permissions. Review supported filter placement and retrieve enough authorized candidates before ranking as appropriate.
Question 397
A finance assistant must answer questions about changing payment policy and the team proposes updating model weights whenever the policy changes. How should the SQL engineering team confirm the issue is truly resolved?
Explanation
Correct Answer
A controlled request cites the active policy and does not require a model retraining cycle. A finance assistant must answer questions about changing payment policy and the team proposes updating model weights whenever the policy changes.
Incorrect Answers
The model summarizes the comment without executing any unauthorized database change. A finance assistant must answer questions about changing payment policy and the team proposes updating model weights whenever the policy changes. A controlled request cites the active policy and does not require a model retraining cycle.
The workflow meets token and latency budgets while citing the correct current clauses. A finance assistant must answer questions about changing payment policy and the team proposes updating model weights whenever the policy changes. A controlled request cites the active policy and does not require a model retraining cycle.
Test queries without evidence return a clearly marked gap and a human review route. A finance assistant must answer questions about changing payment policy and the team proposes updating model weights whenever the policy changes. A controlled request cites the active policy and does not require a model retraining cycle.
Question 398
A customer portal sends retrieved SQL policy snippets to a model but discards source IDs, making claims impossible to audit. Which outcome shows the requirement is met without introducing a new risk?
Explanation
Correct Answer
Every material policy claim cites a current accessible source or is marked unsupported.
Incorrect Answers
The request sends only approved fields and the model receives sufficient task context. Every material policy claim cites a current accessible source or is marked unsupported.
The model summarizes the comment without executing any unauthorized database change. Every material policy claim cites a current accessible source or is marked unsupported.
A controlled request cites the active policy and does not require a model retraining cycle. Every material policy claim cites a current accessible source or is marked unsupported.
Question 399
A multi-customer vector search uses tenant filters only after retrieving global nearest neighbors, allowing protected chunks to influence responses. Which concept should guide the database developer in this situation?
Explanation
Correct Answer
Vector retrieval must not bypass the same row-level authorization as ordinary SQL queries.
Incorrect Answers
Full-text search provides token-aware retrieval beyond ordinary substring filters. Vector retrieval must not bypass the same row-level authorization as ordinary SQL queries.
Vector distance functions compare numeric embedding representations, not lexical JSON text. Vector retrieval must not bypass the same row-level authorization as ordinary SQL queries.
Vector normalization and distance metrics must be consistent across indexing and querying. Vector retrieval must not bypass the same row-level authorization as ordinary SQL queries.
Question 400
A product support database must find tickets containing exact hardware model codes and a proposal uses semantic vector matching alone. Which clue best distinguishes this issue from similar incidents?
Explanation
Correct Answer
Vector-only search returns semantically related products but misses the requested literal model code. Lexical and semantic relevance target different retrieval needs and are often complementary.
Incorrect Answers
The query output contains a citation to another tenant's chunk under certain prompts. Lexical and semantic relevance target different retrieval needs and are often complementary. Vector-only search returns semantically related products but misses the requested literal model code.
A discontinued SKU scores high on semantic relevance and appears as an orderable suggestion. Lexical and semantic relevance target different retrieval needs and are often complementary. Vector-only search returns semantically related products but misses the requested literal model code.
Global top-k candidates belong to other tenants and the postfilter removes all five. Lexical and semantic relevance target different retrieval needs and are often complementary. Vector-only search returns semantically related products but misses the requested literal model code.
Developing AI-Enabled Database Solutions (DP-800) Practice Tests
- Microsoft DP-800 Practice Test 38 - 10 Questions (Last Reviewed 10-Oct-2026)
- Microsoft DP-800 Practice Test 39 - 10 Questions (Last Reviewed 09-Oct-2026)
- Microsoft DP-800 Practice Test 40 - 10 Questions (Last Reviewed 08-Oct-2026)
- Microsoft DP-800 Practice Test 41 - 10 Questions (Last Reviewed 07-Oct-2026)
- Microsoft DP-800 Practice Test 42 - 10 Questions (Last Reviewed 06-Oct-2026)