McAfee-Secured Website

Exam Bundle

Exam Code: DP-900

Exam Name Microsoft Azure Data Fundamentals

Certification Provider: Microsoft

Corresponding Certification: Microsoft Certified: Azure Data Fundamentals

Microsoft DP-900 Bundle $25.00

100% Microsoft DP-900 Guaranteed Success With Testking Training Materials

Get Real DP-900 Exam Questions & Expert Verified Answers as Experienced on the Real Exam!

  • Questions & Answers

    DP-900 Questions & Answers

    332 Questions & Answers

    The ultimate exam preparation tool, Questions & Answers mirrors the actual DP-900 exam while allowing you to hone and measure every aspect of your test-taking ability.

  • DP-900 Video Course

    DP-900 Video Course

    32 Video Lectures

    DP-900 Video Course is developed by Microsoft Professionals to help you pass the DP-900 exam.

    Description

    This course will improve your knowledge and skills required to pass Microsoft Azure Data Fundamentals exam.

Microsoft Azure Data Fundamentals (DP-900) Practice Tests

Satisfaction Guaranteed

Money Back Guarantee

Testking provides hassle-free money back guarantee with our products. That is because we have 100% trust in the abilities of our professional and experience product team, and our record is a proof of that.

99.6% PASS RATE
Total Cost: $164.98
Bundle Price: $139.98

Purchase Individually

  • Questions & Answers

    Questions & Answers

    332 Questions

    $124.99
  • DP-900 Video Course

    Video Course

    32 Video Lectures

    $39.99

Microsoft DP-900 Practice Test 56

Question 550

A data professional makes this decision: Consume the supported Azure Cosmos DB change feed. Which outcome is the most direct expected result?

  1. Applications can process a stream of document changes incrementally.
  2. The service provides an Azure-managed option compatible with the selected MongoDB driver model.
  3. Document properties can be filtered and projected with the service's query syntax.
  4. Traffic can spread more evenly across the container's available resources.

Explanation

Correct Answer

A:

This is the expected outcome for Change feed: Applications can process a stream of document changes incrementally.

Incorrect Answers

B:

This result would follow the different MongoDB compatibility decision (Choose Azure Cosmos DB for MongoDB vCore or the supported MongoDB API offering according to workload requirements.) rather than the specified design.

C:

This result would follow the different Cosmos SQL query decision (Use the Azure Cosmos DB for NoSQL SQL-like query language.) rather than the specified design.

D:

This result would follow the different Hot partition risk decision (Redesign the partitioning or access pattern to avoid a heavily skewed key.) rather than the specified design.

Question 551

A microservice needs to react when documents are inserted or updated in a Cosmos DB container. Someone instead proposes: Choose Azure Cosmos DB for MongoDB vCore or the supported MongoDB API offering according to workload requirements. Which alternative is the best correction for the original requirement?

  1. Use the Azure Cosmos DB for NoSQL SQL-like query language.
  2. Consume the supported Azure Cosmos DB change feed.
  3. Redesign the partitioning or access pattern to avoid a heavily skewed key.
  4. Choose Azure Cosmos DB for MongoDB vCore or the supported MongoDB API offering according to workload requirements.

Explanation

Correct Answer

B:

This correction addresses Change feed. Applications can process a stream of document changes incrementally.

Incorrect Answers

A:

This choice is for Cosmos SQL query, not the specific requirement. Document properties can be filtered and projected with the service's query syntax.

C:

This choice is for Hot partition risk, not the specific requirement. Traffic can spread more evenly across the container's available resources.

D:

This choice is for MongoDB compatibility, not the specific requirement. The service provides an Azure-managed option compatible with the selected MongoDB driver model.

Question 552

A data architect recommends this approach: Consume the supported Azure Cosmos DB change feed. Which situation most clearly calls for that approach?

  1. An app needs to filter JSON documents by an indexed property and project selected fields.
  2. One partition key value receives almost all requests while other values receive very few.
  3. A microservice needs to react when documents are inserted or updated in a Cosmos DB container.
  4. A development team wants an Azure globally distributed database accessed through compatible MongoDB client APIs.

Explanation

Correct Answer

C:

This situation calls for Change feed. Applications can process a stream of document changes incrementally.

Incorrect Answers

A:

The other situation is better matched to Use the Azure Cosmos DB for NoSQL SQL-like query language. Document properties can be filtered and projected with the service's query syntax.

