Pass Microsoft Azure Data DP-900 Exam in First Attempt Easily
Real Microsoft Azure Data DP-900 Exam Questions, Accurate & Verified Answers As Experienced in the Actual Test!

Verified by experts
3 products

You save $69.98

DP-900 Premium Bundle

  • Premium File 332 Questions & Answers
  • Last Update: Nov 14, 2026
  • Training Course 32 Lectures
  • Study Guide 672 Pages
$79.99 $149.97

Purchase Individually

  • Premium File

    332 Questions & Answers
    Last Update: Nov 14, 2026

    $76.99
    $69.99
  • Training Course

    32 Lectures

    $43.99
    $39.99
  • Study Guide

    672 Pages

    $43.99
    $39.99

Microsoft Azure Data Fundamentals DP-900 Practice Test 28

Question 270

A service must respond to inserted and updated Cosmos DB items without repeatedly scanning every stored document. A team proposes: Use the Cosmos DB change feed to consume relevant item changes. Which observation would BEST demonstrate that this exact requirement was met?

  1. A consumer receives new changes in order within the supported change-feed semantics.
  2. A point read obtains the intended item with a smaller measurable request charge.
  3. Existing MongoDB client operations function under the tested protocol compatibility subset.
  4. The CQL client reads and writes data using supported Cassandra operations.

Explanation

Correct Answer

A:

A consumer receives new changes in order within the supported change-feed semantics. Change feed surfaces committed data changes to downstream processors. It is tied to this case: A service must respond to inserted and updated Cosmos DB items without repeatedly scanning every stored document.

Incorrect Answers

B:

A point read obtains the intended item with a smaller measurable request charge. This would validate a different scenario: A distributed service sees unusually costly Cosmos DB queries that scan every customer partition despite always knowing CustomerId. The proposed change here is Use the Cosmos DB change feed to consume relevant item changes. and its decisive acceptance check is A consumer receives new changes in order within the supported change-feed semantics.

C:

Existing MongoDB client operations function under the tested protocol compatibility subset. This would validate a different scenario: An existing application uses MongoDB drivers and query syntax and needs a compatible managed Azure service. The proposed change here is Use the Cosmos DB change feed to consume relevant item changes. and its decisive acceptance check is A consumer receives new changes in order within the supported change-feed semantics.

D:

The CQL client reads and writes data using supported Cassandra operations. This would validate a different scenario: A legacy wide-column application uses Cassandra Query Language and needs a compatible globally distributed cloud endpoint. The proposed change here is Use the Cosmos DB change feed to consume relevant item changes. and its decisive acceptance check is A consumer receives new changes in order within the supported change-feed semantics.

Question 271

During an architecture review, the team proposes: Use the Cosmos DB change feed to consume relevant item changes. The requirement is: A service must respond to inserted and updated Cosmos DB items without repeatedly scanning every stored document. Which technical explanation BEST justifies this specific recommendation?

  1. Cosmos DB request units measure throughput consumption; key-based access can be efficient.
  2. Change feed surfaces committed data changes to downstream processors.
  3. Cosmos DB for MongoDB exposes MongoDB-compatible interfaces.
  4. The Cassandra API provides compatibility for Cassandra-style wide-column clients.

Explanation

Correct Answer

B:

Change feed surfaces committed data changes to downstream processors. Evidence would be: A consumer receives new changes in order within the supported change-feed semantics. The choice avoids this risk: Polling full containers for every change wastes requests and can increase detection delay.

Incorrect Answers

A:

Cosmos DB request units measure throughput consumption; key-based access can be efficient. That principle applies to the separate requirement: A distributed service sees unusually costly Cosmos DB queries that scan every customer partition despite always knowing CustomerId. It may be true in that setting, but does not specifically explain why Use the Cosmos DB change feed to consume relevant item changes. is the best fit here. The relevant reason is Change feed surfaces committed data changes to downstream processors.

C:

Cosmos DB for MongoDB exposes MongoDB-compatible interfaces. That principle applies to the separate requirement: An existing application uses MongoDB drivers and query syntax and needs a compatible managed Azure service. It may be true in that setting, but does not specifically explain why Use the Cosmos DB change feed to consume relevant item changes. is the best fit here. The relevant reason is Change feed surfaces committed data changes to downstream processors.

