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 80

Question 790

A data professional makes this decision: Use a Power BI matrix visual. Which outcome is the most direct expected result?

  1. The visual shows association, clusters and outliers across two measures.
  2. Pinned tiles provide one consolidated monitoring canvas.
  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

D:

This is the expected outcome for Matrix hierarchy: Hierarchical rows and cross-tabulated values can be expanded and summarized.

Incorrect Answers

A:

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.

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 Calculated column decision (Create a suitable calculated column if row-level materialization is intended.) rather than the specified design.

Question 791

A manager needs sales rows grouped by region and store with expandable subtotals and month columns. Someone instead proposes: Create a Power BI dashboard for the summary view. Which alternative is the best correction for the original requirement?

  1. Use a Power BI matrix visual.
  2. Use a scatter chart with spend and revenue on numeric axes.
  3. Create a Power BI dashboard for the summary view.
  4. Create a suitable calculated column if row-level materialization is intended.

Explanation

Correct Answer

A:

This correction addresses Matrix hierarchy. Hierarchical rows and cross-tabulated values can be expanded and summarized.

Incorrect Answers

B:

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

C:

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

D:

This choice is for Calculated column, not the specific requirement. Each model row receives a derived attribute according to the calculation.

Question 792

A data architect recommends this approach: Use a Power BI matrix visual. 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. An executive wants single-page monitoring tiles pinned from multiple reports and datasets in the Power BI service.
  4. An analyst wants to discover whether store advertising spend is associated with store revenue, one point per store.

Explanation

Correct Answer

B:

This situation calls for Matrix hierarchy. Hierarchical rows and cross-tabulated values can be expanded and summarized.

Incorrect Answers

A:

The other situation is better matched to Create a suitable calculated column if row-level materialization is intended. Each model row receives a derived attribute according to the calculation.

C:

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

D:

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.

Question 793

A sales visual should navigate from annual totals to quarters and months by selecting a hierarchy level. Which data concept, Azure service, or design decision most directly satisfies the requirement?

  1. Configure a date hierarchy with supported drill-down interactions.
  2. Use a geographic map visual with a valid location field.
  3. Build a reusable Power BI semantic model.
  4. Add a Power BI slicer bound to the region field.

Explanation

Correct Answer

A:

The requirement concerns Drilldown hierarchy. Users can inspect progressively finer time granularity from the same visual.

Incorrect Answers

B:

That action instead addresses Map by geography: Values can be interpreted in their spatial context. It does not directly satisfy the described Drilldown hierarchy need.

C:

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

D:

That action instead addresses Slicer control: Users can interactively limit report visuals to selected regions. It does not directly satisfy the described Drilldown hierarchy need.

Question 794

A data professional makes this decision: Configure a date hierarchy with supported drill-down interactions. Which outcome is the most direct expected result?

  1. Reports can consume a consistent data model and measures.
  2. Users can inspect progressively finer time granularity from the same visual.
  3. Users can interactively limit report visuals to selected regions.
  4. Values can be interpreted in their spatial context.

Explanation

Correct Answer

B:

This is the expected outcome for Drilldown hierarchy: Users can inspect progressively finer time granularity from the same visual.

Incorrect Answers

A:

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

C:

This result would follow the different Slicer control decision (Add a Power BI slicer bound to the region field.) rather than the specified design.

D:

This result would follow the different Map by geography decision (Use a geographic map visual with a valid location field.) rather than the specified design.

Question 795

A sales visual should navigate from annual totals to quarters and months by selecting a hierarchy level. Someone instead proposes: Build a reusable Power BI semantic model. Which alternative is the best correction for the original requirement?

  1. Add a Power BI slicer bound to the region field.
  2. Use a geographic map visual with a valid location field.
  3. Configure a date hierarchy with supported drill-down interactions.
  4. Build a reusable Power BI semantic model.

Explanation

Correct Answer

C:

This correction addresses Drilldown hierarchy. Users can inspect progressively finer time granularity from the same visual.

Incorrect Answers

A:

This choice is for Slicer control, not the specific requirement. Users can interactively limit report visuals to selected regions.

B:

This choice is for Map by geography, not the specific requirement. Values can be interpreted in their spatial context.

D:

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

Question 796

A data architect recommends this approach: Configure a date hierarchy with supported drill-down interactions. Which situation most clearly calls for that approach?

  1. A dashboard page needs a visible control that lets viewers select one or more regions and filter its charts.
  2. A regional company wants sales values displayed by geographic city locations across the country.
  3. Several reports must reuse shared relationships and business calculations instead of duplicating queries.
  4. A sales visual should navigate from annual totals to quarters and months by selecting a hierarchy level.

Explanation

Correct Answer

D:

This situation calls for Drilldown hierarchy. Users can inspect progressively finer time granularity from the same visual.

Incorrect Answers

A:

The other situation is better matched to Add a Power BI slicer bound to the region field. Users can interactively limit report visuals to selected regions.

B:

The other situation is better matched to Use a geographic map visual with a valid location field. Values can be interpreted in their spatial context.

C:

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

Question 797

A confidential management report should apply a persistent page-level filter across all page visuals for an approved business unit. Which data concept, Azure service, or design decision most directly satisfies the requirement?

  1. Use a line chart with time on the horizontal axis.
  2. Set an appropriate Power BI page-level filter.
  3. Use a card visual for the summarized measure.
  4. Create an appropriate many-to-one relationship from the sales fact to the product dimension.

Explanation

Correct Answer

B:

The requirement concerns Filter pane. All visuals on the target page respect the configured filter scope.

Incorrect Answers

A:

That action instead addresses Line time trend: Continuous time trends and changes across periods are easy to compare. It does not directly satisfy the described Filter pane need.

C:

That action instead addresses Card KPI: A single key figure is presented without unnecessary category axes. It does not directly satisfy the described Filter pane need.

D:

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

Question 798

A data professional makes this decision: Set an appropriate Power BI page-level filter. Which outcome is the most direct expected result?

  1. A single key figure is presented without unnecessary category axes.
  2. Continuous time trends and changes across periods are easy to compare.
  3. All visuals on the target page respect the configured filter scope.
  4. Product attributes can filter and group the related sales facts.

Explanation

Correct Answer

C:

This is the expected outcome for Filter pane: All visuals on the target page respect the configured filter scope.

Incorrect Answers

A:

This result would follow the different Card KPI decision (Use a card visual for the summarized measure.) rather than the specified design.

B:

This result would follow the different Line time trend decision (Use a line chart with time on the horizontal axis.) rather than the specified design.

D:

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.

Question 799

A confidential management report should apply a persistent page-level filter across all page visuals for an approved business unit. Someone instead proposes: Create an appropriate many-to-one relationship from the sales fact to the product dimension. Which alternative is the best correction for the original requirement?

  1. Use a line chart with time on the horizontal axis.
  2. Use a card visual for the summarized measure.
  3. Create an appropriate many-to-one relationship from the sales fact to the product dimension.
  4. Set an appropriate Power BI page-level filter.

Explanation

Correct Answer

D:

This correction addresses Filter pane. All visuals on the target page respect the configured filter scope.

Incorrect Answers

A:

This choice is for Line time trend, not the specific requirement. Continuous time trends and changes across periods are easy to compare.

B:

This choice is for Card KPI, not the specific requirement. A single key figure is presented without unnecessary category axes.

C:

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

Question 800

A data architect recommends this approach: Set an appropriate Power BI page-level filter. Which situation most clearly calls for that approach?

  1. A confidential management report should apply a persistent page-level filter across all page visuals for an approved business unit.
  2. An analyst has a sales fact table and a product dimension containing one row per product.
  3. An executive needs one prominent value for the current quarter's net profit.
  4. Management needs to see how monthly customer subscriptions rose and fell over a two-year timeline.

Explanation

Correct Answer

A:

This situation calls for Filter pane. All visuals on the target page respect the configured filter scope.

Incorrect Answers

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 card visual for the summarized measure. A single key figure is presented without unnecessary category axes.

D:

The other situation is better matched to Use a line chart with time on the horizontal axis. Continuous time trends and changes across periods are easy to compare.