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

Question 460

A database team knows only that an Azure SQL service is slower after peak traffic but does not know which query consumes resources. What would be a valid post-database-change verification?

  1. The new configuration reduces read blocking while reports avoid uncommitted data and temp/version costs are monitored.
  2. Repeated parallel tests no longer reproduce the deadlock and functional outcomes remain correct.
  3. The chosen change lowers total reads without an unacceptable index maintenance penalty.
  4. The analysis identifies specific statements and a tested change reduces peak resource use.

Explanation

Correct Answer

D:

The analysis identifies specific statements and a tested change reduces peak resource use. A database team knows only that an Azure SQL service is slower after peak traffic but does not know which query consumes resources.

Incorrect Answers

A:

The new configuration reduces read blocking while reports avoid uncommitted data and temp/version costs are monitored. A database team knows only that an Azure SQL service is slower after peak traffic but does not know which query consumes resources. The analysis identifies specific statements and a tested change reduces peak resource use.

B:

Repeated parallel tests no longer reproduce the deadlock and functional outcomes remain correct. A database team knows only that an Azure SQL service is slower after peak traffic but does not know which query consumes resources. The analysis identifies specific statements and a tested change reduces peak resource use.

C:

The chosen change lowers total reads without an unacceptable index maintenance penalty. A database team knows only that an Azure SQL service is slower after peak traffic but does not know which query consumes resources. The analysis identifies specific statements and a tested change reduces peak resource use.

Question 461

A pipeline uses a shared administrator password to publish SQL Database Project changes to multiple production databases. What is the underlying reason for the corrective step?

  1. Automated deployment identities should be scoped to the resources and actions they operate.
  2. Schema evolution should account for clients with independent deployment cycles.
  3. Database CI/CD needs separation of development activity from production authorization.
  4. Database merge conflicts can affect schema semantics beyond textual file overlap.

Explanation

Correct Answer

A:

Automated deployment identities should be scoped to the resources and actions they operate.

Incorrect Answers

B:

Schema evolution should account for clients with independent deployment cycles. Automated deployment identities should be scoped to the resources and actions they operate.

C:

Database CI/CD needs separation of development activity from production authorization. Automated deployment identities should be scoped to the resources and actions they operate.

D:

Database merge conflicts can affect schema semantics beyond textual file overlap. Automated deployment identities should be scoped to the resources and actions they operate.

Question 462

A multitenant database serves a tiny customer and a giant enterprise through the same stored procedure; one cached plan is poor for the other. Which corrective action best fits the observed symptoms?

  1. Assess a covering index or query projection change with real selectivity and write overhead.
  2. Evaluate parameter-sensitive plan features and validated mitigation for the engine version.
  3. Use available query performance insights, Query Store, and relevant DMVs to identify the top regressed statements.
  4. Choose transactional locking or isolation that enforces the reservation invariant under concurrency.

Explanation

Correct Answer

B:

Evaluate parameter-sensitive plan features and validated mitigation for the engine version. Cardinality skew can make a single cached plan suboptimal across parameter values.

Incorrect Answers

A:

Assess a covering index or query projection change with real selectivity and write overhead. Cardinality skew can make a single cached plan suboptimal across parameter values. Evaluate parameter-sensitive plan features and validated mitigation for the engine version.

C:

Use available query performance insights, Query Store, and relevant DMVs to identify the top regressed statements. Cardinality skew can make a single cached plan suboptimal across parameter values. Evaluate parameter-sensitive plan features and validated mitigation for the engine version.

D:

Choose transactional locking or isolation that enforces the reservation invariant under concurrency. Cardinality skew can make a single cached plan suboptimal across parameter values. Evaluate parameter-sensitive plan features and validated mitigation for the engine version.

Question 463

A SQL service searches FAQ text with broad LIKE predicates across millions of records and response time increases as data grows. What is the underlying reason for the corrective step?

  1. Full-text search provides token-aware retrieval beyond ordinary substring filters.
  2. Indexed vector search trades computation and index behavior against recall and resource cost.
  3. Top-k selection and filtering order affect both relevance and security.
  4. Vector normalization and distance metrics must be consistent across indexing and querying.

Explanation

Correct Answer

A:

Full-text search provides token-aware retrieval beyond ordinary substring filters.

Incorrect Answers

B:

Indexed vector search trades computation and index behavior against recall and resource cost. Full-text search provides token-aware retrieval beyond ordinary substring filters.

C:

Top-k selection and filtering order affect both relevance and security. Full-text search provides token-aware retrieval beyond ordinary substring filters.

D:

Vector normalization and distance metrics must be consistent across indexing and querying. Full-text search provides token-aware retrieval beyond ordinary substring filters.

Question 464