D:

The Cassandra API provides compatibility for Cassandra-style wide-column clients. That principle applies to the separate requirement: A legacy wide-column application uses Cassandra Query Language and needs a compatible globally distributed cloud endpoint. It may be true in that setting, but does not specifically explain why Use the Cosmos DB change feed to consume relevant item changes. is the best fit here. The relevant reason is Change feed surfaces committed data changes to downstream processors.

Question 272

A service must respond to inserted and updated Cosmos DB items without repeatedly scanning every stored document. If the team ignores the targeted approach (Use the Cosmos DB change feed to consume relevant item changes.), which consequence or limitation MOST directly follows from leaving that requirement unaddressed?

  1. Cross-partition scans use more resources when the partition and id are already known.
  2. Selecting the API for NoSQL without adapting the driver may break MongoDB wire-protocol expectations.
  3. Polling full containers for every change wastes requests and can increase detection delay.
  4. A MongoDB interface does not automatically accept Cassandra Query Language.

Explanation

Correct Answer

C:

Polling full containers for every change wastes requests and can increase detection delay. This risk follows from the exact scenario: A service must respond to inserted and updated Cosmos DB items without repeatedly scanning every stored document. The reason is change feed surfaces committed data changes to downstream processors. The direct mitigation is: Use the Cosmos DB change feed to consume relevant item changes.

Incorrect Answers

A:

Cross-partition scans use more resources when the partition and id are already known. This is a real potential problem in a different scenario: A distributed service sees unusually costly Cosmos DB queries that scan every customer partition despite always knowing CustomerId. The present case instead concerns A service must respond to inserted and updated Cosmos DB items without repeatedly scanning every stored document. With the targeted action omitted, the direct exposure is Polling full containers for every change wastes requests and can increase detection delay.

B:

Selecting the API for NoSQL without adapting the driver may break MongoDB wire-protocol expectations. This is a real potential problem in a different scenario: An existing application uses MongoDB drivers and query syntax and needs a compatible managed Azure service. The present case instead concerns A service must respond to inserted and updated Cosmos DB items without repeatedly scanning every stored document. With the targeted action omitted, the direct exposure is Polling full containers for every change wastes requests and can increase detection delay.

D:

A MongoDB interface does not automatically accept Cassandra Query Language. This is a real potential problem in a different scenario: A legacy wide-column application uses Cassandra Query Language and needs a compatible globally distributed cloud endpoint. The present case instead concerns A service must respond to inserted and updated Cosmos DB items without repeatedly scanning every stored document. With the targeted action omitted, the direct exposure is Polling full containers for every change wastes requests and can increase detection delay.

Question 273

A distributed service sees unusually costly Cosmos DB queries that scan every customer partition despite always knowing CustomerId. Which solution or configuration choice MOST directly satisfies the stated requirement without changing unrelated behavior?

  1. Include the relevant partition key in targeted item lookups and review RU charges.
  2. Use Azure Cosmos DB for NoSQL with an appropriate partition key.
  3. Use the Azure Cosmos DB API for Apache Gremlin for graph-oriented access.
  4. Consider Azure Cosmos DB API for Apache Cassandra with verified CQL compatibility.

Explanation

Correct Answer

A:

Include the relevant partition key in targeted item lookups and review RU charges. This directly addresses the case: A distributed service sees unusually costly Cosmos DB queries that scan every customer partition despite always knowing CustomerId. The deciding technical reason is that cosmos DB request units measure throughput consumption; key-based access can be efficient. Verify the solution by checking: A point read obtains the intended item with a smaller measurable request charge.

Incorrect Answers

B:

Use Azure Cosmos DB for NoSQL with an appropriate partition key. This is a legitimate approach for a different problem: A globally distributed app stores flexible JSON shopping carts and must scale without a fixed relational schema. Cosmos DB for NoSQL stores JSON items in partitioned containers. It does not directly satisfy the present constraint: A distributed service sees unusually costly Cosmos DB queries that scan every customer partition despite always knowing CustomerId. The needed outcome is: A point read obtains the intended item with a smaller measurable request charge.

C:

Use the Azure Cosmos DB API for Apache Gremlin for graph-oriented access. This is a legitimate approach for a different problem: A connected-fraud model stores customers and transaction-to-account edges and queries multi-hop relationships. Gremlin models vertices, edges, and traversals for graph workloads. It does not directly satisfy the present constraint: A distributed service sees unusually costly Cosmos DB queries that scan every customer partition despite always knowing CustomerId. The needed outcome is: A point read obtains the intended item with a smaller measurable request charge.

D:

Consider Azure Cosmos DB API for Apache Cassandra with verified CQL compatibility. This is a legitimate approach for a different problem: A legacy wide-column application uses Cassandra Query Language and needs a compatible globally distributed cloud endpoint. The Cassandra API provides compatibility for Cassandra-style wide-column clients. It does not directly satisfy the present constraint: A distributed service sees unusually costly Cosmos DB queries that scan every customer partition despite always knowing CustomerId. The needed outcome is: A point read obtains the intended item with a smaller measurable request charge.

Question 274

A distributed service sees unusually costly Cosmos DB queries that scan every customer partition despite always knowing CustomerId. A team proposes: Include the relevant partition key in targeted item lookups and review RU charges. Which observation would BEST demonstrate that this exact requirement was met?

  1. Cart documents with optional properties are read by the app at the designed global scale.
  2. A point read obtains the intended item with a smaller measurable request charge.
  3. A Gremlin traversal finds connected entities across recorded edges.
  4. The CQL client reads and writes data using supported Cassandra operations.

Explanation

Correct Answer

B:

A point read obtains the intended item with a smaller measurable request charge. Cosmos DB request units measure throughput consumption; key-based access can be efficient. It is tied to this case: A distributed service sees unusually costly Cosmos DB queries that scan every customer partition despite always knowing CustomerId.

Incorrect Answers

A:

Cart documents with optional properties are read by the app at the designed global scale. This would validate a different scenario: A globally distributed app stores flexible JSON shopping carts and must scale without a fixed relational schema. The proposed change here is Include the relevant partition key in targeted item lookups and review RU charges. and its decisive acceptance check is A point read obtains the intended item with a smaller measurable request charge.

C:

A Gremlin traversal finds connected entities across recorded edges. This would validate a different scenario: A connected-fraud model stores customers and transaction-to-account edges and queries multi-hop relationships. The proposed change here is Include the relevant partition key in targeted item lookups and review RU charges. and its decisive acceptance check is A point read obtains the intended item with a smaller measurable request charge.

D:

The CQL client reads and writes data using supported Cassandra operations. This would validate a different scenario: A legacy wide-column application uses Cassandra Query Language and needs a compatible globally distributed cloud endpoint. The proposed change here is Include the relevant partition key in targeted item lookups and review RU charges. and its decisive acceptance check is A point read obtains the intended item with a smaller measurable request charge.

Question 275

During an architecture review, the team proposes: Include the relevant partition key in targeted item lookups and review RU charges. The requirement is: A distributed service sees unusually costly Cosmos DB queries that scan every customer partition despite always knowing CustomerId. Which technical explanation BEST justifies this specific recommendation?

  1. Cosmos DB for NoSQL stores JSON items in partitioned containers.
  2. Gremlin models vertices, edges, and traversals for graph workloads.
  3. Cosmos DB request units measure throughput consumption; key-based access can be efficient.
  4. The Cassandra API provides compatibility for Cassandra-style wide-column clients.

Explanation

Correct Answer

C:

Cosmos DB request units measure throughput consumption; key-based access can be efficient. Evidence would be: A point read obtains the intended item with a smaller measurable request charge. The choice avoids this risk: Cross-partition scans use more resources when the partition and id are already known.

Incorrect Answers

A:

Cosmos DB for NoSQL stores JSON items in partitioned containers. That principle applies to the separate requirement: A globally distributed app stores flexible JSON shopping carts and must scale without a fixed relational schema. It may be true in that setting, but does not specifically explain why Include the relevant partition key in targeted item lookups and review RU charges. is the best fit here. The relevant reason is Cosmos DB request units measure throughput consumption; key-based access can be efficient.

B:

