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 57

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.

Question 561

A company wants to pull records from several operational systems into a common analytics platform every night. Which data concept, Azure service, or design decision most directly satisfies the requirement?

  1. Express the quality check as a pipeline dependency before publication.
  2. Store prepared analytical records in a column-oriented format such as Parquet.
  3. Build a managed data ingestion pipeline from the source systems.
  4. Use Microsoft OneLake as the Fabric data lake foundation.

Explanation

Correct Answer

C:

The requirement concerns Data ingestion. Source records are transferred into a controlled analytical landing zone.

Incorrect Answers

A:

That action instead addresses Orchestrated dependency: Unvalidated data is less likely to become the current reporting dataset. It does not directly satisfy the described Data ingestion need.

B:

That action instead addresses Parquet compression: Columnar scans can avoid loading unrelated columns and support compression. It does not directly satisfy the described Data ingestion need.

D:

That action instead addresses Fabric OneLake: Analytical workloads can work from a unified lake storage layer. It does not directly satisfy the described Data ingestion need.

Question 562

A data professional makes this decision: Build a managed data ingestion pipeline from the source systems. Which outcome is the most direct expected result?

  1. Unvalidated data is less likely to become the current reporting dataset.
  2. Analytical workloads can work from a unified lake storage layer.
  3. Columnar scans can avoid loading unrelated columns and support compression.
  4. Source records are transferred into a controlled analytical landing zone.

Explanation

Correct Answer

D:

This is the expected outcome for Data ingestion: Source records are transferred into a controlled analytical landing zone.

Incorrect Answers

A:

This result would follow the different Orchestrated dependency decision (Express the quality check as a pipeline dependency before publication.) rather than the specified design.

B:

This result would follow the different Fabric OneLake decision (Use Microsoft OneLake as the Fabric data lake foundation.) rather than the specified design.

C:

This result would follow the different Parquet compression decision (Store prepared analytical records in a column-oriented format such as Parquet.) rather than the specified design.

Question 563

A company wants to pull records from several operational systems into a common analytics platform every night. Someone instead proposes: Use Microsoft OneLake as the Fabric data lake foundation. Which alternative is the best correction for the original requirement?

  1. Build a managed data ingestion pipeline from the source systems.
  2. Store prepared analytical records in a column-oriented format such as Parquet.
  3. Use Microsoft OneLake as the Fabric data lake foundation.
  4. Express the quality check as a pipeline dependency before publication.

Explanation

Correct Answer

A:

This correction addresses Data ingestion. Source records are transferred into a controlled analytical landing zone.

Incorrect Answers

B:

This choice is for Parquet compression, not the specific requirement. Columnar scans can avoid loading unrelated columns and support compression.

C:

This choice is for Fabric OneLake, not the specific requirement. Analytical workloads can work from a unified lake storage layer.

D:

This choice is for Orchestrated dependency, not the specific requirement. Unvalidated data is less likely to become the current reporting dataset.

Question 564

A data architect recommends this approach: Build a managed data ingestion pipeline from the source systems. Which situation most clearly calls for that approach?

  1. A data-quality test must finish successfully before the reporting warehouse publication step runs.
  2. A company wants to pull records from several operational systems into a common analytics platform every night.
  3. Most monthly reports read just a few fields from wide historical event datasets.
  4. Separate teams using Microsoft Fabric need a logical organization-wide data lake that multiple analytics workloads can access.

Explanation

Correct Answer

B:

This situation calls for Data ingestion. Source records are transferred into a controlled analytical landing zone.

Incorrect Answers

A:

The other situation is better matched to Express the quality check as a pipeline dependency before publication. Unvalidated data is less likely to become the current reporting dataset.

C:

The other situation is better matched to Store prepared analytical records in a column-oriented format such as Parquet. Columnar scans can avoid loading unrelated columns and support compression.

D:

The other situation is better matched to Use Microsoft OneLake as the Fabric data lake foundation. Analytical workloads can work from a unified lake storage layer.

Question 565

A scheduled analytics workflow must run copy, transformation and validation activities in a known sequence with retry logic. Which data concept, Azure service, or design decision most directly satisfies the requirement?

  1. Use an Azure Data Factory pipeline to orchestrate the workflow.
  2. Maintain data lineage metadata across pipelines and analytical assets.
  3. Use an extract-load-transform pipeline in the analytical target.
  4. Create a Fabric Lakehouse.

Explanation

Correct Answer

A:

The requirement concerns ADF orchestration. Dependent ingestion and preparation tasks execute under a managed orchestration plan.

Incorrect Answers

B:

That action instead addresses Data lineage: The route from source datasets to the published metric can be traced. It does not directly satisfy the described ADF orchestration need.

C:

That action instead addresses ELT in warehouse: Data transformations execute after data has entered the scalable destination. It does not directly satisfy the described ADF orchestration need.

D:

That action instead addresses Fabric lakehouse: A lakehouse brings file-based storage and table-oriented analytics together. It does not directly satisfy the described ADF orchestration need.

