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 60

Question 590

A data professional makes this decision: Create a Fabric Lakehouse. Which outcome is the most direct expected result?

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

Explanation

Correct Answer

D:

This is the expected outcome for Fabric lakehouse: A lakehouse brings file-based storage and table-oriented analytics together.

Incorrect Answers

A:

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

B:

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 ELT in warehouse decision (Use an extract-load-transform pipeline in the analytical target.) rather than the specified design.

Question 591

A data team wants files and Delta tables accessible to Spark jobs with SQL-accessible tables where supported. Someone instead proposes: Use an extract-load-transform pipeline in the analytical target. Which alternative is the best correction for the original 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

A:

This correction addresses Fabric lakehouse. A lakehouse brings file-based storage and table-oriented analytics together.

Incorrect Answers

B:

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

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 ELT in warehouse, not the specific requirement. Data transformations execute after data has entered the scalable destination.

Question 592

A data architect recommends this approach: Create a Fabric Lakehouse. 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

B:

This situation calls for Fabric lakehouse. A lakehouse brings file-based storage and table-oriented analytics together.

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.

C:

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.

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 593

A reporting department needs a managed relational analytical warehouse with familiar SQL-oriented access in Microsoft Fabric. 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. Use a Fabric Data Warehouse.
  3. Use Data Factory capabilities within Microsoft Fabric.
  4. Run the transformation as a scheduled batch analytics job.

Explanation

Correct Answer

B:

The requirement concerns Fabric warehouse. Analysts can query curated dimensional and fact tables with SQL semantics.

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

C:

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 Fabric warehouse 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 Fabric warehouse need.

Question 594

A data professional makes this decision: Use a Fabric Data Warehouse. Which outcome is the most direct expected result?

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

Explanation

Correct Answer

C:

This is the expected outcome for Fabric warehouse: Analysts can query curated dimensional and fact tables with SQL semantics.

Incorrect Answers

A:

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.

B:

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

D:

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

Question 595

A reporting department needs a managed relational analytical warehouse with familiar SQL-oriented access in Microsoft Fabric. Someone instead proposes: Use an ETL stage that transforms or masks the data before loading. Which alternative is the best correction for the original requirement?

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

Explanation

Correct Answer

D:

This correction addresses Fabric warehouse. Analysts can query curated dimensional and fact tables with SQL semantics.

Incorrect Answers

A:

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

B:

This choice is for ETL before landing, not the specific requirement. The reporting target receives already-prepared information.

C:

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

Question 596

A data architect recommends this approach: Use a Fabric Data Warehouse. Which situation most clearly calls for that approach?

  1. A reporting department needs a managed relational analytical warehouse with familiar SQL-oriented access in Microsoft Fabric.
  2. A team building analytics natively in Microsoft Fabric needs managed data movement and transformation orchestration.
  3. A source system exports sensitive information that must be masked before records enter the reporting database.
  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 Fabric warehouse. Analysts can query curated dimensional and fact tables with SQL semantics.

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 an ETL stage that transforms or masks the data before loading. The reporting target receives already-prepared information.

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.

Question 597

A pipeline must transform terabytes of raw JSON in distributed compute jobs. Which data concept, Azure service, or design decision most directly satisfies the requirement?

  1. Load new or changed records incrementally using a reliable change marker.
  2. Store the raw extracts in a bronze or raw lake zone.
  3. Partition analytical data using an appropriate time-based partition strategy.
  4. Use Azure Databricks with Apache Spark for the transformation workload.

Explanation

Correct Answer

D:

The requirement concerns Databricks Spark. Parallel distributed processing handles larger-than-single-server transformations.

Incorrect Answers

A:

That action instead addresses Incremental loading: Repeated ingestion can process a smaller changed subset rather than the full history. It does not directly satisfy the described Databricks Spark need.

B:

That action instead addresses Landing raw data: Original records remain available for replay and audit of downstream transformations. It does not directly satisfy the described Databricks Spark need.

C:

That action instead addresses Analytical partitioning: Queries can scan fewer partitions when predicates match the partition layout. It does not directly satisfy the described Databricks Spark need.

Question 598

A data professional makes this decision: Use Azure Databricks with Apache Spark for the transformation workload. Which outcome is the most direct expected result?

  1. Parallel distributed processing handles larger-than-single-server transformations.
  2. Queries can scan fewer partitions when predicates match the partition layout.
  3. Repeated ingestion can process a smaller changed subset rather than the full history.
  4. Original records remain available for replay and audit of downstream transformations.

Explanation

Correct Answer

A:

This is the expected outcome for Databricks Spark: Parallel distributed processing handles larger-than-single-server transformations.

Incorrect Answers

B:

This result would follow the different Analytical partitioning decision (Partition analytical data using an appropriate time-based partition strategy.) rather than the specified design.

C:

This result would follow the different Incremental loading decision (Load new or changed records incrementally using a reliable change marker.) rather than the specified design.

D:

This result would follow the different Landing raw data decision (Store the raw extracts in a bronze or raw lake zone.) rather than the specified design.

Question 599

A pipeline must transform terabytes of raw JSON in distributed compute jobs. Someone instead proposes: Load new or changed records incrementally using a reliable change marker. Which alternative is the best correction for the original requirement?

  1. Load new or changed records incrementally using a reliable change marker.
  2. Use Azure Databricks with Apache Spark for the transformation workload.
  3. Store the raw extracts in a bronze or raw lake zone.
  4. Partition analytical data using an appropriate time-based partition strategy.

Explanation

Correct Answer

B:

This correction addresses Databricks Spark. Parallel distributed processing handles larger-than-single-server transformations.

Incorrect Answers

A:

This choice is for Incremental loading, not the specific requirement. Repeated ingestion can process a smaller changed subset rather than the full history.

C:

This choice is for Landing raw data, not the specific requirement. Original records remain available for replay and audit of downstream transformations.

D:

This choice is for Analytical partitioning, not the specific requirement. Queries can scan fewer partitions when predicates match the partition layout.

Question 600

A data architect recommends this approach: Use Azure Databricks with Apache Spark for the transformation workload. Which situation most clearly calls for that approach?

  1. A 20-terabyte event table is typically filtered to only the last two days.
  2. An hourly pipeline currently re-reads a complete ten-year sales dataset even when only a few rows change.
  3. A pipeline must transform terabytes of raw JSON in distributed compute jobs.
  4. A data platform must preserve unmodified supplier extracts before any cleansing or enrichment.

Explanation

Correct Answer

C:

This situation calls for Databricks Spark. Parallel distributed processing handles larger-than-single-server transformations.

Incorrect Answers

A:

The other situation is better matched to Partition analytical data using an appropriate time-based partition strategy. Queries can scan fewer partitions when predicates match the partition layout.

B:

The other situation is better matched to Load new or changed records incrementally using a reliable change marker. Repeated ingestion can process a smaller changed subset rather than the full history.

D:

The other situation is better matched to Store the raw extracts in a bronze or raw lake zone. Original records remain available for replay and audit of downstream transformations.