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 61

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.

Question 601

A data engineer needs to join two large datasets across a distributed cluster and project selected attributes. Which data concept, Azure service, or design decision most directly satisfies the requirement?

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

Explanation

Correct Answer

A:

The requirement concerns Spark dataframe. The join can be executed across the cluster rather than on one desktop machine.

Incorrect Answers

B:

That action instead addresses Standardized silver: Cleaned and standardized records can be reused by multiple analytical consumers. It does not directly satisfy the described Spark dataframe 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 Spark dataframe need.

D:

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 Spark dataframe need.

Question 602

A data professional makes this decision: Use distributed Spark DataFrame transformations. Which outcome is the most direct expected result?

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

Explanation

Correct Answer

B:

This is the expected outcome for Spark dataframe: The join can be executed across the cluster rather than on one desktop machine.

Incorrect Answers

A:

This result would follow the different Large-scale aggregation decision (Use distributed or warehouse-optimized analytical aggregation compute.) 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 Standardized silver decision (Apply quality and schema normalization in a curated silver layer.) rather than the specified design.

Question 603

A data engineer needs to join two large datasets across a distributed cluster and project selected attributes. Someone instead proposes: Configure pipeline run monitoring and alerts for failed activities. Which alternative is the best correction for the original requirement?

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

Explanation

Correct Answer

C:

This correction addresses Spark dataframe. The join can be executed across the cluster rather than on one desktop machine.

Incorrect Answers

A:

This choice is for Standardized silver, not the specific requirement. Cleaned and standardized records can be reused by multiple analytical consumers.

B:

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

D:

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

Question 604

A data architect recommends this approach: Use distributed Spark DataFrame transformations. Which situation most clearly calls for that approach?

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

Explanation

Correct Answer

D:

This situation calls for Spark dataframe. The join can be executed across the cluster rather than on one desktop machine.

Incorrect Answers

A:

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.

B:

The other situation is better matched to Apply quality and schema normalization in a curated silver layer. Cleaned and standardized records can be reused by multiple analytical consumers.

C:

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.

Question 605

A lakehouse team needs reliable table updates and transactional behavior on files held in object storage. Which data concept, Azure service, or design decision most directly satisfies the requirement?

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

Explanation

Correct Answer

A:

The requirement concerns Delta Lake table. A transaction log provides managed table state over the underlying analytical files.

Incorrect Answers

B:

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 Delta Lake table need.

C:

That action instead addresses Gold business data: Reporting users consume curated tables designed around shared business measures. It does not directly satisfy the described Delta Lake table need.

D:

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

Question 606

A data professional makes this decision: Use a Delta table format where supported. Which outcome is the most direct expected result?

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

Explanation

Correct Answer

B:

This is the expected outcome for Delta Lake table: A transaction log provides managed table state over the underlying analytical files.

Incorrect Answers

A:

This result would follow the different Gold business data decision (Publish approved business aggregates in a gold serving layer.) rather than the specified design.

C:

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.

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 607

A lakehouse team needs reliable table updates and transactional behavior on files held in object storage. Someone instead proposes: Design ingestion transformations with explicit handling of supported schema drift. Which alternative is the best correction for the original requirement?

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

Explanation

Correct Answer

C:

This correction addresses Delta Lake table. A transaction log provides managed table state over the underlying analytical files.

Incorrect Answers

A:

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

B:

This choice is for Gold business data, not the specific requirement. Reporting users consume curated tables designed around shared business measures.

D:

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

Question 608

A data architect recommends this approach: Use a Delta table format where supported. Which situation most clearly calls for that approach?

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

Explanation

Correct Answer

D:

This situation calls for Delta Lake table. A transaction log provides managed table state over the underlying analytical files.

Incorrect Answers

A:

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

B:

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.

C:

The other situation is better matched to Publish approved business aggregates in a gold serving layer. Reporting users consume curated tables designed around shared business measures.

Question 609

Most monthly reports read just a few fields from wide historical event datasets. Which data concept, Azure service, or design decision most directly satisfies the requirement?

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

Explanation

Correct Answer

A:

The requirement concerns Parquet compression. Columnar scans can avoid loading unrelated columns and support compression.

Incorrect Answers

B:

That action instead addresses Fabric OneLake: Analytical workloads can work from a unified lake storage layer. It does not directly satisfy the described Parquet compression need.

C:

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

D:

That action instead addresses Data ingestion: Source records are transferred into a controlled analytical landing zone. It does not directly satisfy the described Parquet compression need.

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.