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 51

Question 500

A data architect recommends this approach: Consider Azure Cosmos DB for Apache Cassandra. Which situation most clearly calls for that approach?

  1. One partition key value receives almost all requests while other values receive very few.
  2. An existing application uses Cassandra-style CQL clients and partitioned wide-column data access.
  3. An app needs to filter JSON documents by an indexed property and project selected fields.
  4. A developer confuses Cosmos DB accounts, databases, containers and individual items.

Explanation

Correct Answer

B:

This situation calls for Cassandra API. A managed Azure option can expose Cassandra-compatible interfaces for supported use cases.

Incorrect Answers

A:

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.

C:

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.

D:

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.

Question 501

A social network application frequently follows many-hop relationships among members and groups using graph queries. Which data concept, Azure service, or design decision most directly satisfies the requirement?

  1. Use request units as the standardized measure of database operation cost.
  2. Use Azure Cosmos DB for Apache Gremlin for the property graph workload.
  3. Replicate a Cosmos DB account into appropriate Azure regions.
  4. Evaluate Cosmos DB multi-region write capabilities with the correct conflict handling design.

Explanation

Correct Answer

B:

The requirement concerns Graph traversal. Vertices and edges can represent and traverse connected entities.

Incorrect Answers

A:

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

C:

That action instead addresses Global region reads: Applications can direct supported reads toward regional replicas. It does not directly satisfy the described Graph traversal 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 Graph traversal need.

Question 502

A data professional makes this decision: Use Azure Cosmos DB for Apache Gremlin for the property graph workload. Which outcome is the most direct expected result?

  1. Queries and writes consume RU-based throughput according to their work.
  2. Clients can perform writes through multiple configured regions when supported.
  3. Vertices and edges can represent and traverse connected entities.
  4. Applications can direct supported reads toward regional replicas.

Explanation

Correct Answer

C:

This is the expected outcome for Graph traversal: Vertices and edges can represent and traverse connected entities.

Incorrect Answers

A:

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.

B:

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.

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 503

A social network application frequently follows many-hop relationships among members and groups using graph queries. Someone instead proposes: Use request units as the standardized measure of database operation cost. Which alternative is the best correction for the original requirement?

  1. Use request units as the standardized measure of database operation cost.
  2. Evaluate Cosmos DB multi-region write capabilities with the correct conflict handling design.
  3. Replicate a Cosmos DB account into appropriate Azure regions.
  4. Use Azure Cosmos DB for Apache Gremlin for the property graph workload.

Explanation

Correct Answer

D:

This correction addresses Graph traversal. Vertices and edges can represent and traverse connected entities.

Incorrect Answers

A:

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

B:

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

C:

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

Question 504

A data architect recommends this approach: Use Azure Cosmos DB for Apache Gremlin for the property graph workload. Which situation most clearly calls for that approach?

  1. A social network application frequently follows many-hop relationships among members and groups using graph queries.
  2. Customers on multiple continents require geographically closer reads of the same application data.
  3. A globally distributed application needs supported active writes in more than one geographic region.
  4. A team cannot explain why Cosmos DB operations consume provisioned capacity when reading and writing documents.

Explanation

Correct Answer

A:

This situation calls for Graph traversal. Vertices and edges can represent and traverse connected entities.

Incorrect Answers

B:

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

C:

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.

D:

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.

Question 505

An application already uses Azure Table Storage-compatible SDK operations but wants additional Cosmos DB capabilities. Which data concept, Azure service, or design decision most directly satisfies the requirement?

  1. Configure provisioned RU per second for the container or database as appropriate.
  2. Evaluate Azure Cosmos DB for Table.
  3. Select an appropriate Azure Cosmos DB consistency level for the workload.
  4. Use Azure Cosmos DB for NoSQL.

Explanation

Correct Answer

B:

The requirement concerns Table API. The service supports an API model compatible with Table-oriented applications.

Incorrect Answers

A:

That action instead addresses Provisioned throughput: A reserved throughput budget is available for supported operations. It does not directly satisfy the described Table API 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 Table API need.

D:

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 Table API need.

Question 506

A data professional makes this decision: Evaluate Azure Cosmos DB for Table. Which outcome is the most direct expected result?

  1. The service stores queryable JSON-like items within managed scalable containers.
  2. A reserved throughput budget is available for supported operations.
  3. The service supports an API model compatible with Table-oriented applications.
  4. The chosen consistency guarantee governs how replicas expose writes to readers.

Explanation

Correct Answer

C:

This is the expected outcome for Table API: The service supports an API model compatible with Table-oriented applications.

Incorrect Answers

A:

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

B:

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.

D:

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.

Question 507

An application already uses Azure Table Storage-compatible SDK operations but wants additional Cosmos DB capabilities. Someone instead proposes: Configure provisioned RU per second for the container or database as appropriate. Which alternative is the best correction for the original requirement?

  1. Use Azure Cosmos DB for NoSQL.
  2. Select an appropriate Azure Cosmos DB consistency level for the workload.
  3. Configure provisioned RU per second for the container or database as appropriate.
  4. Evaluate Azure Cosmos DB for Table.

Explanation

Correct Answer

D:

This correction addresses Table API. The service supports an API model compatible with Table-oriented applications.

Incorrect Answers

A:

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

B:

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

C:

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

Question 508

A data architect recommends this approach: Evaluate Azure Cosmos DB for Table. Which situation most clearly calls for that approach?

  1. An application already uses Azure Table Storage-compatible SDK operations but wants additional Cosmos DB capabilities.
  2. An app holds product objects with varying JSON fields and needs a managed globally distributed document service.
  3. A service has a predictable sustained request rate and wants to configure Cosmos DB throughput capacity.
  4. A globally distributed application must trade off read consistency, latency and availability requirements explicitly.

Explanation

Correct Answer

A:

This situation calls for Table API. The service supports an API model compatible with Table-oriented applications.

Incorrect Answers

B:

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 Configure provisioned RU per second for the container or database as appropriate. A reserved throughput budget is available for supported operations.

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.

Question 509

A customer-facing document container will grow quickly and needs predictable horizontal data distribution. Which data concept, Azure service, or design decision most directly satisfies the requirement?

  1. Configure Cosmos DB item or container time-to-live where supported.
  2. Choose Azure Cosmos DB for MongoDB vCore or the supported MongoDB API offering according to workload requirements.
  3. Consider autoscale throughput for the selected Cosmos DB workload.
  4. Choose an appropriate partition key aligned with common access patterns.

Explanation

Correct Answer

D:

The requirement concerns Cosmos partition key. Logical partitions distribute records and influence scalability and query efficiency.

Incorrect Answers

A:

That action instead addresses Time to live: Expired items are removed according to the TTL policy. It does not directly satisfy the described Cosmos partition key need.

B:

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 Cosmos partition key need.

C:

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

Question 510

A data professional makes this decision: Choose an appropriate partition key aligned with common access patterns. Which outcome is the most direct expected result?

  1. Logical partitions distribute records and influence scalability and query efficiency.
  2. The service provides an Azure-managed option compatible with the selected MongoDB driver model.
  3. Expired items are removed according to the TTL policy.
  4. RU/s capacity can adjust within the configured autoscale range.

Explanation

Correct Answer

A:

This is the expected outcome for Cosmos partition key: Logical partitions distribute records and influence scalability and query efficiency.

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 Time to live decision (Configure Cosmos DB item or container time-to-live where supported.) rather than the specified design.

D:

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