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 78

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.

Question 771

A report must compare quarterly total revenue and show how each business unit contributes to the total. Someone instead proposes: Use a Power BI table visual. Which alternative is the best correction for the original requirement?

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

Explanation

Correct Answer

C:

This correction addresses Stacked composition. The total and its component contributions are displayed together.

Incorrect Answers

A:

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

B:

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 772

A data architect recommends this approach: Use a stacked column chart broken down by business unit. 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 finance analyst needs exact invoice numbers, customer names and amounts rather than graphical approximations.
  3. An executive wants single-page monitoring tiles pinned from multiple reports and datasets in the Power BI service.
  4. A report must compare quarterly total revenue and show how each business unit contributes to the total.

Explanation

Correct Answer

D:

This situation calls for Stacked composition. The total and its component contributions are displayed together.

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.

B:

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

C:

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

Question 773

An analyst wants to discover whether store advertising spend is associated with store revenue, one point per store. 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 Power BI matrix visual.
  3. Build a reusable Power BI semantic model.
  4. Use a scatter chart with spend and revenue on numeric axes.

Explanation

Correct Answer

D:

The requirement concerns Scatter relationship. The visual shows association, clusters and outliers across two measures.

Incorrect Answers

A:

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

B:

That action instead addresses Matrix hierarchy: Hierarchical rows and cross-tabulated values can be expanded and summarized. It does not directly satisfy the described Scatter relationship 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 Scatter relationship need.

Question 774

A data professional makes this decision: Use a scatter chart with spend and revenue on numeric axes. Which outcome is the most direct expected result?

  1. The visual shows association, clusters and outliers across two measures.
  2. Reports can consume a consistent data model and measures.
  3. Users can interactively limit report visuals to selected regions.
  4. Hierarchical rows and cross-tabulated values can be expanded and summarized.

Explanation

Correct Answer

A:

This is the expected outcome for Scatter relationship: The visual shows association, clusters and outliers across two measures.

Incorrect Answers

B:

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 Matrix hierarchy decision (Use a Power BI matrix visual.) rather than the specified design.

Question 775

An analyst wants to discover whether store advertising spend is associated with store revenue, one point per store. Someone instead proposes: Use a Power BI matrix visual. Which alternative is the best correction for the original 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. Use a Power BI matrix visual.
  4. Build a reusable Power BI semantic model.

Explanation

Correct Answer

B:

This correction addresses Scatter relationship. The visual shows association, clusters and outliers across two measures.

Incorrect Answers

A:

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

C:

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

D:

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

Question 776

A data architect recommends this approach: Use a scatter chart with spend and revenue on numeric axes. Which situation most clearly calls for that approach?

  1. Several reports must reuse shared relationships and business calculations instead of duplicating queries.
  2. A dashboard page needs a visible control that lets viewers select one or more regions and filter its charts.
  3. An analyst wants to discover whether store advertising spend is associated with store revenue, one point per store.
  4. A manager needs sales rows grouped by region and store with expandable subtotals and month columns.

Explanation

Correct Answer

C:

This situation calls for Scatter relationship. The visual shows association, clusters and outliers across two measures.

Incorrect Answers

A:

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

B:

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.

D:

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

Question 777

A regional company wants sales values displayed by geographic city locations across the country. Which data concept, Azure service, or design decision most directly satisfies the requirement?

  1. Create an appropriate many-to-one relationship from the sales fact to the product dimension.
  2. Use a line chart with time on the horizontal axis.
  3. Use a geographic map visual with a valid location field.
  4. Configure a date hierarchy with supported drill-down interactions.

Explanation

Correct Answer

C:

The requirement concerns Map by geography. Values can be interpreted in their spatial context.

Incorrect Answers

A:

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

B:

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 Map by geography 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 Map by geography need.

Question 778

A data professional makes this decision: Use a geographic map visual with a valid location field. Which outcome is the most direct expected result?

  1. Continuous time trends and changes across periods are easy to compare.
  2. Product attributes can filter and group the related sales facts.
  3. Users can inspect progressively finer time granularity from the same visual.
  4. Values can be interpreted in their spatial context.

Explanation

Correct Answer

D:

This is the expected outcome for Map by geography: Values can be interpreted in their spatial context.

Incorrect Answers

A:

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.

B:

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 Drilldown hierarchy decision (Configure a date hierarchy with supported drill-down interactions.) rather than the specified design.

Question 779

A regional company wants sales values displayed by geographic city locations across the country. Someone instead proposes: Configure a date hierarchy with supported drill-down interactions. Which alternative is the best correction for the original requirement?

  1. Use a geographic map visual with a valid location field.
  2. Use a line chart with time on the horizontal axis.
  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:

This correction addresses Map by geography. Values can be interpreted in their spatial context.

Incorrect Answers

B:

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

C:

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

D:

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

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.