A procedure posts an invoice and then calls a failing validation routine; the customer balance remains changed because the error is swallowed. Choose TWO statements: a suitable intervention and evidence of its success.

  1. The graph query returns the verified two-hop relationships without inventing direct account links.
  2. The validation error results in a fully consistent rollback and a diagnostic error response.
  3. Implement TRY CATCH with transaction state handling, rollback, and error propagation appropriate to the caller.
  4. Use supported JSON construction and aggregation functions with an explicit schema and null treatment.
  5. Use LAG partitioned by product and ordered by report month, then check handling for missing months.

Explanation

Correct Answers

B:

The validation error results in a fully consistent rollback and a diagnostic error response. Implement TRY CATCH with transaction state handling, rollback, and error propagation appropriate to the caller.

C:

Implement TRY CATCH with transaction state handling, rollback, and error propagation appropriate to the caller.

Incorrect Answers

A:

The graph query returns the verified two-hop relationships without inventing direct account links. Implement TRY CATCH with transaction state handling, rollback, and error propagation appropriate to the caller. The validation error results in a fully consistent rollback and a diagnostic error response.

D:

Use supported JSON construction and aggregation functions with an explicit schema and null treatment. Implement TRY CATCH with transaction state handling, rollback, and error propagation appropriate to the caller.

E:

Use LAG partitioned by product and ordered by report month, then check handling for missing months. Implement TRY CATCH with transaction state handling, rollback, and error propagation appropriate to the caller.

Question 465

A GitHub Copilot chat connects to a SQL MCP server configured with a broad administrator identity and developers plan to run generated queries against production. Which corrective action best fits the observed symptoms?

  1. Verify tenant/workspace enablement, permissions, and responsible AI policy before configuring Copilot in Fabric.
  2. Treat the suggestion as untrusted code and require code review, data access tests, and execution plan analysis.
  3. Scope the connector to approved lakehouse data and verify the selected identity and workspace permissions.
  4. Reconfigure the MCP endpoint with least-privilege access and narrow approved operations before any production execution.

Explanation

Correct Answer

D:

Reconfigure the MCP endpoint with least-privilege access and narrow approved operations before any production execution. Giving an assistant tools extends its action surface and must not imply unrestricted administrative authority.

Incorrect Answers

A:

Verify tenant/workspace enablement, permissions, and responsible AI policy before configuring Copilot in Fabric. Giving an assistant tools extends its action surface and must not imply unrestricted administrative authority. Reconfigure the MCP endpoint with least-privilege access and narrow approved operations before any production execution.

B:

Treat the suggestion as untrusted code and require code review, data access tests, and execution plan analysis. Giving an assistant tools extends its action surface and must not imply unrestricted administrative authority. Reconfigure the MCP endpoint with least-privilege access and narrow approved operations before any production execution.

C:

Scope the connector to approved lakehouse data and verify the selected identity and workspace permissions. Giving an assistant tools extends its action surface and must not imply unrestricted administrative authority. Reconfigure the MCP endpoint with least-privilege access and narrow approved operations before any production execution.

Question 466

A supplier sends one JSON payload containing an array of shipment items and the importer currently saves the array as an opaque string. Which clue best distinguishes this issue from similar incidents?

  1. A basic replace misses some token variations and leaves identifiers in test messages.
  2. The existing query performs repeated nested scans and does not order same-time events predictably.
  3. The database stores one row per shipment but cannot query per-item quantities or product codes.
  4. The existing self-join misses a product because its previous month is absent.

Explanation

Correct Answer

C:

The database stores one row per shipment but cannot query per-item quantities or product codes. OPENJSON supports transforming structured arrays into queryable relational data.

Incorrect Answers

A:

A basic replace misses some token variations and leaves identifiers in test messages. OPENJSON supports transforming structured arrays into queryable relational data. The database stores one row per shipment but cannot query per-item quantities or product codes.

B:

The existing query performs repeated nested scans and does not order same-time events predictably. OPENJSON supports transforming structured arrays into queryable relational data. The database stores one row per shipment but cannot query per-item quantities or product codes.

D:

The existing self-join misses a product because its previous month is absent. OPENJSON supports transforming structured arrays into queryable relational data. The database stores one row per shipment but cannot query per-item quantities or product codes.

Question 467

A help-desk knowledge table is updated frequently but its embeddings are only generated during an initial import, leaving search results stale. What should the database developer do FIRST within approved procedures?

  1. Use an approved secure identity or secret-management mechanism supported by the SQL platform and model endpoint.
  2. Use Change Tracking or another supported change signal to queue reliable re-embedding of modified source records.
  3. Version the model configuration and compare outputs, latency, and contracts before controlled replacement.
  4. Store approved model/version, source ID, timestamp, and change state alongside embeddings.

Explanation

Correct Answer

B:

Use Change Tracking or another supported change signal to queue reliable re-embedding of modified source records. Embedding stores need a maintenance strategy that follows authoritative source changes.

