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 65

Question 640

A data architect recommends this approach: Maintain data lineage metadata across pipelines and analytical assets. Which situation most clearly calls for that approach?

  1. A scheduled analytics workflow must run copy, transformation and validation activities in a known sequence with retry logic.
  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 platform has abundant warehouse compute and wants to load source records before performing standardization.

Explanation

Correct Answer

C:

This situation calls for Data lineage. The route from source datasets to the published metric can be traced.

Incorrect Answers

A:

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.

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 extract-load-transform pipeline in the analytical target. Data transformations execute after data has entered the scalable destination.

Question 641

A data science team can wait until 2 AM to refresh a large feature dataset from a day's events. 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 Data Factory capabilities within Microsoft Fabric.
  4. Use a Fabric Data Warehouse.

Explanation

Correct Answer

B:

The requirement concerns Batch job execution. A bounded set of accumulated events is processed at the planned interval.

Incorrect Answers

A:

That action instead addresses ETL before landing: The reporting target receives already-prepared information. It does not directly satisfy the described Batch job execution 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 Batch job execution need.

D:

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

Question 642

A data professional makes this decision: Run the transformation as a scheduled batch analytics job. Which outcome is the most direct expected result?

  1. The reporting target receives already-prepared information.
  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. Integrated Fabric pipelines and dataflows can prepare data for downstream workloads.

Explanation

Correct Answer

C:

This is the expected outcome for Batch job execution: A bounded set of accumulated events is processed at the planned interval.

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

D:

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

Question 643

A data science team can wait until 2 AM to refresh a large feature dataset from a day's events. Someone instead proposes: Use Data Factory capabilities within Microsoft Fabric. Which alternative is the best correction for the original requirement?

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

Explanation

Correct Answer

D:

This correction addresses Batch job execution. A bounded set of accumulated events is processed at the planned interval.

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 Fabric warehouse, not the specific requirement. Analysts can query curated dimensional and fact tables with SQL semantics.

C:

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

Question 644

A data architect recommends this approach: Run the transformation as a scheduled batch analytics job. Which situation most clearly calls for that approach?

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

Explanation

Correct Answer

A:

This situation calls for Batch job execution. A bounded set of accumulated events is processed at the planned interval.

Incorrect Answers

B:

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

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 Use Data Factory capabilities within Microsoft Fabric. Integrated Fabric pipelines and dataflows can prepare data for downstream workloads.

Question 645

A 20-terabyte event table is typically filtered to only the last two days. Which data concept, Azure service, or design decision most directly satisfies the requirement?

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

Explanation

Correct Answer

C:

The requirement concerns Analytical partitioning. Queries can scan fewer partitions when predicates match the partition layout.

Incorrect Answers

A:

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

B:

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 Analytical partitioning need.

D:

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 Analytical partitioning need.

Question 646

A data professional makes this decision: Partition analytical data using an appropriate time-based partition strategy. Which outcome is the most direct expected result?

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

Explanation

Correct Answer

D:

This is the expected outcome for Analytical partitioning: Queries can scan fewer partitions when predicates match the partition layout.

Incorrect Answers

A:

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.

B:

This result would follow the different Databricks Spark decision (Use Azure Databricks with Apache Spark for the transformation workload.) 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.

Question 647

A 20-terabyte event table is typically filtered to only the last two days. Someone instead proposes: Store the raw extracts in a bronze or raw lake zone. Which alternative is the best correction for the original requirement?

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

Explanation

Correct Answer

A:

This correction addresses Analytical partitioning. Queries can scan fewer partitions when predicates match the partition layout.

Incorrect Answers

B:

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 Databricks Spark, not the specific requirement. Parallel distributed processing handles larger-than-single-server transformations.

D:

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

Question 648

A data architect recommends this approach: Partition analytical data using an appropriate time-based partition strategy. Which situation most clearly calls for that approach?

  1. A pipeline must transform terabytes of raw JSON in distributed compute jobs.
  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. An hourly pipeline currently re-reads a complete ten-year sales dataset even when only a few rows change.

Explanation

Correct Answer

B:

This situation calls for Analytical partitioning. Queries can scan fewer partitions when predicates match the partition layout.

Incorrect Answers

A:

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.

C:

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.

D:

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.

Question 649

A retailer needs to group billions of click records by channel and week for recurring analysis. 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 Spark DataFrame transformations.
  3. Configure pipeline run monitoring and alerts for failed activities.
  4. Use distributed or warehouse-optimized analytical aggregation compute.

Explanation

Correct Answer

D:

The requirement concerns Large-scale aggregation. Wide historical scans and group calculations can run on scalable resources.

Incorrect Answers

A:

That action instead addresses Standardized silver: Cleaned and standardized records can be reused by multiple analytical consumers. It does not directly satisfy the described Large-scale aggregation need.

B:

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 Large-scale aggregation 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 Large-scale aggregation need.

Question 650

A data professional makes this decision: Use distributed or warehouse-optimized analytical aggregation compute. Which outcome is the most direct expected result?

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

Explanation

Correct Answer

A:

This is the expected outcome for Large-scale aggregation: Wide historical scans and group calculations can run on scalable resources.

Incorrect Answers

B:

This result would follow the different Standardized silver decision (Apply quality and schema normalization in a curated silver layer.) rather than the specified design.

C:

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

D:

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