Microsoft DP-800 Practice Test 6 - 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 6

Question 50

A regulated benefits application calls a model through SQL but stores only the final generated sentence, leaving no way to reconstruct cited source versions or model configuration. Choose TWO statements: a suitable intervention and evidence of its success.

  1. Treat retrieved content as untrusted evidence and never grant it authority to execute SQL actions.
  2. Require an explicit evidence threshold and safe refusal or escalation when retrieval finds no current supporting clause.
  3. A sampled result can be traced to permitted source records, model version, and accountable review.
  4. Every material policy claim cites a current accessible source or is marked unsupported.
  5. Record authorized prompt/source version metadata, model identity, and approval outcome with appropriate privacy retention.

Explanation

Correct Answers

C:

A sampled result can be traced to permitted source records, model version, and accountable review. Record authorized prompt/source version metadata, model identity, and approval outcome with appropriate privacy retention.

E:

Record authorized prompt/source version metadata, model identity, and approval outcome with appropriate privacy retention.

Incorrect Answers

A:

Treat retrieved content as untrusted evidence and never grant it authority to execute SQL actions. Record authorized prompt/source version metadata, model identity, and approval outcome with appropriate privacy retention. A sampled result can be traced to permitted source records, model version, and accountable review.

B:

Require an explicit evidence threshold and safe refusal or escalation when retrieval finds no current supporting clause. Record authorized prompt/source version metadata, model identity, and approval outcome with appropriate privacy retention. A sampled result can be traced to permitted source records, model version, and accountable review.

D:

Every material policy claim cites a current accessible source or is marked unsupported. Record authorized prompt/source version metadata, model identity, and approval outcome with appropriate privacy retention. A sampled result can be traced to permitted source records, model version, and accountable review.

Question 51

A customer database encrypts every attribute and then expects ordinary range searches across an encrypted salary column without design changes. What should the database developer do FIRST within approved procedures?

  1. Grant the function only the change-data access it requires and review its output destination.
  2. Configure appropriate SQL auditing to a protected destination with tested retention and access reviews.
  3. Select compatible encryption and query patterns for the required comparisons and test the permitted operations.
  4. Plan coordinated key rotation and recovery testing before replacing or retiring key material.

Explanation

Correct Answer

C:

Select compatible encryption and query patterns for the required comparisons and test the permitted operations. Encryption mode and query capabilities must be chosen together; not every plaintext operation remains available.

Incorrect Answers

A:

Grant the function only the change-data access it requires and review its output destination. Encryption mode and query capabilities must be chosen together; not every plaintext operation remains available. Select compatible encryption and query patterns for the required comparisons and test the permitted operations.

B:

Configure appropriate SQL auditing to a protected destination with tested retention and access reviews. Encryption mode and query capabilities must be chosen together; not every plaintext operation remains available. Select compatible encryption and query patterns for the required comparisons and test the permitted operations.

D:

Plan coordinated key rotation and recovery testing before replacing or retiring key material. Encryption mode and query capabilities must be chosen together; not every plaintext operation remains available. Select compatible encryption and query patterns for the required comparisons and test the permitted operations.

Question 52

A legacy service writes through a combined view spanning two base tables and regular UPDATE statements cannot be unambiguously applied. What would be a valid post-database-change verification?

  1. Running the same deployment twice produces the expected reference rows without duplication.
  2. Representative small and large parameter tests both meet latency with acceptable compilation cost.
  3. Unauthorized selects are blocked by permissions and legitimate data changes produce reliable audit records.
  4. A controlled update follows the intended mapping without corrupting the related tables.

Explanation

Correct Answer

D:

A controlled update follows the intended mapping without corrupting the related tables. A legacy service writes through a combined view spanning two base tables and regular UPDATE statements cannot be unambiguously applied.

Incorrect Answers

A:

Running the same deployment twice produces the expected reference rows without duplication. A legacy service writes through a combined view spanning two base tables and regular UPDATE statements cannot be unambiguously applied. A controlled update follows the intended mapping without corrupting the related tables.

B:

Representative small and large parameter tests both meet latency with acceptable compilation cost. A legacy service writes through a combined view spanning two base tables and regular UPDATE statements cannot be unambiguously applied. A controlled update follows the intended mapping without corrupting the related tables.

C:

Unauthorized selects are blocked by permissions and legitimate data changes produce reliable audit records. A legacy service writes through a combined view spanning two base tables and regular UPDATE statements cannot be unambiguously applied. A controlled update follows the intended mapping without corrupting the related tables.

Question 53

A supplier sends one JSON payload containing an array of shipment items and the importer currently saves the array as an opaque string. Which corrective action best fits the observed symptoms?

  1. Use OPENJSON with an explicit schema to expand validated line items into relational rows.
  2. Use a supported REGEXP_SUBSTR or related regex operation with input validation and cost review.
  3. Use supported REGEXP_SPLIT_TO_TABLE or a safe parsing alternative with trimming and invalid-token checks.
  4. Use LAG partitioned by product and ordered by report month, then check handling for missing months.

