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 59

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.

Question 581

Executives need stable sales-by-region measures derived from cleansed transactional history. Which data concept, Azure service, or design decision most directly satisfies the requirement?

  1. Use a Delta table format where supported.
  2. Publish approved business aggregates in a gold serving layer.
  3. Design ingestion transformations with explicit handling of supported schema drift.
  4. Publish a governed shared semantic model for the business measures.

Explanation

Correct Answer

B:

The requirement concerns Gold business data. Reporting users consume curated tables designed around shared business measures.

Incorrect Answers

A:

That action instead addresses Delta Lake table: A transaction log provides managed table state over the underlying analytical files. It does not directly satisfy the described Gold business data need.

C:

That action instead addresses Analytics schema drift: Allowed new fields are processed without silently corrupting the curated dataset. It does not directly satisfy the described Gold business data need.

D:

That action instead addresses Curated semantic layer: Downstream consumers can reuse consistently defined metrics. It does not directly satisfy the described Gold business data need.

Question 582

A data professional makes this decision: Publish approved business aggregates in a gold serving layer. Which outcome is the most direct expected result?

  1. Downstream consumers can reuse consistently defined metrics.
  2. A transaction log provides managed table state over the underlying analytical files.
  3. Reporting users consume curated tables designed around shared business measures.
  4. Allowed new fields are processed without silently corrupting the curated dataset.

Explanation

Correct Answer

C:

This is the expected outcome for Gold business data: Reporting users consume curated tables designed around shared business measures.

Incorrect Answers

A:

This result would follow the different Curated semantic layer decision (Publish a governed shared semantic model for the business measures.) rather than the specified design.

B:

This result would follow the different Delta Lake table decision (Use a Delta table format where supported.) rather than the specified design.

D:

This result would follow the different Analytics schema drift decision (Design ingestion transformations with explicit handling of supported schema drift.) rather than the specified design.

Question 583

Executives need stable sales-by-region measures derived from cleansed transactional history. Someone instead proposes: Use a Delta table format where supported. Which alternative is the best correction for the original requirement?

  1. Publish a governed shared semantic model for the business measures.
  2. Use a Delta table format where supported.
  3. Design ingestion transformations with explicit handling of supported schema drift.
  4. Publish approved business aggregates in a gold serving layer.

Explanation

Correct Answer

D:

This correction addresses Gold business data. Reporting users consume curated tables designed around shared business measures.

Incorrect Answers

A:

This choice is for Curated semantic layer, not the specific requirement. Downstream consumers can reuse consistently defined metrics.

B:

This choice is for Delta Lake table, not the specific requirement. A transaction log provides managed table state over the underlying analytical files.

C:

This choice is for Analytics schema drift, not the specific requirement. Allowed new fields are processed without silently corrupting the curated dataset.

Question 584

A data architect recommends this approach: Publish approved business aggregates in a gold serving layer. Which situation most clearly calls for that approach?

  1. Executives need stable sales-by-region measures derived from cleansed transactional history.
  2. Three dashboards implement different formulas for revenue despite sharing the same warehouse.
  3. An upstream JSON feed adds an optional attribute and the pipeline must tolerate legitimate source changes.
  4. A lakehouse team needs reliable table updates and transactional behavior on files held in object storage.

Explanation

Correct Answer

A:

This situation calls for Gold business data. Reporting users consume curated tables designed around shared business measures.

Incorrect Answers

B:

The other situation is better matched to Publish a governed shared semantic model for the business measures. Downstream consumers can reuse consistently defined metrics.

C:

The other situation is better matched to Design ingestion transformations with explicit handling of supported schema drift. Allowed new fields are processed without silently corrupting the curated dataset.

D:

The other situation is better matched to Use a Delta table format where supported. A transaction log provides managed table state over the underlying analytical files.

Question 585

Separate teams using Microsoft Fabric need a logical organization-wide data lake that multiple analytics workloads can access. Which data concept, Azure service, or design decision most directly satisfies the 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

C:

The requirement concerns Fabric OneLake. Analytical workloads can work from a unified lake storage layer.

Incorrect Answers

A:

That action instead addresses Data ingestion: Source records are transferred into a controlled analytical landing zone. It does not directly satisfy the described Fabric OneLake 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 Fabric OneLake need.

D:

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

Question 586

A data professional makes this decision: Use Microsoft OneLake as the Fabric data lake foundation. Which outcome is the most direct expected result?

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

Explanation

Correct Answer

D:

This is the expected outcome for Fabric OneLake: Analytical workloads can work from a unified lake storage layer.

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 Data ingestion decision (Build a managed data ingestion pipeline from the source systems.) 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 587

Separate teams using Microsoft Fabric need a logical organization-wide data lake that multiple analytics workloads can access. Someone instead proposes: Store prepared analytical records in a column-oriented format such as Parquet. Which alternative is the best correction for the original requirement?

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

Explanation

Correct Answer

A:

This correction addresses Fabric OneLake. Analytical workloads can work from a unified lake storage layer.

Incorrect Answers

B:

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

C:

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

D:

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

Question 588

A data architect recommends this approach: Use Microsoft OneLake as the Fabric data lake foundation. Which situation most clearly calls for that approach?

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

Explanation

Correct Answer

B:

This situation calls for Fabric OneLake. Analytical workloads can work from a unified lake storage layer.

Incorrect Answers

A:

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.

C:

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.

D:

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 589

A data team wants files and Delta tables accessible to Spark jobs with SQL-accessible tables where supported. Which data concept, Azure service, or design decision most directly satisfies the requirement?

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

Explanation

Correct Answer

C:

The requirement concerns Fabric lakehouse. A lakehouse brings file-based storage and table-oriented analytics together.

Incorrect Answers

A:

That action instead addresses ELT in warehouse: Data transformations execute after data has entered the scalable destination. It does not directly satisfy the described Fabric lakehouse 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 Fabric lakehouse need.

D:

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

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.