Incorrect Answers

A:

Use an approved secure identity or secret-management mechanism supported by the SQL platform and model endpoint. Embedding stores need a maintenance strategy that follows authoritative source changes. Use Change Tracking or another supported change signal to queue reliable re-embedding of modified source records.

C:

Version the model configuration and compare outputs, latency, and contracts before controlled replacement. Embedding stores need a maintenance strategy that follows authoritative source changes. Use Change Tracking or another supported change signal to queue reliable re-embedding of modified source records.

D:

Store approved model/version, source ID, timestamp, and change state alongside embeddings. Embedding stores need a maintenance strategy that follows authoritative source changes. Use Change Tracking or another supported change signal to queue reliable re-embedding of modified source records.

Question 468

A cloud database enables disk encryption but an application team assumes that prevents its overly privileged SQL login from reading confidential rows. What technical finding would substantiate this root cause?

  1. A blocked test returns no rows but produces no actionable signal in the team's audit workflow.
  2. The compromised application identity reads plaintext fields from normal SQL queries despite encrypted storage.
  3. A nearest-neighbor query or reconstruction-related audit reveals sensitive customer-derived content in search results.
  4. A test prompt can invoke an ALTER TABLE through the assistant without human authorization.

Explanation

Correct Answer

B:

The compromised application identity reads plaintext fields from normal SQL queries despite encrypted storage. Encryption at rest does not replace database access controls for authenticated query operations.

Incorrect Answers

A:

A blocked test returns no rows but produces no actionable signal in the team's audit workflow. Encryption at rest does not replace database access controls for authenticated query operations. The compromised application identity reads plaintext fields from normal SQL queries despite encrypted storage.

C:

A nearest-neighbor query or reconstruction-related audit reveals sensitive customer-derived content in search results. Encryption at rest does not replace database access controls for authenticated query operations. The compromised application identity reads plaintext fields from normal SQL queries despite encrypted storage.

D:

A test prompt can invoke an ALTER TABLE through the assistant without human authorization. Encryption at rest does not replace database access controls for authenticated query operations. The compromised application identity reads plaintext fields from normal SQL queries despite encrypted storage.

Question 469

A data quality team sanitizes narratives that may include a recognizable account-number format before an AI summarization step. Which clue best distinguishes this issue from similar incidents?

  1. A query treats a discount string of 100 as lower than 20 under character ordering.
  2. The existing query performs repeated nested scans and does not order same-time events predictably.
  3. The existing self-join misses a product because its previous month is absent.
  4. A basic replace misses some token variations and leaves identifiers in test messages.

Explanation

Correct Answer

D:

A basic replace misses some token variations and leaves identifiers in test messages. Regex substitution supports structured redaction only when patterns are thoroughly validated.

Incorrect Answers

A:

A query treats a discount string of 100 as lower than 20 under character ordering. Regex substitution supports structured redaction only when patterns are thoroughly validated. A basic replace misses some token variations and leaves identifiers in test messages.

B:

The existing query performs repeated nested scans and does not order same-time events predictably. Regex substitution supports structured redaction only when patterns are thoroughly validated. A basic replace misses some token variations and leaves identifiers in test messages.

C:

The existing self-join misses a product because its previous month is absent. Regex substitution supports structured redaction only when patterns are thoroughly validated. A basic replace misses some token variations and leaves identifiers in test messages.

Question 470

A search team stores vectors but omits the source document version and model identifier, making comparisons after model changes unverifiable. What should the database developer do FIRST within approved procedures?

  1. Evaluate a CDC-based incremental vector update process with checkpoints and delete propagation.
  2. Create a compatible versioned embedding migration with dimension checks and rebuild the affected index where required.
  3. Use Change Tracking or another supported change signal to queue reliable re-embedding of modified source records.
  4. Store approved model/version, source ID, timestamp, and change state alongside embeddings.

Explanation

Correct Answer

D:

Store approved model/version, source ID, timestamp, and change state alongside embeddings. Embedding metadata enables quality monitoring, reconciliation, and safe model evolution.

Incorrect Answers

A:

Evaluate a CDC-based incremental vector update process with checkpoints and delete propagation. Embedding metadata enables quality monitoring, reconciliation, and safe model evolution. Store approved model/version, source ID, timestamp, and change state alongside embeddings.

B:

Create a compatible versioned embedding migration with dimension checks and rebuild the affected index where required. Embedding metadata enables quality monitoring, reconciliation, and safe model evolution. Store approved model/version, source ID, timestamp, and change state alongside embeddings.

C:

Use Change Tracking or another supported change signal to queue reliable re-embedding of modified source records. Embedding metadata enables quality monitoring, reconciliation, and safe model evolution. Store approved model/version, source ID, timestamp, and change state alongside embeddings.

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