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

Question 90

A device catalog adds hundreds of mostly empty optional fields as standard columns and read performance is deteriorating. What technical finding would substantiate this root cause?

  1. Storage inspection finds most optional attribute columns are NULL in nearly every row.
  2. Current application counters collide under concurrent insert attempts and operators require IDs to be unique rather than consecutive.
  3. The critical path performs single-cart updates and point lookups rather than large aggregations.
  4. The current database permits changes with no dependable tamper-evidence verification route.

Explanation

Correct Answer

A:

Storage inspection finds most optional attribute columns are NULL in nearly every row. Schema flexibility must be balanced with data integrity and queryability rather than chosen by column count alone.

Incorrect Answers

B:

Current application counters collide under concurrent insert attempts and operators require IDs to be unique rather than consecutive. Schema flexibility must be balanced with data integrity and queryability rather than chosen by column count alone. Storage inspection finds most optional attribute columns are NULL in nearly every row.

C:

The critical path performs single-cart updates and point lookups rather than large aggregations. Schema flexibility must be balanced with data integrity and queryability rather than chosen by column count alone. Storage inspection finds most optional attribute columns are NULL in nearly every row.

D:

The current database permits changes with no dependable tamper-evidence verification route. Schema flexibility must be balanced with data integrity and queryability rather than chosen by column count alone. Storage inspection finds most optional attribute columns are NULL in nearly every row.

Question 91

A SQL-centered maintenance application stores images and text descriptions of equipment failures and the team attempts to embed images with a text-only pipeline. Which corrective action best fits the observed symptoms?

  1. Use an approved secure identity or secret-management mechanism supported by the SQL platform and model endpoint.
  2. Evaluate multimodal models or appropriately separated image/text embeddings with clear data handling rules.
  3. Evaluate multilingual embedding models against labeled cross-language retrieval tests and relevant privacy constraints.
  4. Version the model configuration and compare outputs, latency, and contracts before controlled replacement.

Explanation

Correct Answer

B:

Evaluate multimodal models or appropriately separated image/text embeddings with clear data handling rules. Model modalities and preprocessing must match the stored evidence types.

Incorrect Answers

A:

Use an approved secure identity or secret-management mechanism supported by the SQL platform and model endpoint. Model modalities and preprocessing must match the stored evidence types. Evaluate multimodal models or appropriately separated image/text embeddings with clear data handling rules.

C:

Evaluate multilingual embedding models against labeled cross-language retrieval tests and relevant privacy constraints. Model modalities and preprocessing must match the stored evidence types. Evaluate multimodal models or appropriately separated image/text embeddings with clear data handling rules.

D:

Version the model configuration and compare outputs, latency, and contracts before controlled replacement. Model modalities and preprocessing must match the stored evidence types. Evaluate multimodal models or appropriately separated image/text embeddings with clear data handling rules.

Question 92

A finance assistant must answer questions about changing payment policy and the team proposes updating model weights whenever the policy changes. Choose TWO statements: a suitable intervention and evidence of its success.

  1. Require an explicit evidence threshold and safe refusal or escalation when retrieval finds no current supporting clause.
  2. The model summarizes the comment without executing any unauthorized database change.
  3. Implement retrieval-augmented generation using approved current SQL policy records with source citations.
  4. Parse and validate the returned model response envelope and expected JSON fields before storing results.
  5. A controlled request cites the active policy and does not require a model retraining cycle.

Explanation

Correct Answers

C:

Implement retrieval-augmented generation using approved current SQL policy records with source citations. A finance assistant must answer questions about changing payment policy and the team proposes updating model weights whenever the policy changes.

E:

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. Implement retrieval-augmented generation using approved current SQL policy records with source citations.

Incorrect Answers

A:

Require an explicit evidence threshold and safe refusal or escalation when retrieval finds no current supporting clause. 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.

B:

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. Implement retrieval-augmented generation using approved current SQL policy records with source citations.

D:

Parse and validate the returned model response envelope and expected JSON fields before storing results. 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 93

A database team embeds unredacted personal case notes into a vector store and assumes the result cannot expose personal information because it is numeric. Which next step most directly resolves this SQL solution issue?

  1. Classify and minimize data before embedding and protect vector storage and retrieval with appropriate permissions.
  2. Separate migrations into a controlled deployment identity and grant the runtime only needed object operations.
  3. Add appropriate query/activity monitoring and tested audit correlation without logging unnecessary sensitive payloads.
  4. Implement database-enforced row-level security using an appropriate security predicate and trustworthy session identity.

Explanation

Correct Answer

A:

Classify and minimize data before embedding and protect vector storage and retrieval with appropriate permissions. Embeddings can retain sensitive information relationships and must follow the underlying data governance.

Incorrect Answers

B:

