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 14

Question 130

A data professional makes this decision: Select suitable Azure Blob access tiers based on retrieval frequency and retention. Which outcome is the most direct expected result?

  1. Storage costs and retrieval characteristics can be matched to the expected access patterns.
  2. A managed PostgreSQL service provides the compatible engine without self-managed database VMs.
  3. Clients can access shared directories through a familiar network file protocol.
  4. Frequently accessed values can be served faster while the authoritative database remains durable.

Explanation

Correct Answer

A:

This is the expected outcome for Object tiers: Storage costs and retrieval characteristics can be matched to the expected access patterns.

Incorrect Answers

B:

This result would follow the different Open-source PostgreSQL decision (Select Azure Database for PostgreSQL.) rather than the specified design.

C:

This result would follow the different Cloud file sharing decision (Use Azure Files to provide a managed SMB file share.) rather than the specified design.

D:

This result would follow the different Low latency cache decision (Introduce a cache layer rather than repeatedly querying the persistent data store.) rather than the specified design.

Question 131

An archive has files accessed daily and other files rarely retrieved for years. Someone instead proposes: Use Azure Files to provide a managed SMB file share. Which alternative is the best correction for the original requirement?

  1. Introduce a cache layer rather than repeatedly querying the persistent data store.
  2. Select suitable Azure Blob access tiers based on retrieval frequency and retention.
  3. Select Azure Database for PostgreSQL.
  4. Use Azure Files to provide a managed SMB file share.

Explanation

Correct Answer

B:

This correction addresses Object tiers. Storage costs and retrieval characteristics can be matched to the expected access patterns.

Incorrect Answers

A:

This choice is for Low latency cache, not the specific requirement. Frequently accessed values can be served faster while the authoritative database remains durable.

C:

This choice is for Open-source PostgreSQL, not the specific requirement. A managed PostgreSQL service provides the compatible engine without self-managed database VMs.

D:

This choice is for Cloud file sharing, not the specific requirement. Clients can access shared directories through a familiar network file protocol.

Question 132

A data architect recommends this approach: Select suitable Azure Blob access tiers based on retrieval frequency and retention. Which situation most clearly calls for that approach?

  1. A service is written for PostgreSQL semantics and drivers and the team wants a managed cloud offering.
  2. Several Windows virtual machines must read and write the same departmental files over the SMB protocol.
  3. An archive has files accessed daily and other files rarely retrieved for years.
  4. A web application needs to repeatedly fetch the same short-lived reference lookups with minimal network round trips.

Explanation

Correct Answer

C:

This situation calls for Object tiers. Storage costs and retrieval characteristics can be matched to the expected access patterns.

Incorrect Answers

A:

The other situation is better matched to Select Azure Database for PostgreSQL. A managed PostgreSQL service provides the compatible engine without self-managed database VMs.

B:

The other situation is better matched to Use Azure Files to provide a managed SMB file share. Clients can access shared directories through a familiar network file protocol.

D:

The other situation is better matched to Introduce a cache layer rather than repeatedly querying the persistent data store. Frequently accessed values can be served faster while the authoritative database remains durable.

Question 133

A batch pipeline receives hourly device exports and must keep originals for reproducible transformations. Which data concept, Azure service, or design decision most directly satisfies the requirement?

  1. Land the original files in durable object storage before downstream processing.
  2. Evaluate a document-oriented NoSQL data store.
  3. Select Azure Database for MySQL.
  4. Consider Azure Table Storage for the key-attribute entities.

Explanation

Correct Answer

A:

The requirement concerns Event payload landing. Raw inputs remain available when transformations must be rerun or audited.

Incorrect Answers

B:

That action instead addresses Data store choice: Document access fits flexible per-customer attributes without a rigid normalized schema. It does not directly satisfy the described Event payload landing need.

C:

That action instead addresses Open-source MySQL: The application can retain its MySQL-oriented database interactions on a managed platform. It does not directly satisfy the described Event payload landing need.

D:

That action instead addresses Wide key-attribute records: The table service supports scalable non-relational key-based access patterns. It does not directly satisfy the described Event payload landing need.

Question 134

A data professional makes this decision: Land the original files in durable object storage before downstream processing. Which outcome is the most direct expected result?

  1. The table service supports scalable non-relational key-based access patterns.
  2. Raw inputs remain available when transformations must be rerun or audited.
  3. The application can retain its MySQL-oriented database interactions on a managed platform.
  4. Document access fits flexible per-customer attributes without a rigid normalized schema.

Explanation

Correct Answer

B:

This is the expected outcome for Event payload landing: Raw inputs remain available when transformations must be rerun or audited.

Incorrect Answers

A:

This result would follow the different Wide key-attribute records decision (Consider Azure Table Storage for the key-attribute entities.) rather than the specified design.

C:

This result would follow the different Open-source MySQL decision (Select Azure Database for MySQL.) rather than the specified design.

D:

This result would follow the different Data store choice decision (Evaluate a document-oriented NoSQL data store.) rather than the specified design.

Question 135

A batch pipeline receives hourly device exports and must keep originals for reproducible transformations. Someone instead proposes: Consider Azure Table Storage for the key-attribute entities. Which alternative is the best correction for the original requirement?

  1. Consider Azure Table Storage for the key-attribute entities.
  2. Evaluate a document-oriented NoSQL data store.
  3. Land the original files in durable object storage before downstream processing.
  4. Select Azure Database for MySQL.

