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 58

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.

Question 571

A team building analytics natively in Microsoft Fabric needs managed data movement and transformation orchestration. Someone instead proposes: Use a Fabric Data Warehouse. Which alternative is the best correction for the original requirement?

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

Explanation

Correct Answer

B:

This correction addresses Fabric Data Factory. Integrated Fabric pipelines and dataflows can prepare data for downstream workloads.

Incorrect Answers

A:

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

C:

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

D:

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

Question 572

A data architect recommends this approach: Use Data Factory capabilities within Microsoft Fabric. 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 data science team can wait until 2 AM to refresh a large feature dataset from a day's events.
  3. A team building analytics natively in Microsoft Fabric needs managed data movement and transformation orchestration.
  4. A reporting department needs a managed relational analytical warehouse with familiar SQL-oriented access in Microsoft Fabric.

Explanation

Correct Answer

C:

This situation calls for Fabric Data Factory. Integrated Fabric pipelines and dataflows can prepare data for downstream workloads.

Incorrect Answers

A:

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.

B:

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.

D:

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

Question 573

A data platform must preserve unmodified supplier extracts before any cleansing or enrichment. Which data concept, Azure service, or design decision most directly satisfies the requirement?

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

Explanation

Correct Answer

D:

The requirement concerns Landing raw data. Original records remain available for replay and audit of downstream transformations.

Incorrect Answers

A:

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

B:

That action instead addresses Databricks Spark: Parallel distributed processing handles larger-than-single-server transformations. It does not directly satisfy the described Landing raw data need.

C:

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 Landing raw data need.

Question 574

A data professional makes this decision: Store the raw extracts in a bronze or raw lake zone. Which outcome is the most direct expected result?

  1. Original records remain available for replay and audit of downstream 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. Parallel distributed processing handles larger-than-single-server transformations.

Explanation

Correct Answer

A:

This is the expected outcome for Landing raw data: Original records remain available for replay and audit of downstream 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 Databricks Spark decision (Use Azure Databricks with Apache Spark for the transformation workload.) rather than the specified design.

Question 575

A data platform must preserve unmodified supplier extracts before any cleansing or enrichment. Someone instead proposes: Use Azure Databricks with Apache Spark for the transformation workload. Which alternative is the best correction for the original requirement?

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

Explanation

Correct Answer

B:

This correction addresses Landing raw data. Original records remain available for replay and audit of downstream transformations.

Incorrect Answers

A:

This choice is for Databricks Spark, not the specific requirement. Parallel distributed processing handles larger-than-single-server transformations.

C:

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

D:

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

Question 576

A data architect recommends this approach: Store the raw extracts in a bronze or raw lake zone. Which situation most clearly calls for that approach?

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

Explanation

Correct Answer

C:

This situation calls for Landing raw data. Original records remain available for replay and audit of downstream transformations.

Incorrect Answers

A:

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.

B:

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.

D:

The other situation is better matched to Use Azure Databricks with Apache Spark for the transformation workload. Parallel distributed processing handles larger-than-single-server transformations.

Question 577

An analytics pipeline receives inconsistent customer field names and duplicate transaction IDs. Which data concept, Azure service, or design decision most directly satisfies the requirement?

  1. Apply quality and schema normalization in a curated silver layer.
  2. Use distributed or warehouse-optimized analytical aggregation compute.
  3. Configure pipeline run monitoring and alerts for failed activities.
  4. Use distributed Spark DataFrame transformations.

Explanation

Correct Answer

A:

The requirement concerns Standardized silver. Cleaned and standardized records can be reused by multiple analytical consumers.

Incorrect Answers

B:

That action instead addresses Large-scale aggregation: Wide historical scans and group calculations can run on scalable resources. It does not directly satisfy the described Standardized silver need.

C:

That action instead addresses Data pipeline monitoring: Operators can detect and investigate ingestion failures before reporting deadlines. It does not directly satisfy the described Standardized silver need.

D:

That action instead addresses Spark dataframe: The join can be executed across the cluster rather than on one desktop machine. It does not directly satisfy the described Standardized silver need.

Question 578

A data professional makes this decision: Apply quality and schema normalization in a curated silver layer. Which outcome is the most direct expected result?

  1. The join can be executed across the cluster rather than on one desktop machine.
  2. Cleaned and standardized records can be reused by multiple analytical consumers.
  3. Wide historical scans and group calculations can run on scalable resources.
  4. Operators can detect and investigate ingestion failures before reporting deadlines.

Explanation

Correct Answer

B:

This is the expected outcome for Standardized silver: Cleaned and standardized records can be reused by multiple analytical consumers.

Incorrect Answers

A:

This result would follow the different Spark dataframe decision (Use distributed Spark DataFrame transformations.) rather than the specified design.

C:

This result would follow the different Large-scale aggregation decision (Use distributed or warehouse-optimized analytical aggregation compute.) rather than the specified design.

D:

This result would follow the different Data pipeline monitoring decision (Configure pipeline run monitoring and alerts for failed activities.) rather than the specified design.

Question 579

An analytics pipeline receives inconsistent customer field names and duplicate transaction IDs. Someone instead proposes: Use distributed Spark DataFrame transformations. Which alternative is the best correction for the original requirement?

  1. Configure pipeline run monitoring and alerts for failed activities.
  2. Use distributed or warehouse-optimized analytical aggregation compute.
  3. Apply quality and schema normalization in a curated silver layer.
  4. Use distributed Spark DataFrame transformations.

Explanation

Correct Answer

C:

This correction addresses Standardized silver. Cleaned and standardized records can be reused by multiple analytical consumers.

Incorrect Answers

A:

This choice is for Data pipeline monitoring, not the specific requirement. Operators can detect and investigate ingestion failures before reporting deadlines.

B:

This choice is for Large-scale aggregation, not the specific requirement. Wide historical scans and group calculations can run on scalable resources.

D:

This choice is for Spark dataframe, not the specific requirement. The join can be executed across the cluster rather than on one desktop machine.

Question 580

A data architect recommends this approach: Apply quality and schema normalization in a curated silver layer. Which situation most clearly calls for that approach?

  1. A data engineer needs to join two large datasets across a distributed cluster and project selected attributes.
  2. A retailer needs to group billions of click records by channel and week for recurring analysis.
  3. A failed nightly load went unnoticed, leaving dashboards with yesterday's stale totals.
  4. An analytics pipeline receives inconsistent customer field names and duplicate transaction IDs.

Explanation

Correct Answer

D:

This situation calls for Standardized silver. Cleaned and standardized records can be reused by multiple analytical consumers.

Incorrect Answers

A:

The other situation is better matched to Use distributed Spark DataFrame transformations. The join can be executed across the cluster rather than on one desktop machine.

B:

The other situation is better matched to Use distributed or warehouse-optimized analytical aggregation compute. Wide historical scans and group calculations can run on scalable resources.

C:

The other situation is better matched to Configure pipeline run monitoring and alerts for failed activities. Operators can detect and investigate ingestion failures before reporting deadlines.