Gremlin models vertices, edges, and traversals for graph workloads. That principle applies to the separate requirement: A connected-fraud model stores customers and transaction-to-account edges and queries multi-hop relationships. It may be true in that setting, but does not specifically explain why Include the relevant partition key in targeted item lookups and review RU charges. is the best fit here. The relevant reason is Cosmos DB request units measure throughput consumption; key-based access can be efficient.

D:

The Cassandra API provides compatibility for Cassandra-style wide-column clients. That principle applies to the separate requirement: A legacy wide-column application uses Cassandra Query Language and needs a compatible globally distributed cloud endpoint. It may be true in that setting, but does not specifically explain why Include the relevant partition key in targeted item lookups and review RU charges. is the best fit here. The relevant reason is Cosmos DB request units measure throughput consumption; key-based access can be efficient.

Question 276

A distributed service sees unusually costly Cosmos DB queries that scan every customer partition despite always knowing CustomerId. If the team ignores the targeted approach (Include the relevant partition key in targeted item lookups and review RU charges.), which consequence or limitation MOST directly follows from leaving that requirement unaddressed?

  1. Assuming every document has an identical set of relational columns undermines the flexible schema requirement.
  2. Storing the edges only as unrelated flat key-value rows makes graph traversals cumbersome.
  3. A MongoDB interface does not automatically accept Cassandra Query Language.
  4. Cross-partition scans use more resources when the partition and id are already known.

Explanation

Correct Answer

D:

Cross-partition scans use more resources when the partition and id are already known. This risk follows from the exact scenario: A distributed service sees unusually costly Cosmos DB queries that scan every customer partition despite always knowing CustomerId. The reason is cosmos DB request units measure throughput consumption; key-based access can be efficient. The direct mitigation is: Include the relevant partition key in targeted item lookups and review RU charges.

Incorrect Answers

A:

Assuming every document has an identical set of relational columns undermines the flexible schema requirement. This is a real potential problem in a different scenario: A globally distributed app stores flexible JSON shopping carts and must scale without a fixed relational schema. The present case instead concerns A distributed service sees unusually costly Cosmos DB queries that scan every customer partition despite always knowing CustomerId. With the targeted action omitted, the direct exposure is Cross-partition scans use more resources when the partition and id are already known.

B:

Storing the edges only as unrelated flat key-value rows makes graph traversals cumbersome. This is a real potential problem in a different scenario: A connected-fraud model stores customers and transaction-to-account edges and queries multi-hop relationships. The present case instead concerns A distributed service sees unusually costly Cosmos DB queries that scan every customer partition despite always knowing CustomerId. With the targeted action omitted, the direct exposure is Cross-partition scans use more resources when the partition and id are already known.

C:

A MongoDB interface does not automatically accept Cassandra Query Language. This is a real potential problem in a different scenario: A legacy wide-column application uses Cassandra Query Language and needs a compatible globally distributed cloud endpoint. The present case instead concerns A distributed service sees unusually costly Cosmos DB queries that scan every customer partition despite always knowing CustomerId. With the targeted action omitted, the direct exposure is Cross-partition scans use more resources when the partition and id are already known.

Question 277

An enterprise configures multiple Cosmos DB regions and needs low-latency reads near international users. Which solution or configuration choice MOST directly satisfies the stated requirement without changing unrelated behavior?

  1. Choose a Cosmos DB consistency setting based on the actual correctness and latency requirement.
  2. Replicate the Cosmos DB account to selected regions and choose suitable read routing and consistency.
  3. Choose the Azure Cosmos DB API for MongoDB option compatible with the application.
  4. Consider Azure Cosmos DB API for Apache Cassandra with verified CQL compatibility.

Explanation

Correct Answer

B:

Replicate the Cosmos DB account to selected regions and choose suitable read routing and consistency. This directly addresses the case: An enterprise configures multiple Cosmos DB regions and needs low-latency reads near international users. The deciding technical reason is that cosmos DB supports global distribution and configurable consistency across regions. Verify the solution by checking: Readers in the configured regions use the designed replica path with documented consistency.

Incorrect Answers

A:

Choose a Cosmos DB consistency setting based on the actual correctness and latency requirement. This is a legitimate approach for a different problem: A global booking application needs to balance consistent reads against latency and availability for distributed clients. Cosmos DB exposes configurable consistency models with differing guarantees. It does not directly satisfy the present constraint: An enterprise configures multiple Cosmos DB regions and needs low-latency reads near international users. The needed outcome is: Readers in the configured regions use the designed replica path with documented consistency.

