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 76

Question 750

A data professional makes this decision: Create a DAX measure for the revenue aggregation. Which outcome is the most direct expected result?

  1. Relative magnitudes across many labeled categories can be compared.
  2. Pinned tiles provide one consolidated monitoring canvas.
  3. Precise row and column values can be reviewed directly.
  4. The displayed calculation responds to the active filter context.

Explanation

Correct Answer

D:

This is the expected outcome for DAX measure: The displayed calculation responds to the active filter context.

Incorrect Answers

A:

This result would follow the different Bar category comparison decision (Use a bar chart with categories and a common numeric scale.) rather than the specified design.

B:

This result would follow the different Power BI dashboard decision (Create a Power BI dashboard for the summary view.) rather than the specified design.

C:

This result would follow the different Table detail decision (Use a Power BI table visual.) rather than the specified design.

Question 751

Users need total revenue recalculated as slicers change, not a fixed value saved in each row. Someone instead proposes: Use a bar chart with categories and a common numeric scale. Which alternative is the best correction for the original requirement?

  1. Create a DAX measure for the revenue aggregation.
  2. Use a bar chart with categories and a common numeric scale.
  3. Use a Power BI table visual.
  4. Create a Power BI dashboard for the summary view.

Explanation

Correct Answer

A:

This correction addresses DAX measure. The displayed calculation responds to the active filter context.

Incorrect Answers

B:

This choice is for Bar category comparison, not the specific requirement. Relative magnitudes across many labeled categories can be compared.

C:

This choice is for Table detail, not the specific requirement. Precise row and column values can be reviewed directly.

D:

This choice is for Power BI dashboard, not the specific requirement. Pinned tiles provide one consolidated monitoring canvas.

Question 752

A data architect recommends this approach: Create a DAX measure for the revenue aggregation. Which situation most clearly calls for that approach?

  1. An executive wants single-page monitoring tiles pinned from multiple reports and datasets in the Power BI service.
  2. Users need total revenue recalculated as slicers change, not a fixed value saved in each row.
  3. A finance analyst needs exact invoice numbers, customer names and amounts rather than graphical approximations.
  4. An operations manager wants to compare total incident counts among 15 department categories.

Explanation

Correct Answer

B:

This situation calls for DAX measure. The displayed calculation responds to the active filter context.

Incorrect Answers

A:

The other situation is better matched to Create a Power BI dashboard for the summary view. Pinned tiles provide one consolidated monitoring canvas.

C:

The other situation is better matched to Use a Power BI table visual. Precise row and column values can be reviewed directly.

D:

The other situation is better matched to Use a bar chart with categories and a common numeric scale. Relative magnitudes across many labeled categories can be compared.

Question 753

A model needs a row-level category derived from each product's stored code and retained in the model. Which data concept, Azure service, or design decision most directly satisfies the requirement?

  1. Use a Power BI matrix visual.
  2. Create a suitable calculated column if row-level materialization is intended.
  3. Use a stacked column chart broken down by business unit.
  4. Build a reusable Power BI semantic model.

Explanation

Correct Answer

B:

The requirement concerns Calculated column. Each model row receives a derived attribute according to the calculation.

Incorrect Answers

A:

That action instead addresses Matrix hierarchy: Hierarchical rows and cross-tabulated values can be expanded and summarized. It does not directly satisfy the described Calculated column need.

C:

That action instead addresses Stacked composition: The total and its component contributions are displayed together. It does not directly satisfy the described Calculated column need.

D:

That action instead addresses Power BI semantic model: Reports can consume a consistent data model and measures. It does not directly satisfy the described Calculated column need.

Question 754

A data professional makes this decision: Create a suitable calculated column if row-level materialization is intended. Which outcome is the most direct expected result?

  1. The total and its component contributions are displayed together.
  2. Reports can consume a consistent data model and measures.
  3. Each model row receives a derived attribute according to the calculation.
  4. Hierarchical rows and cross-tabulated values can be expanded and summarized.

Explanation

Correct Answer

C:

This is the expected outcome for Calculated column: Each model row receives a derived attribute according to the calculation.

Incorrect Answers

A:

This result would follow the different Stacked composition decision (Use a stacked column chart broken down by business unit.) rather than the specified design.

B:

This result would follow the different Power BI semantic model decision (Build a reusable Power BI semantic model.) rather than the specified design.

D:

This result would follow the different Matrix hierarchy decision (Use a Power BI matrix visual.) rather than the specified design.

Question 755

A model needs a row-level category derived from each product's stored code and retained in the model. Someone instead proposes: Use a stacked column chart broken down by business unit. Which alternative is the best correction for the original requirement?

  1. Use a stacked column chart broken down by business unit.
  2. Use a Power BI matrix visual.
  3. Build a reusable Power BI semantic model.
  4. Create a suitable calculated column if row-level materialization is intended.

Explanation

Correct Answer

D:

This correction addresses Calculated column. Each model row receives a derived attribute according to the calculation.

Incorrect Answers

A:

This choice is for Stacked composition, not the specific requirement. The total and its component contributions are displayed together.