Explanation

Correct Answer

C:

This correction addresses Event payload landing. Raw inputs remain available when transformations must be rerun or audited.

Incorrect Answers

A:

This choice is for Wide key-attribute records, not the specific requirement. The table service supports scalable non-relational key-based access patterns.

B:

This choice is for Data store choice, not the specific requirement. Document access fits flexible per-customer attributes without a rigid normalized schema.

D:

This choice is for Open-source MySQL, not the specific requirement. The application can retain its MySQL-oriented database interactions on a managed platform.

Question 136

A data architect recommends this approach: Land the original files in durable object storage before downstream processing. Which situation most clearly calls for that approach?

  1. An application keeps a large collection of simple entities with partition and row keys rather than relational joins.
  2. A team wants to retrieve single customer documents with variable fields and does not need multi-table relational joins.
  3. A website depends on MySQL client compatibility while moving database operations to a managed Azure service.
  4. A batch pipeline receives hourly device exports and must keep originals for reproducible transformations.

Explanation

Correct Answer

D:

This situation calls for Event payload landing. Raw inputs remain available when transformations must be rerun or audited.

Incorrect Answers

A:

The other situation is better matched to Consider Azure Table Storage for the key-attribute entities. The table service supports scalable non-relational key-based access patterns.

B:

The other situation is better matched to Evaluate a document-oriented NoSQL data store. Document access fits flexible per-customer attributes without a rigid normalized schema.

C:

The other situation is better matched to Select Azure Database for MySQL. The application can retain its MySQL-oriented database interactions on a managed platform.

Question 137

An online storefront commits a few order and payment rows per customer request with immediate consistency expectations. Which data concept, Azure service, or design decision most directly satisfies the requirement?

  1. Choose a streaming or near-real-time analytical processing pattern.
  2. Classify the checkout application as an online transactional processing workload.
  3. Classify the workflow as extract-transform-load data integration.
  4. Enforce referential integrity through relational key constraints.

Explanation

Correct Answer

B:

The requirement concerns OLTP checkout. Many short atomic reads and writes characterize OLTP activity.

Incorrect Answers

A:

That action instead addresses Stream anomaly: Events are evaluated continuously rather than waiting for an overnight job. It does not directly satisfy the described OLTP checkout need.

C:

That action instead addresses ETL processing: Source data is transformed before arriving in the analytical target. It does not directly satisfy the described OLTP checkout need.

D:

That action instead addresses Consistency constraint: Invalid relationships are rejected rather than leaving orphaned references. It does not directly satisfy the described OLTP checkout need.

Question 138

A data professional makes this decision: Classify the checkout application as an online transactional processing workload. Which outcome is the most direct expected result?

  1. Source data is transformed before arriving in the analytical target.
  2. Events are evaluated continuously rather than waiting for an overnight job.
  3. Many short atomic reads and writes characterize OLTP activity.
  4. Invalid relationships are rejected rather than leaving orphaned references.

Explanation

Correct Answer

C:

This is the expected outcome for OLTP checkout: Many short atomic reads and writes characterize OLTP activity.

Incorrect Answers

A:

This result would follow the different ETL processing decision (Classify the workflow as extract-transform-load data integration.) rather than the specified design.

B:

This result would follow the different Stream anomaly decision (Choose a streaming or near-real-time analytical processing pattern.) rather than the specified design.

D:

This result would follow the different Consistency constraint decision (Enforce referential integrity through relational key constraints.) rather than the specified design.

Question 139

An online storefront commits a few order and payment rows per customer request with immediate consistency expectations. Someone instead proposes: Enforce referential integrity through relational key constraints. Which alternative is the best correction for the original requirement?

  1. Classify the workflow as extract-transform-load data integration.
  2. Choose a streaming or near-real-time analytical processing pattern.
  3. Enforce referential integrity through relational key constraints.
  4. Classify the checkout application as an online transactional processing workload.

Explanation

Correct Answer

D:

This correction addresses OLTP checkout. Many short atomic reads and writes characterize OLTP activity.

Incorrect Answers

A:

This choice is for ETL processing, not the specific requirement. Source data is transformed before arriving in the analytical target.

B:

This choice is for Stream anomaly, not the specific requirement. Events are evaluated continuously rather than waiting for an overnight job.

C:

This choice is for Consistency constraint, not the specific requirement. Invalid relationships are rejected rather than leaving orphaned references.

Question 140

A data architect recommends this approach: Classify the checkout application as an online transactional processing workload. Which situation most clearly calls for that approach?

  1. An online storefront commits a few order and payment rows per customer request with immediate consistency expectations.
  2. A monitoring application must detect an over-temperature event within seconds of receiving sensor data.
  3. A nightly job extracts source records, cleans mismatched categories and loads curated rows for reporting.
  4. An order system must prevent a line item from referring to a product that does not exist.

Explanation

Correct Answer

A:

This situation calls for OLTP checkout. Many short atomic reads and writes characterize OLTP activity.

Incorrect Answers

B:

The other situation is better matched to Choose a streaming or near-real-time analytical processing pattern. Events are evaluated continuously rather than waiting for an overnight job.

C:

The other situation is better matched to Classify the workflow as extract-transform-load data integration. Source data is transformed before arriving in the analytical target.

D:

The other situation is better matched to Enforce referential integrity through relational key constraints. Invalid relationships are rejected rather than leaving orphaned references.