C:

Choose the Azure Cosmos DB API for MongoDB option compatible with the application. This is a legitimate approach for a different problem: An existing application uses MongoDB drivers and query syntax and needs a compatible managed Azure service. Cosmos DB for MongoDB exposes MongoDB-compatible interfaces. It does not directly satisfy the present constraint: An enterprise configures multiple Cosmos DB regions and needs low-latency reads near international users. The needed outcome is: Readers in the configured regions use the designed replica path with documented consistency.

D:

Consider Azure Cosmos DB API for Apache Cassandra with verified CQL compatibility. This is a legitimate approach for a different problem: A legacy wide-column application uses Cassandra Query Language and needs a compatible globally distributed cloud endpoint. The Cassandra API provides compatibility for Cassandra-style wide-column clients. It does not directly satisfy the present constraint: An enterprise configures multiple Cosmos DB regions and needs low-latency reads near international users. The needed outcome is: Readers in the configured regions use the designed replica path with documented consistency.

Question 278

An enterprise configures multiple Cosmos DB regions and needs low-latency reads near international users. A team proposes: Replicate the Cosmos DB account to selected regions and choose suitable read routing and consistency. Which observation would BEST demonstrate that this exact requirement was met?

  1. A read-consistency test demonstrates the permitted staleness and ordering behavior.
  2. Existing MongoDB client operations function under the tested protocol compatibility subset.
  3. Readers in the configured regions use the designed replica path with documented consistency.
  4. The CQL client reads and writes data using supported Cassandra operations.

Explanation

Correct Answer

C:

Readers in the configured regions use the designed replica path with documented consistency. Cosmos DB supports global distribution and configurable consistency across regions. It is tied to this case: An enterprise configures multiple Cosmos DB regions and needs low-latency reads near international users.

Incorrect Answers

A:

A read-consistency test demonstrates the permitted staleness and ordering behavior. This would validate a different scenario: A global booking application needs to balance consistent reads against latency and availability for distributed clients. The proposed change here is Replicate the Cosmos DB account to selected regions and choose suitable read routing and consistency. and its decisive acceptance check is Readers in the configured regions use the designed replica path with documented consistency.

B:

Existing MongoDB client operations function under the tested protocol compatibility subset. This would validate a different scenario: An existing application uses MongoDB drivers and query syntax and needs a compatible managed Azure service. The proposed change here is Replicate the Cosmos DB account to selected regions and choose suitable read routing and consistency. and its decisive acceptance check is Readers in the configured regions use the designed replica path with documented consistency.

D:

The CQL client reads and writes data using supported Cassandra operations. This would validate a different scenario: A legacy wide-column application uses Cassandra Query Language and needs a compatible globally distributed cloud endpoint. The proposed change here is Replicate the Cosmos DB account to selected regions and choose suitable read routing and consistency. and its decisive acceptance check is Readers in the configured regions use the designed replica path with documented consistency.

Question 279

During an architecture review, the team proposes: Replicate the Cosmos DB account to selected regions and choose suitable read routing and consistency. The requirement is: An enterprise configures multiple Cosmos DB regions and needs low-latency reads near international users. Which technical explanation BEST justifies this specific recommendation?

  1. Cosmos DB exposes configurable consistency models with differing guarantees.
  2. Cosmos DB for MongoDB exposes MongoDB-compatible interfaces.
  3. The Cassandra API provides compatibility for Cassandra-style wide-column clients.
  4. Cosmos DB supports global distribution and configurable consistency across regions.

Explanation

Correct Answer

D:

Cosmos DB supports global distribution and configurable consistency across regions. Evidence would be: Readers in the configured regions use the designed replica path with documented consistency. The choice avoids this risk: A single distant region cannot automatically provide the same regional data locality.

Incorrect Answers

A:

Cosmos DB exposes configurable consistency models with differing guarantees. That principle applies to the separate requirement: A global booking application needs to balance consistent reads against latency and availability for distributed clients. It may be true in that setting, but does not specifically explain why Replicate the Cosmos DB account to selected regions and choose suitable read routing and consistency. is the best fit here. The relevant reason is Cosmos DB supports global distribution and configurable consistency across regions.