Explanation

Correct Answer

A:

Use OPENJSON with an explicit schema to expand validated line items into relational rows. OPENJSON supports transforming structured arrays into queryable relational data.

Incorrect Answers

B:

Use a supported REGEXP_SUBSTR or related regex operation with input validation and cost review. OPENJSON supports transforming structured arrays into queryable relational data. Use OPENJSON with an explicit schema to expand validated line items into relational rows.

C:

Use supported REGEXP_SPLIT_TO_TABLE or a safe parsing alternative with trimming and invalid-token checks. OPENJSON supports transforming structured arrays into queryable relational data. Use OPENJSON with an explicit schema to expand validated line items into relational rows.

D:

Use LAG partitioned by product and ordered by report month, then check handling for missing months. OPENJSON supports transforming structured arrays into queryable relational data. Use OPENJSON with an explicit schema to expand validated line items into relational rows.

Question 54

A product catalog API must retrieve a product with its authorized variants in one GraphQL request but the relationship mapping is not configured. Which clue best distinguishes this issue from similar incidents?

  1. An unbounded request sends millions of records and overwhelms the service during peak use.
  2. A nested query fails to resolve variants even though the SQL foreign key relationships exist.
  3. SQL shows the approved new price while the API still returns the old cached payload.
  4. The slow requests include nested fan-out operations that trigger repeated SQL lookups.

Explanation

Correct Answer

B:

A nested query fails to resolve variants even though the SQL foreign key relationships exist. GraphQL relationships need explicit API modeling beyond raw relational keys.

Incorrect Answers

A:

An unbounded request sends millions of records and overwhelms the service during peak use. GraphQL relationships need explicit API modeling beyond raw relational keys. A nested query fails to resolve variants even though the SQL foreign key relationships exist.

C:

SQL shows the approved new price while the API still returns the old cached payload. GraphQL relationships need explicit API modeling beyond raw relational keys. A nested query fails to resolve variants even though the SQL foreign key relationships exist.

D:

The slow requests include nested fan-out operations that trigger repeated SQL lookups. GraphQL relationships need explicit API modeling beyond raw relational keys. A nested query fails to resolve variants even though the SQL foreign key relationships exist.

Question 55

An Azure Function consumes SQL change events with a credential that also grants access to unrelated financial tables. What is the underlying reason for the corrective step?

  1. A friendly UI never substitutes for server-side field and entity access controls.
  2. Embeddings can retain sensitive information relationships and must follow the underlying data governance.
  3. Passwordless managed identity can reduce secret distribution when authorization is configured correctly.
  4. Background integrations require narrowly scoped identities just as interactive users do.

Explanation

Correct Answer

D:

Background integrations require narrowly scoped identities just as interactive users do.

Incorrect Answers

A:

A friendly UI never substitutes for server-side field and entity access controls. Background integrations require narrowly scoped identities just as interactive users do.

B:

Embeddings can retain sensitive information relationships and must follow the underlying data governance. Background integrations require narrowly scoped identities just as interactive users do.

C:

Passwordless managed identity can reduce secret distribution when authorization is configured correctly. Background integrations require narrowly scoped identities just as interactive users do.

Question 56

A development team runs Data API builder with a local configuration but its production container lacks the approved connection settings and role maps. Which next step most directly resolves this SQL solution issue?

  1. Configure appropriate pagination, result limits, and role-level filtering in DAB.
  2. Version the DAB configuration and use environment-specific secret injection and validation during deployment.
  3. Define a narrowly scoped DAB configuration with explicit entities, operations, and role-based permissions.
  4. Evaluate SQL change data capture availability and retention with a durable consumer checkpoint.

Explanation

Correct Answer

B:

Version the DAB configuration and use environment-specific secret injection and validation during deployment. Deployable API configuration is part of the governed application artifact.

Incorrect Answers

A:

Configure appropriate pagination, result limits, and role-level filtering in DAB. Deployable API configuration is part of the governed application artifact. Version the DAB configuration and use environment-specific secret injection and validation during deployment.

C:

Define a narrowly scoped DAB configuration with explicit entities, operations, and role-based permissions. Deployable API configuration is part of the governed application artifact. Version the DAB configuration and use environment-specific secret injection and validation during deployment.

D:

Evaluate SQL change data capture availability and retention with a durable consumer checkpoint. Deployable API configuration is part of the governed application artifact. Version the DAB configuration and use environment-specific secret injection and validation during deployment.

Question 57

A SQL service searches FAQ text with broad LIKE predicates across millions of records and response time increases as data grows. What is the MOST appropriate initial remediation?

  1. Use a supported SQL vector type with dimension compatibility checks and an appropriate data design.
  2. Benchmark a multilingual embedding/retrieval strategy and compare language-specific recall.
  3. Evaluate supported full-text indexing and query patterns with language-specific tokenization requirements.
  4. Use supported VECTOR_DISTANCE with a compatible metric and deterministic ranking checks.