B:

The other situation is better matched to Redesign the partitioning or access pattern to avoid a heavily skewed key. Traffic can spread more evenly across the container's available resources.

D:

The other situation is better matched to Choose Azure Cosmos DB for MongoDB vCore or the supported MongoDB API offering according to workload requirements. The service provides an Azure-managed option compatible with the selected MongoDB driver model.

Question 553

A developer confuses Cosmos DB accounts, databases, containers and individual items. Which data concept, Azure service, or design decision most directly satisfies the requirement?

  1. Consider Azure Cosmos DB for Apache Cassandra.
  2. Use request units as the standardized measure of database operation cost.
  3. Replicate a Cosmos DB account into appropriate Azure regions.
  4. Organize JSON records as items inside containers grouped within a database and account.

Explanation

Correct Answer

D:

The requirement concerns Cosmos item hierarchy. Resource hierarchy separates account settings, database groupings and stored items.

Incorrect Answers

A:

That action instead addresses Cassandra API: A managed Azure option can expose Cassandra-compatible interfaces for supported use cases. It does not directly satisfy the described Cosmos item hierarchy need.

B:

That action instead addresses Request units: Queries and writes consume RU-based throughput according to their work. It does not directly satisfy the described Cosmos item hierarchy need.

C:

That action instead addresses Global region reads: Applications can direct supported reads toward regional replicas. It does not directly satisfy the described Cosmos item hierarchy need.

Question 554

A data professional makes this decision: Organize JSON records as items inside containers grouped within a database and account. Which outcome is the most direct expected result?

  1. Resource hierarchy separates account settings, database groupings and stored items.
  2. Queries and writes consume RU-based throughput according to their work.
  3. A managed Azure option can expose Cassandra-compatible interfaces for supported use cases.
  4. Applications can direct supported reads toward regional replicas.

Explanation

Correct Answer

A:

This is the expected outcome for Cosmos item hierarchy: Resource hierarchy separates account settings, database groupings and stored items.

Incorrect Answers

B:

This result would follow the different Request units decision (Use request units as the standardized measure of database operation cost.) rather than the specified design.

C:

This result would follow the different Cassandra API decision (Consider Azure Cosmos DB for Apache Cassandra.) rather than the specified design.

D:

This result would follow the different Global region reads decision (Replicate a Cosmos DB account into appropriate Azure regions.) rather than the specified design.

Question 555

A developer confuses Cosmos DB accounts, databases, containers and individual items. Someone instead proposes: Consider Azure Cosmos DB for Apache Cassandra. Which alternative is the best correction for the original requirement?

  1. Consider Azure Cosmos DB for Apache Cassandra.
  2. Organize JSON records as items inside containers grouped within a database and account.
  3. Use request units as the standardized measure of database operation cost.
  4. Replicate a Cosmos DB account into appropriate Azure regions.

Explanation

Correct Answer

B:

This correction addresses Cosmos item hierarchy. Resource hierarchy separates account settings, database groupings and stored items.

Incorrect Answers

A:

This choice is for Cassandra API, not the specific requirement. A managed Azure option can expose Cassandra-compatible interfaces for supported use cases.

C:

This choice is for Request units, not the specific requirement. Queries and writes consume RU-based throughput according to their work.

D:

This choice is for Global region reads, not the specific requirement. Applications can direct supported reads toward regional replicas.

Question 556

A data architect recommends this approach: Organize JSON records as items inside containers grouped within a database and account. Which situation most clearly calls for that approach?

  1. An existing application uses Cassandra-style CQL clients and partitioned wide-column data access.
  2. A team cannot explain why Cosmos DB operations consume provisioned capacity when reading and writing documents.
  3. A developer confuses Cosmos DB accounts, databases, containers and individual items.
  4. Customers on multiple continents require geographically closer reads of the same application data.

Explanation

Correct Answer

C:

This situation calls for Cosmos item hierarchy. Resource hierarchy separates account settings, database groupings and stored items.

Incorrect Answers

A:

The other situation is better matched to Consider Azure Cosmos DB for Apache Cassandra. A managed Azure option can expose Cassandra-compatible interfaces for supported use cases.

B:

The other situation is better matched to Use request units as the standardized measure of database operation cost. Queries and writes consume RU-based throughput according to their work.

