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 79

Question 780

A data architect recommends this approach: Use a geographic map visual with a valid location field. 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. An analyst has a sales fact table and a product dimension containing one row per product.
  4. A sales visual should navigate from annual totals to quarters and months by selecting a hierarchy level.

Explanation

Correct Answer

B:

This situation calls for Map by geography. Values can be interpreted in their spatial context.

Incorrect Answers

A:

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.

C:

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.

D:

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.

Question 781

An executive needs one prominent value for the current quarter's net profit. Which data concept, Azure service, or design decision most directly satisfies the requirement?

  1. Model the data as a star schema with facts and dimensions.
  2. Use a bar chart with categories and a common numeric scale.
  3. Set an appropriate Power BI page-level filter.
  4. Use a card visual for the summarized measure.

Explanation

Correct Answer

D:

The requirement concerns Card KPI. A single key figure is presented without unnecessary category axes.

Incorrect Answers

A:

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

B:

That action instead addresses Bar category comparison: Relative magnitudes across many labeled categories can be compared. It does not directly satisfy the described Card KPI 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 Card KPI need.

Question 782

A data professional makes this decision: Use a card visual for the summarized measure. Which outcome is the most direct expected result?

  1. A single key figure is presented without unnecessary category axes.
  2. Relative magnitudes across many labeled categories can be compared.
  3. All visuals on the target page respect the configured filter scope.
  4. A clear fact-to-dimension design supports understandable analytical filtering.

Explanation

Correct Answer

A:

This is the expected outcome for Card KPI: A single key figure is presented without unnecessary category axes.

Incorrect Answers

B:

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.

C:

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 Star schema decision (Model the data as a star schema with facts and dimensions.) rather than the specified design.

Question 783

An executive needs one prominent value for the current quarter's net profit. Someone instead proposes: Set an appropriate Power BI page-level filter. Which alternative is the best correction for the original requirement?

  1. Set an appropriate Power BI page-level filter.
  2. Use a card visual for the summarized measure.
  3. Model the data as a star schema with facts and dimensions.
  4. Use a bar chart with categories and a common numeric scale.

Explanation

Correct Answer

B:

This correction addresses Card KPI. A single key figure is presented without unnecessary category axes.

Incorrect Answers

A:

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

C:

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

D:

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

Question 784

A data architect recommends this approach: Use a card visual for the summarized measure. Which situation most clearly calls for that approach?

  1. A warehouse report joins a central transaction table with date, store and product lookup tables.
  2. An operations manager wants to compare total incident counts among 15 department categories.
  3. An executive needs one prominent value for the current quarter's net profit.
  4. A confidential management report should apply a persistent page-level filter across all page visuals for an approved business unit.

Explanation

Correct Answer

C:

This situation calls for Card KPI. A single key figure is presented without unnecessary category axes.

Incorrect Answers

A:

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.

B:

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.

D:

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.

Question 785

A finance analyst needs exact invoice numbers, customer names and amounts rather than graphical approximations. Which data concept, Azure service, or design decision most directly satisfies the requirement?

  1. Use a Power BI table visual.
  2. Create a Power BI report with the required report pages.
  3. Use a stacked column chart broken down by business unit.
  4. Create a DAX measure for the revenue aggregation.

Explanation

Correct Answer

A:

The requirement concerns Table detail. Precise row and column values can be reviewed directly.

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 Table detail need.

C:

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

D:

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

Question 786

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

  1. Users can explore related visuals and filter the modeled data interactively.
  2. Precise row and column values can be reviewed directly.
  3. The displayed calculation responds to the active filter context.
  4. The total and its component contributions are displayed together.

Explanation

Correct Answer

B:

This is the expected outcome for Table detail: Precise row and column values can be reviewed directly.

Incorrect Answers

A:

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.

C:

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

D:

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

Question 787

A finance analyst needs exact invoice numbers, customer names and amounts rather than graphical approximations. Someone instead proposes: Create a Power BI report with the required report pages. Which alternative is the best correction for the original requirement?

  1. Use a stacked column chart broken down by business unit.
  2. Create a DAX measure for the revenue aggregation.
  3. Use a Power BI table visual.
  4. Create a Power BI report with the required report pages.

Explanation

Correct Answer

C:

This correction addresses Table detail. Precise row and column values can be reviewed directly.

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 DAX measure, not the specific requirement. The displayed calculation responds to the active filter context.

D:

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

Question 788

A data architect recommends this approach: Use a Power BI table visual. Which situation most clearly calls for that approach?

  1. Users need total revenue recalculated as slicers change, not a fixed value saved in each row.
  2. A company needs an interactive multipage collection of sales visuals with filters and drilldown over an analytical model.
  3. A report must compare quarterly total revenue and show how each business unit contributes to the total.
  4. A finance analyst needs exact invoice numbers, customer names and amounts rather than graphical approximations.

Explanation

Correct Answer

D:

This situation calls for Table detail. Precise row and column values can be reviewed directly.

Incorrect Answers

A:

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

B:

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.

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.

Question 789

A manager needs sales rows grouped by region and store with expandable subtotals and month columns. Which data concept, Azure service, or design decision most directly satisfies the requirement?

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

Explanation

Correct Answer

C:

The requirement concerns Matrix hierarchy. Hierarchical rows and cross-tabulated values can be expanded and summarized.

Incorrect Answers

A:

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

B:

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

D:

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

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.