Microsoft DP-800 Practice Test 38 - Prepaway
Practice Exams:

Pass Microsoft DP-800 Exam in First Attempt Guaranteed!

Get 100% Latest Exam Questions, Accurate & Verified Answers!

30 Days Free Updates, Instant Download!

Verified By Experts
Premium File
$69.99 $76.99

DP-800 Premium ETE File


  • Premium File 101 Questions & Answers. Last Update: Nov 06, 2026
Whats Included:
  • Latest Questions
  • 100% Accurate Answers
  • Fast Exam Updates

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?

  1. Investigators cannot determine what preference was effective before the latest update from the current table.
  2. Test inserts include invalid JSON syntax that is accepted without validation and later breaks consumers.
  3. A direct SQL write bypasses the front-end validator and saves invalid guest counts.
  4. The current query extracts a property for every row even when a small subset matches.

Explanation

Correct Answer

B:

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

A:

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.

C:

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.

D:

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?

  1. Keep a row-oriented transactional design for the hot selective workload and benchmark analytical indexes separately.
  2. Design a governed temporal retention and deletion procedure across current and historical data.
  3. Use a SEQUENCE object and document its caching and gap behavior for consumers.
  4. Review partition alignment and required uniqueness keys for all indexes involved in maintenance.

Explanation

Correct Answer

A:

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

B:

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.

C:

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.

D:

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?

  1. OPENJSON supports transforming structured arrays into queryable relational data.
  2. Window functions can rank related rows while retaining access to complete row values.
  3. JSON membership semantics differ from arbitrary text matching and depend on feature support.
  4. Pattern specificity matters as much as the function chosen for regular-expression counts.

Explanation

Correct Answer

B:

Window functions can rank related rows while retaining access to complete row values.

Incorrect Answers

A:

OPENJSON supports transforming structured arrays into queryable relational data. Window functions can rank related rows while retaining access to complete row values.

C:

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.

D:

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?

  1. Requests exceed model context budgets and irrelevant chunks dominate the prompt.
  2. The generated exception is absent from all retrieved approved policy records.
  3. The model proposes changing an invoice amount solely because the customer comment said to.
  4. A fluent answer states a refund deadline but offers no traceable source record.

Explanation

Correct Answer

D:

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

A:

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.

B:

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.

C:

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?

  1. An item containing quotes causes the generated JSON string to fail a parser test.
  2. The existing self-join misses a product because its previous month is absent.
  3. The report returns different counts depending on which copy of the eligibility predicate was edited.
  4. The manual join drops a two-hop path where a shared device links otherwise distinct accounts.

Explanation

Correct Answer

A:

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

B:

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.

C:

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.

D:

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?

  1. Representative analytics become faster while ingestion and operational lookups remain within their agreed limits.
  2. After a tested maintenance change analytic scan cost improves and freshness commitments hold.
  3. A test query filters on the intended JSON property using the verified supported index design.
  4. Orphan inserts fail while legitimate import ordering and transactions succeed.

Explanation

Correct Answer

A:

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

B:

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.

C:

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.

D:

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.

  1. Every material policy claim cites a current accessible source or is marked unsupported.
  2. Include controlled document identifiers, version metadata, and explicit citation requirements in the RAG prompt.
  3. Test queries without evidence return a clearly marked gap and a human review route.
  4. Use sp_invoke_external_rest_endpoint only with an approved network and identity configuration and a minimal validated prompt payload.
  5. Convert the approved structured rows to valid JSON with supported SQL JSON construction functions.

Explanation

Correct Answers

A:

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.

B:

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

C:

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.

D:

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.

E:

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?

  1. Regular expressions are useful for pattern-based text operations but require careful definitions and performance tests.
  2. Regex substitution supports structured redaction only when patterns are thoroughly validated.
  3. Native JSON functions help create valid structured output instead of fragile manual string concatenation.
  4. Window offset functions simplify ordered comparisons but do not create missing time periods.

Explanation

Correct Answer

A:

Regular expressions are useful for pattern-based text operations but require careful definitions and performance tests.

Incorrect Answers

B:

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.

C:

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.

D:

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?

  1. Encryption mode and query capabilities must be chosen together; not every plaintext operation remains available.
  2. RLS predicate quality depends on the integrity of the identity information it consumes.
  3. Model endpoints are security-sensitive downstream services and credentials must be governed.
  4. Access prevention and accountable security monitoring are complementary controls.

Explanation

Correct Answer

D:

Access prevention and accountable security monitoring are complementary controls.

Incorrect Answers

A:

Encryption mode and query capabilities must be chosen together; not every plaintext operation remains available. Access prevention and accountable security monitoring are complementary controls.

B:

RLS predicate quality depends on the integrity of the identity information it consumes. Access prevention and accountable security monitoring are complementary controls.

C:

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?

  1. Benchmark a suitable supported model for structured output on representative invoices and enforce schema validation.
  2. Implement bounded retries, observability, idempotent row-level progress, and quota-aware batching.
  3. Evaluate a CDC-based incremental vector update process with checkpoints and delete propagation.
  4. Store approved model/version, source ID, timestamp, and change state alongside embeddings.

Explanation

Correct Answer

C:

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

A:

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.

B:

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.

D:

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.

  1. Design a governed temporal retention and deletion procedure across current and historical data.
  2. A representative graph traversal returns validated connections at acceptable cost.
  3. Design JSON access and indexing according to the engine's supported JSON features and test the predicate.
  4. Queries find the correct risk values with less CPU and no loss of document validity.
  5. Consider supported graph node and edge tables and evaluate query readability and performance against relational alternatives.

Explanation

Correct Answers

C:

Design JSON access and indexing according to the engine's supported JSON features and test the predicate.

D:

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

A:

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.

B:

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.

E:

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