D:

The other situation is better matched to Replicate a Cosmos DB account into appropriate Azure regions. Applications can direct supported reads toward regional replicas.

Question 557

A globally distributed application needs supported active writes in more than one geographic region. Which data concept, Azure service, or design decision most directly satisfies the requirement?

  1. Use Azure Cosmos DB for Apache Gremlin for the property graph workload.
  2. Evaluate Cosmos DB multi-region write capabilities with the correct conflict handling design.
  3. Select an appropriate Azure Cosmos DB consistency level for the workload.
  4. Configure provisioned RU per second for the container or database as appropriate.

Explanation

Correct Answer

B:

The requirement concerns Cosmos multi-region writes. Clients can perform writes through multiple configured regions when supported.

Incorrect Answers

A:

That action instead addresses Graph traversal: Vertices and edges can represent and traverse connected entities. It does not directly satisfy the described Cosmos multi-region writes need.

C:

That action instead addresses Consistency choice: The chosen consistency guarantee governs how replicas expose writes to readers. It does not directly satisfy the described Cosmos multi-region writes need.

D:

That action instead addresses Provisioned throughput: A reserved throughput budget is available for supported operations. It does not directly satisfy the described Cosmos multi-region writes need.

Question 558

A data professional makes this decision: Evaluate Cosmos DB multi-region write capabilities with the correct conflict handling design. Which outcome is the most direct expected result?

  1. The chosen consistency guarantee governs how replicas expose writes to readers.
  2. Vertices and edges can represent and traverse connected entities.
  3. Clients can perform writes through multiple configured regions when supported.
  4. A reserved throughput budget is available for supported operations.

Explanation

Correct Answer

C:

This is the expected outcome for Cosmos multi-region writes: Clients can perform writes through multiple configured regions when supported.

Incorrect Answers

A:

This result would follow the different Consistency choice decision (Select an appropriate Azure Cosmos DB consistency level for the workload.) rather than the specified design.

B:

This result would follow the different Graph traversal decision (Use Azure Cosmos DB for Apache Gremlin for the property graph workload.) rather than the specified design.

D:

This result would follow the different Provisioned throughput decision (Configure provisioned RU per second for the container or database as appropriate.) rather than the specified design.

Question 559

A globally distributed application needs supported active writes in more than one geographic region. Someone instead proposes: Use Azure Cosmos DB for Apache Gremlin for the property graph workload. Which alternative is the best correction for the original requirement?

  1. Select an appropriate Azure Cosmos DB consistency level for the workload.
  2. Configure provisioned RU per second for the container or database as appropriate.
  3. Use Azure Cosmos DB for Apache Gremlin for the property graph workload.
  4. Evaluate Cosmos DB multi-region write capabilities with the correct conflict handling design.

Explanation

Correct Answer

D:

This correction addresses Cosmos multi-region writes. Clients can perform writes through multiple configured regions when supported.

Incorrect Answers

A:

This choice is for Consistency choice, not the specific requirement. The chosen consistency guarantee governs how replicas expose writes to readers.

B:

This choice is for Provisioned throughput, not the specific requirement. A reserved throughput budget is available for supported operations.

C:

This choice is for Graph traversal, not the specific requirement. Vertices and edges can represent and traverse connected entities.

Question 560

A data architect recommends this approach: Evaluate Cosmos DB multi-region write capabilities with the correct conflict handling design. Which situation most clearly calls for that approach?

  1. A globally distributed application needs supported active writes in more than one geographic region.
  2. A service has a predictable sustained request rate and wants to configure Cosmos DB throughput capacity.
  3. A social network application frequently follows many-hop relationships among members and groups using graph queries.
  4. A globally distributed application must trade off read consistency, latency and availability requirements explicitly.

Explanation

Correct Answer

A:

This situation calls for Cosmos multi-region writes. Clients can perform writes through multiple configured regions when supported.

Incorrect Answers

B:

The other situation is better matched to Configure provisioned RU per second for the container or database as appropriate. A reserved throughput budget is available for supported operations.

C:

The other situation is better matched to Use Azure Cosmos DB for Apache Gremlin for the property graph workload. Vertices and edges can represent and traverse connected entities.

D:

The other situation is better matched to Select an appropriate Azure Cosmos DB consistency level for the workload. The chosen consistency guarantee governs how replicas expose writes to readers.