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 38
Question 370
An API accepts arbitrary malformed JSON in a text field and downstream reporting intermittently fails during JSON parsing. Which observation is the strongest evidence for the reported problem?
Explanation
Correct Answer
Test inserts include invalid JSON syntax that is accepted without validation and later breaks consumers. Data shape and validity should be enforced as close to ingestion as practical.
Incorrect Answers
Investigators cannot determine what preference was effective before the latest update from the current table. Data shape and validity should be enforced as close to ingestion as practical. Test inserts include invalid JSON syntax that is accepted without validation and later breaks consumers.
A direct SQL write bypasses the front-end validator and saves invalid guest counts. Data shape and validity should be enforced as close to ingestion as practical. Test inserts include invalid JSON syntax that is accepted without validation and later breaks consumers.
The current query extracts a property for every row even when a small subset matches. Data shape and validity should be enforced as close to ingestion as practical. Test inserts include invalid JSON syntax that is accepted without validation and later breaks consumers.
Question 371
A checkout database has short selective updates to active carts and a consultant proposes replacing every rowstore index with columnstore. What is the MOST appropriate initial remediation?
Explanation
Correct Answer
Keep a row-oriented transactional design for the hot selective workload and benchmark analytical indexes separately. Physical storage decisions should follow transaction shapes rather than blanket performance claims.
Incorrect Answers
Design a governed temporal retention and deletion procedure across current and historical data. Physical storage decisions should follow transaction shapes rather than blanket performance claims. Keep a row-oriented transactional design for the hot selective workload and benchmark analytical indexes separately.
Use a SEQUENCE object and document its caching and gap behavior for consumers. Physical storage decisions should follow transaction shapes rather than blanket performance claims. Keep a row-oriented transactional design for the hot selective workload and benchmark analytical indexes separately.
Review partition alignment and required uniqueness keys for all indexes involved in maintenance. Physical storage decisions should follow transaction shapes rather than blanket performance claims. Keep a row-oriented transactional design for the hot selective workload and benchmark analytical indexes separately.
Question 372
An IoT staging table includes duplicate device readings and analysts need the latest reading per device without deleting historical evidence. What is the underlying reason for the corrective step?
Explanation
Correct Answer
Window functions can rank related rows while retaining access to complete row values.
Incorrect Answers
OPENJSON supports transforming structured arrays into queryable relational data. Window functions can rank related rows while retaining access to complete row values.
JSON membership semantics differ from arbitrary text matching and depend on feature support. Window functions can rank related rows while retaining access to complete row values.
Pattern specificity matters as much as the function chosen for regular-expression counts. Window functions can rank related rows while retaining access to complete row values.
Question 373
A customer portal sends retrieved SQL policy snippets to a model but discards source IDs, making claims impossible to audit. Which clue best distinguishes this issue from similar incidents?
Explanation
Correct Answer
A fluent answer states a refund deadline but offers no traceable source record. Grounded answers require verifiable provenance, not merely retrieval in the background.
Incorrect Answers
Requests exceed model context budgets and irrelevant chunks dominate the prompt. Grounded answers require verifiable provenance, not merely retrieval in the background. A fluent answer states a refund deadline but offers no traceable source record.
The generated exception is absent from all retrieved approved policy records. Grounded answers require verifiable provenance, not merely retrieval in the background. A fluent answer states a refund deadline but offers no traceable source record.
The model proposes changing an invoice amount solely because the customer comment said to. Grounded answers require verifiable provenance, not merely retrieval in the background. A fluent answer states a refund deadline but offers no traceable source record.
Question 374
A mobile inventory API requires a JSON object per warehouse containing an array of item summaries, and string concatenation produces malformed output for quoted names. What should the database developer verify to confirm the suspected cause?
Explanation
Correct Answer
An item containing quotes causes the generated JSON string to fail a parser test. Native JSON functions help create valid structured output instead of fragile manual string concatenation.
Incorrect Answers
The existing self-join misses a product because its previous month is absent. Native JSON functions help create valid structured output instead of fragile manual string concatenation. An item containing quotes causes the generated JSON string to fail a parser test.
The report returns different counts depending on which copy of the eligibility predicate was edited. Native JSON functions help create valid structured output instead of fragile manual string concatenation. An item containing quotes causes the generated JSON string to fail a parser test.
The manual join drops a two-hop path where a shared device links otherwise distinct accounts. Native JSON functions help create valid structured output instead of fragile manual string concatenation. An item containing quotes causes the generated JSON string to fail a parser test.
Question 375
A retailer's analytical orders table holds hundreds of millions of immutable rows and monthly reports scan most columns while the original rowstore design causes excessive I/O. Which test result would demonstrate the fix worked?
Explanation
Correct Answer
Representative analytics become faster while ingestion and operational lookups remain within their agreed limits. The operating rule is: Columnstore storage can improve scan-heavy analytics but its operational tradeoffs must be tested.
Incorrect Answers
After a tested maintenance change analytic scan cost improves and freshness commitments hold. The operating rule is: Columnstore storage can improve scan-heavy analytics but its operational tradeoffs must be tested. Representative analytics become faster while ingestion and operational lookups remain within their agreed limits.
A test query filters on the intended JSON property using the verified supported index design. The operating rule is: Columnstore storage can improve scan-heavy analytics but its operational tradeoffs must be tested. Representative analytics become faster while ingestion and operational lookups remain within their agreed limits.
Orphan inserts fail while legitimate import ordering and transactions succeed. The operating rule is: Columnstore storage can improve scan-heavy analytics but its operational tradeoffs must be tested. Representative analytics become faster while ingestion and operational lookups remain within their agreed limits.
Question 376
A customer portal sends retrieved SQL policy snippets to a model but discards source IDs, making claims impossible to audit. Select TWO: the best action and the outcome that confirms it worked.
Explanation
Correct Answers
Every material policy claim cites a current accessible source or is marked unsupported. The corresponding check is whether include controlled document identifiers, version metadata, and explicit citation requirements in the RAG prompt.
Include controlled document identifiers, version metadata, and explicit citation requirements in the RAG prompt. Every material policy claim cites a current accessible source or is marked unsupported.
Incorrect Answers
Test queries without evidence return a clearly marked gap and a human review route. Every material policy claim cites a current accessible source or is marked unsupported.
Use sp_invoke_external_rest_endpoint only with an approved network and identity configuration and a minimal validated prompt payload. Every material policy claim cites a current accessible source or is marked unsupported.
Convert the approved structured rows to valid JSON with supported SQL JSON construction functions. Every material policy claim cites a current accessible source or is marked unsupported.
Question 377
A service database holds free-form case descriptions and a parser must find identifiers with a fixed prefix and digit pattern. What distinction makes the recommended approach appropriate?
Explanation
Correct Answer
Regular expressions are useful for pattern-based text operations but require careful definitions and performance tests.
Incorrect Answers
Regex substitution supports structured redaction only when patterns are thoroughly validated. Regular expressions are useful for pattern-based text operations but require careful definitions and performance tests.
Native JSON functions help create valid structured output instead of fragile manual string concatenation. Regular expressions are useful for pattern-based text operations but require careful definitions and performance tests.
Window offset functions simplify ordered comparisons but do not create missing time periods. Regular expressions are useful for pattern-based text operations but require careful definitions and performance tests.
Question 378
A security team wants to confirm that cross-tenant access attempts are detected, not only blocked by its new row-level security predicate. What distinction makes the recommended approach appropriate?
Explanation
Correct Answer
Access prevention and accountable security monitoring are complementary controls.
Incorrect Answers
Encryption mode and query capabilities must be chosen together; not every plaintext operation remains available. Access prevention and accountable security monitoring are complementary controls.
RLS predicate quality depends on the integrity of the identity information it consumes. Access prevention and accountable security monitoring are complementary controls.
Model endpoints are security-sensitive downstream services and credentials must be governed. Access prevention and accountable security monitoring are complementary controls.
Question 379
An SQL-backed product catalog must update semantic vectors after deletes and updates, and a nightly full rebuild exceeds the budget. Which corrective action best fits the observed symptoms?
Explanation
Correct Answer
Evaluate a CDC-based incremental vector update process with checkpoints and delete propagation. Change capture can drive incremental embeddings if consumers handle event ordering and retention.
Incorrect Answers
Benchmark a suitable supported model for structured output on representative invoices and enforce schema validation. Change capture can drive incremental embeddings if consumers handle event ordering and retention. Evaluate a CDC-based incremental vector update process with checkpoints and delete propagation.
Implement bounded retries, observability, idempotent row-level progress, and quota-aware batching. Change capture can drive incremental embeddings if consumers handle event ordering and retention. Evaluate a CDC-based incremental vector update process with checkpoints and delete propagation.
Store approved model/version, source ID, timestamp, and change state alongside embeddings. Change capture can drive incremental embeddings if consumers handle event ordering and retention. Evaluate a CDC-based incremental vector update process with checkpoints and delete propagation.
Question 380
A support platform stores optional case attributes in a JSON column and filters on a frequent nested risk-level property at scale. Choose TWO statements: a suitable intervention and evidence of its success.
Explanation
Correct Answers
Design JSON access and indexing according to the engine's supported JSON features and test the predicate.
Queries find the correct risk values with less CPU and no loss of document validity. Design JSON access and indexing according to the engine's supported JSON features and test the predicate.
Incorrect Answers
Design a governed temporal retention and deletion procedure across current and historical data. Design JSON access and indexing according to the engine's supported JSON features and test the predicate.
A representative graph traversal returns validated connections at acceptable cost. Design JSON access and indexing according to the engine's supported JSON features and test the predicate. Queries find the correct risk values with less CPU and no loss of document validity.
Consider supported graph node and edge tables and evaluate query readability and performance against relational alternatives. Design JSON access and indexing according to the engine's supported JSON features and test the predicate. Queries find the correct risk values with less CPU and no loss of document validity.
Developing AI-Enabled Database Solutions (DP-800) Practice Tests
- Microsoft DP-800 Practice Test 36 - 10 Questions (Last Reviewed 12-Oct-2026)
- Microsoft DP-800 Practice Test 37 - 10 Questions (Last Reviewed 11-Oct-2026)
- 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)