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 62

Question 610

A data professional makes this decision: Store prepared analytical records in a column-oriented format such as Parquet. Which outcome is the most direct expected result?

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

Explanation

Correct Answer

B:

This is the expected outcome for Parquet compression: Columnar scans can avoid loading unrelated columns and support compression.

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.

C:

This result would follow the different Data ingestion decision (Build a managed data ingestion pipeline from the source systems.) rather than the specified design.

D:

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

Question 611

Most monthly reports read just a few fields from wide historical event datasets. Someone instead proposes: Express the quality check as a pipeline dependency before publication. Which alternative is the best correction for the original requirement?

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

Explanation

Correct Answer

C:

This correction addresses Parquet compression. Columnar scans can avoid loading unrelated columns and support compression.

Incorrect Answers

A:

This choice is for Data ingestion, not the specific requirement. Source records are transferred into a controlled analytical landing zone.

B:

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

D:

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

Question 612

A data architect recommends this approach: Store prepared analytical records in a column-oriented format such as Parquet. Which situation most clearly calls for that approach?

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

Explanation

Correct Answer

D:

This situation calls for Parquet compression. Columnar scans can avoid loading unrelated columns and support compression.

Incorrect Answers

A:

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.

B:

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 Build a managed data ingestion pipeline from the source systems. Source records are transferred into a controlled analytical landing zone.

Question 613

A platform has abundant warehouse compute and wants to load source records before performing standardization. Which data concept, Azure service, or design decision most directly satisfies the requirement?

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

Explanation

Correct Answer

D:

The requirement concerns ELT in warehouse. Data transformations execute after data has entered the scalable destination.

Incorrect Answers

A:

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

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 ELT in warehouse need.

C:

That action instead addresses ADF orchestration: Dependent ingestion and preparation tasks execute under a managed orchestration plan. It does not directly satisfy the described ELT in warehouse need.

Question 614

A data professional makes this decision: Use an extract-load-transform pipeline in the analytical target. Which outcome is the most direct expected result?

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

Explanation

Correct Answer

A:

This is the expected outcome for ELT in warehouse: Data transformations execute after data has entered the scalable destination.

Incorrect Answers

B:

This result would follow the different ADF orchestration decision (Use an Azure Data Factory pipeline to orchestrate the workflow.) rather than the specified design.

C:

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

D:

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

Question 615

A platform has abundant warehouse compute and wants to load source records before performing standardization. Someone instead proposes: Maintain data lineage metadata across pipelines and analytical assets. Which alternative is the best correction for the original requirement?

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

Explanation

Correct Answer

B:

This correction addresses ELT in warehouse. Data transformations execute after data has entered the scalable destination.

Incorrect Answers

A:

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

C:

This choice is for ADF orchestration, not the specific requirement. Dependent ingestion and preparation tasks execute under a managed orchestration plan.

D:

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

Question 616

A data architect recommends this approach: Use an extract-load-transform pipeline in the analytical target. Which situation most clearly calls for that approach?

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

Explanation

Correct Answer

C:

This situation calls for ELT in warehouse. Data transformations execute after data has entered the scalable destination.

Incorrect Answers

A:

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.

B:

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

D:

The other situation is better matched to Use an Azure Data Factory pipeline to orchestrate the workflow. Dependent ingestion and preparation tasks execute under a managed orchestration plan.

Question 617

A source system exports sensitive information that must be masked before records enter the reporting database. Which data concept, Azure service, or design decision most directly satisfies the requirement?

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

Explanation

Correct Answer

B:

The requirement concerns ETL before landing. The reporting target receives already-prepared information.

Incorrect Answers

A:

That action instead addresses Fabric Data Factory: Integrated Fabric pipelines and dataflows can prepare data for downstream workloads. It does not directly satisfy the described ETL before landing 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 ETL before landing need.

D:

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 ETL before landing need.

Question 618

A data professional makes this decision: Use an ETL stage that transforms or masks the data before loading. Which outcome is the most direct expected result?

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

Explanation

Correct Answer

C:

This is the expected outcome for ETL before landing: The reporting target receives already-prepared information.

Incorrect Answers

A:

This result would follow the different Fabric Data Factory decision (Use Data Factory capabilities within Microsoft Fabric.) rather than the specified design.

B:

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 Fabric warehouse decision (Use a Fabric Data Warehouse.) rather than the specified design.

Question 619

A source system exports sensitive information that must be masked before records enter the reporting database. Someone instead proposes: Run the transformation as a scheduled batch analytics job. Which alternative is the best correction for the original requirement?

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

Explanation

Correct Answer

D:

This correction addresses ETL before landing. The reporting target receives already-prepared information.

Incorrect Answers

A:

This choice is for Batch job execution, not the specific requirement. A bounded set of accumulated events is processed at the planned interval.

B:

This choice is for Fabric Data Factory, not the specific requirement. Integrated Fabric pipelines and dataflows can prepare data for downstream workloads.

C:

This choice is for Fabric warehouse, not the specific requirement. Analysts can query curated dimensional and fact tables with SQL semantics.

Question 620

A data architect recommends this approach: Use an ETL stage that transforms or masks the data before loading. Which situation most clearly calls for that approach?

  1. A source system exports sensitive information that must be masked before records enter the reporting database.
  2. A team building analytics natively in Microsoft Fabric needs managed data movement and transformation orchestration.
  3. A reporting department needs a managed relational analytical warehouse with familiar SQL-oriented access in Microsoft Fabric.
  4. A data science team can wait until 2 AM to refresh a large feature dataset from a day's events.

Explanation

Correct Answer

A:

This situation calls for ETL before landing. The reporting target receives already-prepared information.

Incorrect Answers

B:

The other situation is better matched to Use Data Factory capabilities within Microsoft Fabric. Integrated Fabric pipelines and dataflows can prepare data for downstream workloads.

C:

The other situation is better matched to Use a Fabric Data Warehouse. Analysts can query curated dimensional and fact tables with SQL semantics.

D:

The other situation is better matched to Run the transformation as a scheduled batch analytics job. A bounded set of accumulated events is processed at the planned interval.