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 77

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.

Question 761

Management needs to see how monthly customer subscriptions rose and fell over a two-year timeline. Which data concept, Azure service, or design decision most directly satisfies the requirement?

  1. Use a geographic map visual with a valid location field.
  2. Use a line chart with time on the horizontal axis.
  3. Set an appropriate Power BI page-level filter.
  4. Model the data as a star schema with facts and dimensions.

Explanation

Correct Answer

B:

The requirement concerns Line time trend. Continuous time trends and changes across periods are easy to compare.

Incorrect Answers

A:

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

C:

That action instead addresses Filter pane: All visuals on the target page respect the configured filter scope. It does not directly satisfy the described Line time trend need.

D:

That action instead addresses Star schema: A clear fact-to-dimension design supports understandable analytical filtering. It does not directly satisfy the described Line time trend need.

Question 762

A data professional makes this decision: Use a line chart with time on the horizontal axis. Which outcome is the most direct expected result?

  1. A clear fact-to-dimension design supports understandable analytical filtering.
  2. All visuals on the target page respect the configured filter scope.
  3. Continuous time trends and changes across periods are easy to compare.
  4. Values can be interpreted in their spatial context.

Explanation

Correct Answer

C:

This is the expected outcome for Line time trend: Continuous time trends and changes across periods are easy to compare.

Incorrect Answers

A:

This result would follow the different Star schema decision (Model the data as a star schema with facts and dimensions.) rather than the specified design.

B:

This result would follow the different Filter pane decision (Set an appropriate Power BI page-level filter.) 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 763

Management needs to see how monthly customer subscriptions rose and fell over a two-year timeline. Someone instead proposes: Use a geographic map visual with a valid location field. Which alternative is the best correction for the original requirement?

  1. Use a geographic map visual with a valid location field.
  2. Model the data as a star schema with facts and dimensions.
  3. Set an appropriate Power BI page-level filter.
  4. Use a line chart with time on the horizontal axis.

Explanation

Correct Answer

D:

This correction addresses Line time trend. Continuous time trends and changes across periods are easy to compare.

Incorrect Answers

A:

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

B:

This choice is for Star schema, not the specific requirement. A clear fact-to-dimension design supports understandable analytical filtering.

C:

This choice is for Filter pane, not the specific requirement. All visuals on the target page respect the configured filter scope.

Question 764

A data architect recommends this approach: Use a line chart with time on the horizontal axis. Which situation most clearly calls for that approach?

  1. Management needs to see how monthly customer subscriptions rose and fell over a two-year timeline.
  2. A regional company wants sales values displayed by geographic city locations across the country.
  3. A confidential management report should apply a persistent page-level filter across all page visuals for an approved business unit.
  4. A warehouse report joins a central transaction table with date, store and product lookup tables.

Explanation

Correct Answer

A:

This situation calls for Line time trend. Continuous time trends and changes across periods are easy to compare.

Incorrect Answers

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 Set an appropriate Power BI page-level filter. All visuals on the target page respect the configured filter scope.

D:

The other situation is better matched to Model the data as a star schema with facts and dimensions. A clear fact-to-dimension design supports understandable analytical filtering.

Question 765

An operations manager wants to compare total incident counts among 15 department categories. Which data concept, Azure service, or design decision most directly satisfies the requirement?

  1. Use a bar chart with categories and a common numeric scale.
  2. Create a Power BI report with the required report pages.
  3. Create a DAX measure for the revenue aggregation.
  4. Use a card visual for the summarized measure.

Explanation

Correct Answer

A:

The requirement concerns Bar category comparison. Relative magnitudes across many labeled categories can be compared.

Incorrect Answers

B:

That action instead addresses Power BI report: Users can explore related visuals and filter the modeled data interactively. It does not directly satisfy the described Bar category comparison need.

C:

That action instead addresses DAX measure: The displayed calculation responds to the active filter context. It does not directly satisfy the described Bar category comparison need.

D:

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

Question 766

A data professional makes this decision: Use a bar chart with categories and a common numeric scale. Which outcome is the most direct expected result?

  1. The displayed calculation responds to the active filter context.
  2. Relative magnitudes across many labeled categories can be compared.
  3. A single key figure is presented without unnecessary category axes.
  4. Users can explore related visuals and filter the modeled data interactively.

Explanation

Correct Answer

B:

This is the expected outcome for Bar category comparison: Relative magnitudes across many labeled categories can be compared.

Incorrect Answers

A:

This result would follow the different DAX measure decision (Create a DAX measure for the revenue aggregation.) rather than the specified design.

C:

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

D:

This result would follow the different Power BI report decision (Create a Power BI report with the required report pages.) rather than the specified design.

Question 767

An operations manager wants to compare total incident counts among 15 department categories. Someone instead proposes: Use a card visual for the summarized measure. Which alternative is the best correction for the original requirement?

  1. Use a card visual for the summarized measure.
  2. Create a Power BI report with the required report pages.
  3. Use a bar chart with categories and a common numeric scale.
  4. Create a DAX measure for the revenue aggregation.

Explanation

Correct Answer

C:

This correction addresses Bar category comparison. Relative magnitudes across many labeled categories can be compared.

Incorrect Answers

A:

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

B:

This choice is for Power BI report, not the specific requirement. Users can explore related visuals and filter the modeled data interactively.

D:

This choice is for DAX measure, not the specific requirement. The displayed calculation responds to the active filter context.

Question 768

A data architect recommends this approach: Use a bar chart with categories and a common numeric scale. Which situation most clearly calls for that approach?

  1. An executive needs one prominent value for the current quarter's net profit.
  2. Users need total revenue recalculated as slicers change, not a fixed value saved in each row.
  3. A company needs an interactive multipage collection of sales visuals with filters and drilldown over an analytical model.
  4. An operations manager wants to compare total incident counts among 15 department categories.

Explanation

Correct Answer

D:

This situation calls for Bar category comparison. Relative magnitudes across many labeled categories can be compared.

Incorrect Answers

A:

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.

B:

The other situation is better matched to Create a DAX measure for the revenue aggregation. The displayed calculation responds to the active filter context.

C:

The other situation is better matched to Create a Power BI report with the required report pages. Users can explore related visuals and filter the modeled data interactively.

Question 769

A report must compare quarterly total revenue and show how each business unit contributes to the total. Which data concept, Azure service, or design decision most directly satisfies the requirement?

  1. Use a stacked column chart broken down by business unit.
  2. Use a Power BI table visual.
  3. Create a suitable calculated column if row-level materialization is intended.
  4. Create a Power BI dashboard for the summary view.

Explanation

Correct Answer

A:

The requirement concerns Stacked composition. The total and its component contributions are displayed together.

Incorrect Answers

B:

That action instead addresses Table detail: Precise row and column values can be reviewed directly. It does not directly satisfy the described Stacked composition need.

C:

That action instead addresses Calculated column: Each model row receives a derived attribute according to the calculation. It does not directly satisfy the described Stacked composition need.

D:

That action instead addresses Power BI dashboard: Pinned tiles provide one consolidated monitoring canvas. It does not directly satisfy the described Stacked composition need.

Question 770

A data professional makes this decision: Use a stacked column chart broken down by business unit. Which outcome is the most direct expected result?

  1. Pinned tiles provide one consolidated monitoring canvas.
  2. The total and its component contributions are displayed together.
  3. Precise row and column values can be reviewed directly.
  4. Each model row receives a derived attribute according to the calculation.

Explanation

Correct Answer

B:

This is the expected outcome for Stacked composition: The total and its component contributions are displayed together.

Incorrect Answers

A:

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.

D:

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.