Question 566

A data professional makes this decision: Use an Azure Data Factory pipeline to orchestrate the workflow. Which outcome is the most direct expected result?

  1. The route from source datasets to the published metric can be traced.
  2. Dependent ingestion and preparation tasks execute under a managed orchestration plan.
  3. A lakehouse brings file-based storage and table-oriented analytics together.
  4. Data transformations execute after data has entered the scalable destination.

Explanation

Correct Answer

B:

This is the expected outcome for ADF orchestration: Dependent ingestion and preparation tasks execute under a managed orchestration plan.

Incorrect Answers

A:

This result would follow the different Data lineage decision (Maintain data lineage metadata across pipelines and analytical assets.) rather than the specified design.

C:

This result would follow the different Fabric lakehouse decision (Create a Fabric Lakehouse.) rather than the specified design.

D:

This result would follow the different ELT in warehouse decision (Use an extract-load-transform pipeline in the analytical target.) rather than the specified design.

Question 567

A scheduled analytics workflow must run copy, transformation and validation activities in a known sequence with retry logic. Someone instead proposes: Create a Fabric Lakehouse. Which alternative is the best correction for the original requirement?

  1. Use an extract-load-transform pipeline in the analytical target.
  2. Maintain data lineage metadata across pipelines and analytical assets.
  3. Use an Azure Data Factory pipeline to orchestrate the workflow.
  4. Create a Fabric Lakehouse.

Explanation

Correct Answer

C:

This correction addresses ADF orchestration. Dependent ingestion and preparation tasks execute under a managed orchestration plan.

Incorrect Answers

A:

This choice is for ELT in warehouse, not the specific requirement. Data transformations execute after data has entered the scalable destination.

B:

This choice is for Data lineage, not the specific requirement. The route from source datasets to the published metric can be traced.

D:

This choice is for Fabric lakehouse, not the specific requirement. A lakehouse brings file-based storage and table-oriented analytics together.

Question 568

A data architect recommends this approach: Use an Azure Data Factory pipeline to orchestrate the workflow. Which situation most clearly calls for that approach?

  1. A platform has abundant warehouse compute and wants to load source records before performing standardization.
  2. A data team wants files and Delta tables accessible to Spark jobs with SQL-accessible tables where supported.
  3. Auditors ask which upstream sources and transformations produced a sensitive executive metric.
  4. A scheduled analytics workflow must run copy, transformation and validation activities in a known sequence with retry logic.

Explanation

Correct Answer

D:

This situation calls for ADF orchestration. Dependent ingestion and preparation tasks execute under a managed orchestration plan.

Incorrect Answers

A:

The other situation is better matched to Use an extract-load-transform pipeline in the analytical target. Data transformations execute after data has entered the scalable destination.

B:

The other situation is better matched to Create a Fabric Lakehouse. A lakehouse brings file-based storage and table-oriented analytics together.

C:

The other situation is better matched to Maintain data lineage metadata across pipelines and analytical assets. The route from source datasets to the published metric can be traced.

Question 569

A team building analytics natively in Microsoft Fabric needs managed data movement and transformation orchestration. Which data concept, Azure service, or design decision most directly satisfies the requirement?

  1. Use an ETL stage that transforms or masks the data before loading.
  2. Run the transformation as a scheduled batch analytics job.
  3. Use a Fabric Data Warehouse.
  4. Use Data Factory capabilities within Microsoft Fabric.

Explanation

Correct Answer

D:

The requirement concerns Fabric Data Factory. Integrated Fabric pipelines and dataflows can prepare data for downstream workloads.

Incorrect Answers

A:

That action instead addresses ETL before landing: The reporting target receives already-prepared information. It does not directly satisfy the described Fabric Data Factory need.

B:

That action instead addresses Batch job execution: A bounded set of accumulated events is processed at the planned interval. It does not directly satisfy the described Fabric Data Factory need.

C:

That action instead addresses Fabric warehouse: Analysts can query curated dimensional and fact tables with SQL semantics. It does not directly satisfy the described Fabric Data Factory need.

Question 570

A data professional makes this decision: Use Data Factory capabilities within Microsoft Fabric. Which outcome is the most direct expected result?

  1. Integrated Fabric pipelines and dataflows can prepare data for downstream workloads.
  2. Analysts can query curated dimensional and fact tables with SQL semantics.
  3. A bounded set of accumulated events is processed at the planned interval.
  4. The reporting target receives already-prepared information.

Explanation

Correct Answer

A:

This is the expected outcome for Fabric Data Factory: Integrated Fabric pipelines and dataflows can prepare data for downstream workloads.

Incorrect Answers

B:

This result would follow the different Fabric warehouse decision (Use a Fabric Data Warehouse.) rather than the specified design.

C:

This result would follow the different Batch job execution decision (Run the transformation as a scheduled batch analytics job.) rather than the specified design.

D:

This result would follow the different ETL before landing decision (Use an ETL stage that transforms or masks the data before loading.) rather than the specified design.