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 74

Question 730

A data professional makes this decision: Create a Power BI report with the required report pages. 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. A clear fact-to-dimension design supports understandable analytical filtering.
  4. Relative magnitudes across many labeled categories can be compared.

Explanation

Correct Answer

A:

This is the expected outcome for Power BI report: Users can explore related visuals and filter the modeled data interactively.

Incorrect Answers

B:

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

C:

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.

D:

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.

Question 731

A company needs an interactive multipage collection of sales visuals with filters and drilldown over an analytical model. Someone instead proposes: Model the data as a star schema with facts and dimensions. Which alternative is the best correction for the original requirement?

  1. Model the data as a star schema with facts and dimensions.
  2. Create a Power BI report with the required report pages.
  3. Use a Power BI table visual.
  4. Use a bar chart with categories and a common numeric scale.

Explanation

Correct Answer

B:

This correction addresses Power BI report. Users can explore related visuals and filter the modeled data interactively.

Incorrect Answers

A:

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 Table detail, not the specific requirement. Precise row and column values can be reviewed directly.

D:

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

Question 732

A data architect recommends this approach: Create a Power BI report with the required report pages. Which situation most clearly calls for that approach?

  1. A finance analyst needs exact invoice numbers, customer names and amounts rather than graphical approximations.
  2. A warehouse report joins a central transaction table with date, store and product lookup tables.
  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

C:

This situation calls for Power BI report. Users can explore related visuals and filter the modeled data interactively.

Incorrect Answers

A:

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

B:

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.

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 733

An executive wants single-page monitoring tiles pinned from multiple reports and datasets in the Power BI service. Which data concept, Azure service, or design decision most directly satisfies the requirement?

  1. Create a Power BI dashboard for the summary view.
  2. Use a Power BI matrix visual.
  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 Power BI dashboard. Pinned tiles provide one consolidated monitoring canvas.

Incorrect Answers

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 Power BI dashboard need.

C:

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

D:

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

Question 734

A data professional makes this decision: Create a Power BI dashboard for the summary view. Which outcome is the most direct expected result?

  1. Hierarchical rows and cross-tabulated values can be expanded and summarized.
  2. Pinned tiles provide one consolidated monitoring canvas.
  3. The total and its component contributions are displayed together.
  4. The displayed calculation responds to the active filter context.

Explanation

Correct Answer

B:

This is the expected outcome for Power BI dashboard: Pinned tiles provide one consolidated monitoring canvas.

Incorrect Answers

A:

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

C:

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

D:

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

Question 735

An executive wants single-page monitoring tiles pinned from multiple reports and datasets in the Power BI service. Someone instead proposes: Create a DAX measure for the revenue aggregation. Which alternative is the best correction for the original requirement?

  1. Use a Power BI matrix visual.
  2. Create a DAX measure for the revenue aggregation.
  3. Create a Power BI dashboard for the summary view.
  4. Use a stacked column chart broken down by business unit.

Explanation

Correct Answer

C:

This correction addresses Power BI dashboard. Pinned tiles provide one consolidated monitoring canvas.

Incorrect Answers

A:

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

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 Stacked composition, not the specific requirement. The total and its component contributions are displayed together.

Question 736

A data architect recommends this approach: Create a Power BI dashboard for the summary view. 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 report must compare quarterly total revenue and show how each business unit contributes to the total.
  3. A manager needs sales rows grouped by region and store with expandable subtotals and month columns.
  4. An executive wants single-page monitoring tiles pinned from multiple reports and datasets in the Power BI service.

Explanation

Correct Answer

D:

This situation calls for Power BI dashboard. Pinned tiles provide one consolidated monitoring canvas.

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 Use a stacked column chart broken down by business unit. The total and its component contributions are displayed together.

C:

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 737

Several reports must reuse shared relationships and business calculations instead of duplicating queries. Which data concept, Azure service, or design decision most directly satisfies the requirement?

  1. Build a reusable Power BI semantic model.
  2. Create a suitable calculated column if row-level materialization is intended.
  3. Use a scatter chart with spend and revenue on numeric axes.
  4. Configure a date hierarchy with supported drill-down interactions.

Explanation

Correct Answer

A:

The requirement concerns Power BI semantic model. Reports can consume a consistent data model and measures.

Incorrect Answers

B:

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

C:

That action instead addresses Scatter relationship: The visual shows association, clusters and outliers across two measures. It does not directly satisfy the described Power BI semantic model 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 Power BI semantic model need.

Question 738

A data professional makes this decision: Build a reusable Power BI semantic model. Which outcome is the most direct expected result?

  1. Each model row receives a derived attribute according to the calculation.
  2. Reports can consume a consistent data model and measures.
  3. Users can inspect progressively finer time granularity from the same visual.
  4. The visual shows association, clusters and outliers across two measures.

Explanation

Correct Answer

B:

This is the expected outcome for Power BI semantic model: Reports can consume a consistent data model and measures.

Incorrect Answers

A:

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.

C:

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

D:

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.

Question 739

Several reports must reuse shared relationships and business calculations instead of duplicating queries. Someone instead proposes: Create a suitable calculated column if row-level materialization is intended. Which alternative is the best correction for the original requirement?

  1. Create a suitable calculated column if row-level materialization is intended.
  2. Configure a date hierarchy with supported drill-down interactions.
  3. Build a reusable Power BI semantic model.
  4. Use a scatter chart with spend and revenue on numeric axes.

Explanation

Correct Answer

C:

This correction addresses Power BI semantic model. Reports can consume a consistent data model and measures.

Incorrect Answers

A:

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

B:

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

D:

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

Question 740

A data architect recommends this approach: Build a reusable Power BI semantic model. 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 sales visual should navigate from annual totals to quarters and months by selecting a hierarchy level.
  3. An analyst wants to discover whether store advertising spend is associated with store revenue, one point per store.
  4. Several reports must reuse shared relationships and business calculations instead of duplicating queries.

Explanation

Correct Answer

D:

This situation calls for Power BI semantic model. Reports can consume a consistent data model and measures.

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 Configure a date hierarchy with supported drill-down interactions. Users can inspect progressively finer time granularity from the same visual.

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.