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 55

Question 540

A data architect recommends this approach: Replicate a Cosmos DB account into appropriate Azure regions. Which situation most clearly calls for that approach?

  1. Customers on multiple continents require geographically closer reads of the same application data.
  2. A social network application frequently follows many-hop relationships among members and groups using graph queries.
  3. A developer confuses Cosmos DB accounts, databases, containers and individual items.
  4. A service has a predictable sustained request rate and wants to configure Cosmos DB throughput capacity.

Explanation

Correct Answer

A:

This situation calls for Global region reads. Applications can direct supported reads toward regional replicas.

Incorrect Answers

B:

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.

C:

The other situation is better matched to Organize JSON records as items inside containers grouped within a database and account. Resource hierarchy separates account settings, database groupings and stored items.

D:

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.

Question 541

A globally distributed application must trade off read consistency, latency and availability requirements explicitly. Which data concept, Azure service, or design decision most directly satisfies the requirement?

  1. Select an appropriate Azure Cosmos DB consistency level for the workload.
  2. Consider autoscale throughput for the selected Cosmos DB workload.
  3. Evaluate Azure Cosmos DB for Table.
  4. Evaluate Cosmos DB multi-region write capabilities with the correct conflict handling design.

Explanation

Correct Answer

A:

The requirement concerns Consistency choice. The chosen consistency guarantee governs how replicas expose writes to readers.

Incorrect Answers

B:

That action instead addresses Autoscale throughput: RU/s capacity can adjust within the configured autoscale range. It does not directly satisfy the described Consistency choice need.

C:

That action instead addresses Table API: The service supports an API model compatible with Table-oriented applications. It does not directly satisfy the described Consistency choice need.

D:

That action instead addresses Cosmos multi-region writes: Clients can perform writes through multiple configured regions when supported. It does not directly satisfy the described Consistency choice need.

Question 542

A data professional makes this decision: Select an appropriate Azure Cosmos DB consistency level for the workload. Which outcome is the most direct expected result?

  1. The service supports an API model compatible with Table-oriented applications.
  2. The chosen consistency guarantee governs how replicas expose writes to readers.
  3. RU/s capacity can adjust within the configured autoscale range.
  4. Clients can perform writes through multiple configured regions when supported.

Explanation

Correct Answer

B:

This is the expected outcome for Consistency choice: The chosen consistency guarantee governs how replicas expose writes to readers.

Incorrect Answers

A:

This result would follow the different Table API decision (Evaluate Azure Cosmos DB for Table.) rather than the specified design.

C:

This result would follow the different Autoscale throughput decision (Consider autoscale throughput for the selected Cosmos DB workload.) rather than the specified design.

D:

This result would follow the different Cosmos multi-region writes decision (Evaluate Cosmos DB multi-region write capabilities with the correct conflict handling design.) rather than the specified design.

Question 543

A globally distributed application must trade off read consistency, latency and availability requirements explicitly. Someone instead proposes: Evaluate Cosmos DB multi-region write capabilities with the correct conflict handling design. Which alternative is the best correction for the original requirement?

  1. Evaluate Azure Cosmos DB for Table.
  2. Consider autoscale throughput for the selected Cosmos DB workload.
  3. Select an appropriate Azure Cosmos DB consistency level for the workload.
  4. Evaluate Cosmos DB multi-region write capabilities with the correct conflict handling design.

Explanation

Correct Answer

C:

This correction addresses Consistency choice. The chosen consistency guarantee governs how replicas expose writes to readers.

Incorrect Answers

A:

This choice is for Table API, not the specific requirement. The service supports an API model compatible with Table-oriented applications.

B:

This choice is for Autoscale throughput, not the specific requirement. RU/s capacity can adjust within the configured autoscale range.

D:

This choice is for Cosmos multi-region writes, not the specific requirement. Clients can perform writes through multiple configured regions when supported.

Question 544

A data architect recommends this approach: Select an appropriate Azure Cosmos DB consistency level for the workload. Which situation most clearly calls for that approach?

  1. A globally distributed application needs supported active writes in more than one geographic region.
  2. An application already uses Azure Table Storage-compatible SDK operations but wants additional Cosmos DB capabilities.
  3. An application's Cosmos DB traffic rises and falls sharply during different hours each day.
  4. A globally distributed application must trade off read consistency, latency and availability requirements explicitly.

Explanation

Correct Answer

D:

This situation calls for Consistency choice. The chosen consistency guarantee governs how replicas expose writes to readers.

Incorrect Answers

A:

The other situation is better matched to Evaluate Cosmos DB multi-region write capabilities with the correct conflict handling design. Clients can perform writes through multiple configured regions when supported.

B:

The other situation is better matched to Evaluate Azure Cosmos DB for Table. The service supports an API model compatible with Table-oriented applications.