Separate migrations into a controlled deployment identity and grant the runtime only needed object operations. Embeddings can retain sensitive information relationships and must follow the underlying data governance. Classify and minimize data before embedding and protect vector storage and retrieval with appropriate permissions.

C:

Add appropriate query/activity monitoring and tested audit correlation without logging unnecessary sensitive payloads. Embeddings can retain sensitive information relationships and must follow the underlying data governance. Classify and minimize data before embedding and protect vector storage and retrieval with appropriate permissions.

D:

Implement database-enforced row-level security using an appropriate security predicate and trustworthy session identity. Embeddings can retain sensitive information relationships and must follow the underlying data governance. Classify and minimize data before embedding and protect vector storage and retrieval with appropriate permissions.

Question 94

An ecommerce API filters orders by tenant and status then sorts by creation time but its primary-key index alone does not support that access path. Which TWO options together specify a corrective step and a meaningful test?

  1. After a tested maintenance change analytic scan cost improves and freshness commitments hold.
  2. Design a targeted nonclustered index with an appropriate key order and included output columns after measuring the workload.
  3. Design a governed temporal retention and deletion procedure across current and historical data.
  4. The targeted query performs a selective seek with fewer reads and without an unacceptable write penalty.
  5. Evaluate system-versioned temporal tables with history retention and appropriate access controls.

Explanation

Correct Answers

B:

Design a targeted nonclustered index with an appropriate key order and included output columns after measuring the workload. An ecommerce API filters orders by tenant and status then sorts by creation time but its primary-key index alone does not support that access path.

D:

The targeted query performs a selective seek with fewer reads and without an unacceptable write penalty. An ecommerce API filters orders by tenant and status then sorts by creation time but its primary-key index alone does not support that access path.

Incorrect Answers

A:

After a tested maintenance change analytic scan cost improves and freshness commitments hold. An ecommerce API filters orders by tenant and status then sorts by creation time but its primary-key index alone does not support that access path. The targeted query performs a selective seek with fewer reads and without an unacceptable write penalty.

C:

Design a governed temporal retention and deletion procedure across current and historical data. An ecommerce API filters orders by tenant and status then sorts by creation time but its primary-key index alone does not support that access path. Design a targeted nonclustered index with an appropriate key order and included output columns after measuring the workload.

E:

Evaluate system-versioned temporal tables with history retention and appropriate access controls. An ecommerce API filters orders by tenant and status then sorts by creation time but its primary-key index alone does not support that access path. Design a targeted nonclustered index with an appropriate key order and included output columns after measuring the workload.

Question 95

A database team knows only that an Azure SQL service is slower after peak traffic but does not know which query consumes resources. What should the database developer do FIRST within approved procedures?

  1. Use live DMVs, wait information, and deadlock evidence to distinguish blocking chains from actual cyclic deadlocks.
  2. Use available query performance insights, Query Store, and relevant DMVs to identify the top regressed statements.
  3. Analyze the deadlock graph and standardize access order or shorten transactions based on evidence.
  4. Choose transactional locking or isolation that enforces the reservation invariant under concurrency.

Explanation

Correct Answer

B:

Use available query performance insights, Query Store, and relevant DMVs to identify the top regressed statements. Performance tuning should begin with measured high-impact queries rather than random configuration changes.

Incorrect Answers

A:

Use live DMVs, wait information, and deadlock evidence to distinguish blocking chains from actual cyclic deadlocks. Performance tuning should begin with measured high-impact queries rather than random configuration changes. Use available query performance insights, Query Store, and relevant DMVs to identify the top regressed statements.

C:

Analyze the deadlock graph and standardize access order or shorten transactions based on evidence. Performance tuning should begin with measured high-impact queries rather than random configuration changes. Use available query performance insights, Query Store, and relevant DMVs to identify the top regressed statements.

D:

Choose transactional locking or isolation that enforces the reservation invariant under concurrency. Performance tuning should begin with measured high-impact queries rather than random configuration changes. Use available query performance insights, Query Store, and relevant DMVs to identify the top regressed statements.

Question 96

A shared SQL table stores tickets for many clients and an application bug omits its WHERE tenant predicate. What should the database developer verify to confirm the suspected cause?

  1. A database support login can read every salary directly in plaintext despite lacking a payroll role.
  2. A direct query by a client login returns tickets belonging to a different tenant.
  3. An API caller can request an unintended entity that the deployment identity can also read.
  4. Application credential inspection shows ALTER and DROP privileges over unrelated schema objects.

Explanation

Correct Answer

B:

A direct query by a client login returns tickets belonging to a different tenant. Row-level security enforces data visibility in the database independently of application query discipline.

Incorrect Answers

A:

A database support login can read every salary directly in plaintext despite lacking a payroll role. Row-level security enforces data visibility in the database independently of application query discipline. A direct query by a client login returns tickets belonging to a different tenant.

C:

An API caller can request an unintended entity that the deployment identity can also read. Row-level security enforces data visibility in the database independently of application query discipline. A direct query by a client login returns tickets belonging to a different tenant.

D:

Application credential inspection shows ALTER and DROP privileges over unrelated schema objects. Row-level security enforces data visibility in the database independently of application query discipline. A direct query by a client login returns tickets belonging to a different tenant.

Question 97

A regulated supplier wants independently verifiable evidence that recorded transaction adjustments have not been silently altered after approval. 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 targeted nonclustered index with an appropriate key order and included output columns after measuring the workload.
  3. Evaluate ledger table capabilities and secure digest verification while maintaining role-based write controls.
  4. Check native JSON indexing support or use a supported indexed computed-property strategy where appropriate.

Explanation

Correct Answer

C:

Evaluate ledger table capabilities and secure digest verification while maintaining role-based write controls. Ledger features provide tamper-evidence verification but do not replace authorization or backups.

Incorrect Answers

A:

Keep a row-oriented transactional design for the hot selective workload and benchmark analytical indexes separately. Ledger features provide tamper-evidence verification but do not replace authorization or backups. Evaluate ledger table capabilities and secure digest verification while maintaining role-based write controls.

B:

Design a targeted nonclustered index with an appropriate key order and included output columns after measuring the workload. Ledger features provide tamper-evidence verification but do not replace authorization or backups. Evaluate ledger table capabilities and secure digest verification while maintaining role-based write controls.

D:

Check native JSON indexing support or use a supported indexed computed-property strategy where appropriate. Ledger features provide tamper-evidence verification but do not replace authorization or backups. Evaluate ledger table capabilities and secure digest verification while maintaining role-based write controls.

Question 98

An ecommerce API filters orders by tenant and status then sorts by creation time but its primary-key index alone does not support that access path. What would be a valid post-database-change verification?

  1. The targeted query performs a selective seek with fewer reads and without an unacceptable write penalty.
  2. Queries find the correct risk values with less CPU and no loss of document validity.
  3. Concurrent test inserts receive distinct identifiers and the business accepts documented gaps.
  4. Each tenant has unique invoice codes while other tenants can reuse the same code safely.

Explanation

Correct Answer

A:

The targeted query performs a selective seek with fewer reads and without an unacceptable write penalty.

Incorrect Answers

B:

Queries find the correct risk values with less CPU and no loss of document validity. The targeted query performs a selective seek with fewer reads and without an unacceptable write penalty.

C:

Concurrent test inserts receive distinct identifiers and the business accepts documented gaps. The targeted query performs a selective seek with fewer reads and without an unacceptable write penalty.

D:

Each tenant has unique invoice codes while other tenants can reuse the same code safely. The targeted query performs a selective seek with fewer reads and without an unacceptable write penalty.

Question 99

An update trigger writes back to the same customer table and some releases cause chains of repeated updates and log expansion. Which technical principle explains the correct response?

  1. Procedure performance can vary with parameter cardinality even when SQL text is unchanged.
  2. Set-based SQL processing can avoid per-row procedural overhead when the function is compatible.
  3. Triggers execute within database write workflows and need safeguards against recursion and broad unintended effects.
  4. Parameterization does not itself establish a row-level security boundary.

Explanation

Correct Answer

C:

Triggers execute within database write workflows and need safeguards against recursion and broad unintended effects.

Incorrect Answers

A:

Procedure performance can vary with parameter cardinality even when SQL text is unchanged. Triggers execute within database write workflows and need safeguards against recursion and broad unintended effects.

B:

Set-based SQL processing can avoid per-row procedural overhead when the function is compatible. Triggers execute within database write workflows and need safeguards against recursion and broad unintended effects.

D:

Parameterization does not itself establish a row-level security boundary. Triggers execute within database write workflows and need safeguards against recursion and broad unintended effects.

Question 100

A developer commits an Azure SQL connection string with a password into a pipeline YAML and then deletes the line after review. Which technical principle explains the correct response?

  1. Schema changes can be structurally valid yet unsafe for existing data.
  2. A project needs explicit versioned dependencies to support repeatable builds.
  3. Schema drift must be detected before a declarative project deployment changes production objects.
  4. Deleting a committed secret does not remove the exposure or replace credential rotation.

Explanation

Correct Answer

D:

Deleting a committed secret does not remove the exposure or replace credential rotation.

Incorrect Answers

A:

Schema changes can be structurally valid yet unsafe for existing data. Deleting a committed secret does not remove the exposure or replace credential rotation.

B:

A project needs explicit versioned dependencies to support repeatable builds. Deleting a committed secret does not remove the exposure or replace credential rotation.

C:

Schema drift must be detected before a declarative project deployment changes production objects. Deleting a committed secret does not remove the exposure or replace credential rotation.

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