B:

This choice is for Matrix hierarchy, not the specific requirement. Hierarchical rows and cross-tabulated values can be expanded and summarized.

C:

This choice is for Power BI semantic model, not the specific requirement. Reports can consume a consistent data model and measures.

Question 756

A data architect recommends this approach: Create a suitable calculated column if row-level materialization is intended. Which situation most clearly calls for that approach?

  1. A model needs a row-level category derived from each product's stored code and retained in the model.
  2. A manager needs sales rows grouped by region and store with expandable subtotals and month columns.
  3. A report must compare quarterly total revenue and show how each business unit contributes to the total.
  4. Several reports must reuse shared relationships and business calculations instead of duplicating queries.

Explanation

Correct Answer

A:

This situation calls for Calculated column. Each model row receives a derived attribute according to the calculation.

Incorrect Answers

B:

The other situation is better matched to Use a Power BI matrix visual. Hierarchical rows and cross-tabulated values can be expanded and summarized.

C:

The other situation is better matched to Use a stacked column chart broken down by business unit. The total and its component contributions are displayed together.

D:

The other situation is better matched to Build a reusable Power BI semantic model. Reports can consume a consistent data model and measures.

Question 757

A dashboard page needs a visible control that lets viewers select one or more regions and filter its charts. Which data concept, Azure service, or design decision most directly satisfies the requirement?

  1. Add a Power BI slicer bound to the region field.
  2. Use a scatter chart with spend and revenue on numeric axes.
  3. Create an appropriate many-to-one relationship from the sales fact to the product dimension.
  4. Configure a date hierarchy with supported drill-down interactions.

Explanation

Correct Answer

A:

The requirement concerns Slicer control. Users can interactively limit report visuals to selected regions.

Incorrect Answers

B:

That action instead addresses Scatter relationship: The visual shows association, clusters and outliers across two measures. It does not directly satisfy the described Slicer control need.

C:

That action instead addresses Fact dimension relationship: Product attributes can filter and group the related sales facts. It does not directly satisfy the described Slicer control need.

D:

That action instead addresses Drilldown hierarchy: Users can inspect progressively finer time granularity from the same visual. It does not directly satisfy the described Slicer control need.

Question 758

A data professional makes this decision: Add a Power BI slicer bound to the region field. Which outcome is the most direct expected result?

  1. Product attributes can filter and group the related sales facts.
  2. Users can interactively limit report visuals to selected regions.
  3. The visual shows association, clusters and outliers across two measures.
  4. Users can inspect progressively finer time granularity from the same visual.

Explanation

Correct Answer

B:

This is the expected outcome for Slicer control: Users can interactively limit report visuals to selected regions.

Incorrect Answers

A:

This result would follow the different Fact dimension relationship decision (Create an appropriate many-to-one relationship from the sales fact to the product dimension.) rather than the specified design.

C:

This result would follow the different Scatter relationship decision (Use a scatter chart with spend and revenue on numeric axes.) rather than the specified design.

D:

This result would follow the different Drilldown hierarchy decision (Configure a date hierarchy with supported drill-down interactions.) rather than the specified design.

Question 759

A dashboard page needs a visible control that lets viewers select one or more regions and filter its charts. Someone instead proposes: Use a scatter chart with spend and revenue on numeric axes. Which alternative is the best correction for the original requirement?

  1. Create an appropriate many-to-one relationship from the sales fact to the product dimension.
  2. Use a scatter chart with spend and revenue on numeric axes.
  3. Add a Power BI slicer bound to the region field.
  4. Configure a date hierarchy with supported drill-down interactions.

Explanation

Correct Answer

C:

This correction addresses Slicer control. Users can interactively limit report visuals to selected regions.

Incorrect Answers

A:

This choice is for Fact dimension relationship, not the specific requirement. Product attributes can filter and group the related sales facts.

B:

This choice is for Scatter relationship, not the specific requirement. The visual shows association, clusters and outliers across two measures.

D:

This choice is for Drilldown hierarchy, not the specific requirement. Users can inspect progressively finer time granularity from the same visual.

Question 760

A data architect recommends this approach: Add a Power BI slicer bound to the region field. Which situation most clearly calls for that approach?

  1. A sales visual should navigate from annual totals to quarters and months by selecting a hierarchy level.
  2. An analyst has a sales fact table and a product dimension containing one row per product.
  3. An analyst wants to discover whether store advertising spend is associated with store revenue, one point per store.
  4. A dashboard page needs a visible control that lets viewers select one or more regions and filter its charts.

Explanation

Correct Answer

D:

This situation calls for Slicer control. Users can interactively limit report visuals to selected regions.

Incorrect Answers

A:

The other situation is better matched to Configure a date hierarchy with supported drill-down interactions. Users can inspect progressively finer time granularity from the same visual.

B:

The other situation is better matched to Create an appropriate many-to-one relationship from the sales fact to the product dimension. Product attributes can filter and group the related sales facts.

C:

The other situation is better matched to Use a scatter chart with spend and revenue on numeric axes. The visual shows association, clusters and outliers across two measures.