Explanation

Correct Answer

C:

Evaluate supported full-text indexing and query patterns with language-specific tokenization requirements. Full-text search provides token-aware retrieval beyond ordinary substring filters.

Incorrect Answers

A:

Use a supported SQL vector type with dimension compatibility checks and an appropriate data design. Full-text search provides token-aware retrieval beyond ordinary substring filters. Evaluate supported full-text indexing and query patterns with language-specific tokenization requirements.

B:

Benchmark a multilingual embedding/retrieval strategy and compare language-specific recall. Full-text search provides token-aware retrieval beyond ordinary substring filters. Evaluate supported full-text indexing and query patterns with language-specific tokenization requirements.

D:

Use supported VECTOR_DISTANCE with a compatible metric and deterministic ranking checks. Full-text search provides token-aware retrieval beyond ordinary substring filters. Evaluate supported full-text indexing and query patterns with language-specific tokenization requirements.

Question 58

A distributed team uses GitHub Copilot for SQL project changes but suggestions repeatedly violate the team's migration and naming conventions. What is the underlying reason for the corrective step?

  1. AI suggestions must be benchmarked against production-like workload tradeoffs rather than adopted by confidence.
  2. Repository instructions can guide assistance but do not replace automated checks or accountable reviewers.
  3. AI assistant availability depends on environment settings, entitlements, and tenant governance.
  4. Tool routing must be unambiguous when an AI assistant can reach multiple data environments.

Explanation

Correct Answer

B:

Repository instructions can guide assistance but do not replace automated checks or accountable reviewers.

Incorrect Answers

A:

AI suggestions must be benchmarked against production-like workload tradeoffs rather than adopted by confidence. Repository instructions can guide assistance but do not replace automated checks or accountable reviewers.

C:

AI assistant availability depends on environment settings, entitlements, and tenant governance. Repository instructions can guide assistance but do not replace automated checks or accountable reviewers.

D:

Tool routing must be unambiguous when an AI assistant can reach multiple data environments. Repository instructions can guide assistance but do not replace automated checks or accountable reviewers.

Question 59

A high-volume retail database must publish changes to downstream near-real-time consumers without exposing operational credentials to every subscriber. Select TWO: the best action and the outcome that confirms it worked.

  1. Capture API query shapes and SQL dependency telemetry before scaling hardware.
  2. Evaluate supported change event streaming with governed identity, routing, and retry policies.
  3. Use supported Change Tracking with a version watermark and controlled rehydration of current rows.
  4. Consumers receive authorized change events and cannot read unrelated database records.
  5. A client retrieves only changed keys since its saved version and safely handles retention gaps.

Explanation

Correct Answers

B:

Evaluate supported change event streaming with governed identity, routing, and retry policies. A high-volume retail database must publish changes to downstream near-real-time consumers without exposing operational credentials to every subscriber.

D:

Consumers receive authorized change events and cannot read unrelated database records. A high-volume retail database must publish changes to downstream near-real-time consumers without exposing operational credentials to every subscriber.

Incorrect Answers

A:

Capture API query shapes and SQL dependency telemetry before scaling hardware. A high-volume retail database must publish changes to downstream near-real-time consumers without exposing operational credentials to every subscriber. Consumers receive authorized change events and cannot read unrelated database records.

C:

Use supported Change Tracking with a version watermark and controlled rehydration of current rows. A high-volume retail database must publish changes to downstream near-real-time consumers without exposing operational credentials to every subscriber. Evaluate supported change event streaming with governed identity, routing, and retry policies.

E:

A client retrieves only changed keys since its saved version and safely handles retention gaps. A high-volume retail database must publish changes to downstream near-real-time consumers without exposing operational credentials to every subscriber. Consumers receive authorized change events and cannot read unrelated database records.

Question 60

A telemetry ingestion service sees hot-row latch contention in a small transient state table during bursty writes. What would be a valid post-database-change verification?

  1. The SQL query reads the correct current permitted external records with monitored latency and access controls.
  2. The targeted query performs a selective seek with fewer reads and without an unacceptable write penalty.
  3. Checkout transaction latency remains stable while reporting queries use purpose-built structures.
  4. A load test shows lower contention without unacceptable loss of required durable records.

Explanation

Correct Answer

D:

A load test shows lower contention without unacceptable loss of required durable records.

Incorrect Answers

A:

The SQL query reads the correct current permitted external records with monitored latency and access controls. A load test shows lower contention without unacceptable loss of required durable records.

B:

The targeted query performs a selective seek with fewer reads and without an unacceptable write penalty. A load test shows lower contention without unacceptable loss of required durable records.

C:

Checkout transaction latency remains stable while reporting queries use purpose-built structures. A load test shows lower contention without unacceptable loss of required durable records.

Developing AI-Enabled Database Solutions (DP-800) Practice Tests