C:

The other situation is better matched to Consider autoscale throughput for the selected Cosmos DB workload. RU/s capacity can adjust within the configured autoscale range.

Question 545

Telemetry documents should automatically expire after a configured retention period without a daily cleanup job. Which data concept, Azure service, or design decision most directly satisfies the requirement?

  1. Choose an appropriate partition key aligned with common access patterns.
  2. Use Azure Cosmos DB for NoSQL.
  3. Configure Cosmos DB item or container time-to-live where supported.
  4. Use a Cosmos DB point read by item ID and partition key.

Explanation

Correct Answer

C:

The requirement concerns Time to live. Expired items are removed according to the TTL policy.

Incorrect Answers

A:

That action instead addresses Cosmos partition key: Logical partitions distribute records and influence scalability and query efficiency. It does not directly satisfy the described Time to live need.

B:

That action instead addresses NoSQL document database: The service stores queryable JSON-like items within managed scalable containers. It does not directly satisfy the described Time to live need.

D:

That action instead addresses Cosmos point read: The targeted lookup can avoid a broad cross-partition query. It does not directly satisfy the described Time to live need.

Question 546

A data professional makes this decision: Configure Cosmos DB item or container time-to-live where supported. Which outcome is the most direct expected result?

  1. The targeted lookup can avoid a broad cross-partition query.
  2. Logical partitions distribute records and influence scalability and query efficiency.
  3. The service stores queryable JSON-like items within managed scalable containers.
  4. Expired items are removed according to the TTL policy.

Explanation

Correct Answer

D:

This is the expected outcome for Time to live: Expired items are removed according to the TTL policy.

Incorrect Answers

A:

This result would follow the different Cosmos point read decision (Use a Cosmos DB point read by item ID and partition key.) rather than the specified design.

B:

This result would follow the different Cosmos partition key decision (Choose an appropriate partition key aligned with common access patterns.) rather than the specified design.

C:

This result would follow the different NoSQL document database decision (Use Azure Cosmos DB for NoSQL.) rather than the specified design.

Question 547

Telemetry documents should automatically expire after a configured retention period without a daily cleanup job. Someone instead proposes: Use Azure Cosmos DB for NoSQL. Which alternative is the best correction for the original requirement?

  1. Configure Cosmos DB item or container time-to-live where supported.
  2. Use Azure Cosmos DB for NoSQL.
  3. Choose an appropriate partition key aligned with common access patterns.
  4. Use a Cosmos DB point read by item ID and partition key.

Explanation

Correct Answer

A:

This correction addresses Time to live. Expired items are removed according to the TTL policy.

Incorrect Answers

B:

This choice is for NoSQL document database, not the specific requirement. The service stores queryable JSON-like items within managed scalable containers.

C:

This choice is for Cosmos partition key, not the specific requirement. Logical partitions distribute records and influence scalability and query efficiency.

D:

This choice is for Cosmos point read, not the specific requirement. The targeted lookup can avoid a broad cross-partition query.

Question 548

A data architect recommends this approach: Configure Cosmos DB item or container time-to-live where supported. Which situation most clearly calls for that approach?

  1. An app holds product objects with varying JSON fields and needs a managed globally distributed document service.
  2. Telemetry documents should automatically expire after a configured retention period without a daily cleanup job.
  3. A service knows a document's unique item ID and partition key and needs one exact lookup.
  4. A customer-facing document container will grow quickly and needs predictable horizontal data distribution.

Explanation

Correct Answer

B:

This situation calls for Time to live. Expired items are removed according to the TTL policy.

Incorrect Answers

A:

The other situation is better matched to Use Azure Cosmos DB for NoSQL. The service stores queryable JSON-like items within managed scalable containers.

C:

The other situation is better matched to Use a Cosmos DB point read by item ID and partition key. The targeted lookup can avoid a broad cross-partition query.

D:

The other situation is better matched to Choose an appropriate partition key aligned with common access patterns. Logical partitions distribute records and influence scalability and query efficiency.

Question 549

A microservice needs to react when documents are inserted or updated in a Cosmos DB container. Which data concept, Azure service, or design decision most directly satisfies the requirement?

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

Explanation

Correct Answer

D:

The requirement concerns Change feed. Applications can process a stream of document changes incrementally.

Incorrect Answers

A:

That action instead addresses Hot partition risk: Traffic can spread more evenly across the container's available resources. It does not directly satisfy the described Change feed need.

B:

That action instead addresses Cosmos SQL query: Document properties can be filtered and projected with the service's query syntax. It does not directly satisfy the described Change feed need.

C:

That action instead addresses MongoDB compatibility: The service provides an Azure-managed option compatible with the selected MongoDB driver model. It does not directly satisfy the described Change feed need.

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.