B:

Cosmos DB for MongoDB exposes MongoDB-compatible interfaces. That principle applies to the separate requirement: An existing application uses MongoDB drivers and query syntax and needs a compatible managed Azure service. It may be true in that setting, but does not specifically explain why Replicate the Cosmos DB account to selected regions and choose suitable read routing and consistency. is the best fit here. The relevant reason is Cosmos DB supports global distribution and configurable consistency across regions.

C:

The Cassandra API provides compatibility for Cassandra-style wide-column clients. That principle applies to the separate requirement: A legacy wide-column application uses Cassandra Query Language and needs a compatible globally distributed cloud endpoint. It may be true in that setting, but does not specifically explain why Replicate the Cosmos DB account to selected regions and choose suitable read routing and consistency. is the best fit here. The relevant reason is Cosmos DB supports global distribution and configurable consistency across regions.

Question 280

An enterprise configures multiple Cosmos DB regions and needs low-latency reads near international users. If the team ignores the targeted approach (Replicate the Cosmos DB account to selected regions and choose suitable read routing and consistency.), which consequence or limitation MOST directly follows from leaving that requirement unaddressed?

  1. A single distant region cannot automatically provide the same regional data locality.
  2. Assuming all consistency levels provide identical latency and guarantees can break business expectations.
  3. Selecting the API for NoSQL without adapting the driver may break MongoDB wire-protocol expectations.
  4. A MongoDB interface does not automatically accept Cassandra Query Language.

Explanation

Correct Answer

A:

A single distant region cannot automatically provide the same regional data locality. This risk follows from the exact scenario: An enterprise configures multiple Cosmos DB regions and needs low-latency reads near international users. The reason is cosmos DB supports global distribution and configurable consistency across regions. The direct mitigation is: Replicate the Cosmos DB account to selected regions and choose suitable read routing and consistency.

Incorrect Answers

B:

Assuming all consistency levels provide identical latency and guarantees can break business expectations. This is a real potential problem in a different scenario: A global booking application needs to balance consistent reads against latency and availability for distributed clients. The present case instead concerns An enterprise configures multiple Cosmos DB regions and needs low-latency reads near international users. With the targeted action omitted, the direct exposure is A single distant region cannot automatically provide the same regional data locality.

C:

Selecting the API for NoSQL without adapting the driver may break MongoDB wire-protocol expectations. This is a real potential problem in a different scenario: An existing application uses MongoDB drivers and query syntax and needs a compatible managed Azure service. The present case instead concerns An enterprise configures multiple Cosmos DB regions and needs low-latency reads near international users. With the targeted action omitted, the direct exposure is A single distant region cannot automatically provide the same regional data locality.

D:

A MongoDB interface does not automatically accept Cassandra Query Language. This is a real potential problem in a different scenario: A legacy wide-column application uses Cassandra Query Language and needs a compatible globally distributed cloud endpoint. The present case instead concerns An enterprise configures multiple Cosmos DB regions and needs low-latency reads near international users. With the targeted action omitted, the direct exposure is A single distant region cannot automatically provide the same regional data locality.

Microsoft Azure Data Fundamentals (DP-900) Practice Tests

Purchase Individually

  • Premium File

    332 Questions & Answers
    Last Update: Nov 14, 2026

    $76.99
    $69.99
  • Training Course

    32 Lectures

    $43.99
    $39.99
  • Study Guide

    672 Pages

    $43.99
    $39.99

SPECIAL OFFER: GET 10% OFF
This is ONE TIME OFFER

You save
10%

Enter Your Email Address to Receive Your 10% Off Discount Code

SPECIAL OFFER: GET 10% OFF

You save
10%

Use Discount Code:

A confirmation link was sent to your e-mail.

Please check your mailbox for a message from support@examlabs.com and follow the directions.

Download Free Demo of VCE Exam Simulator

Experience Avanset VCE Exam Simulator for yourself.

Simply submit your email address below to get started with our interactive software demo of your free trial.

  • Realistic exam simulation and exam editor with preview functions
  • Whole exam in a single file with several different question types
  • Customizable exam-taking mode & detailed score reports