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 75

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.

Question 741

An analyst has a sales fact table and a product dimension containing one row per product. 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. Create an appropriate many-to-one relationship from the sales fact to the product dimension.
  3. Set an appropriate Power BI page-level filter.
  4. Use a geographic map visual with a valid location field.

Explanation

Correct Answer

B:

The requirement concerns Fact dimension relationship. Product attributes can filter and group the related sales facts.

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 Fact dimension relationship 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 Fact dimension relationship need.

D:

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

Question 742

A data professional makes this decision: Create an appropriate many-to-one relationship from the sales fact to the product dimension. Which outcome is the most direct expected result?

  1. All visuals on the target page respect the configured filter scope.
  2. Users can interactively limit report visuals to selected regions.
  3. Product attributes can filter and group the related sales facts.
  4. Values can be interpreted in their spatial context.

Explanation

Correct Answer

C:

This is the expected outcome for Fact dimension relationship: Product attributes can filter and group the related sales facts.

Incorrect Answers

A:

This result would follow the different Filter pane decision (Set an appropriate Power BI page-level filter.) rather than the specified design.

B:

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 743

An analyst has a sales fact table and a product dimension containing one row per product. Someone instead proposes: Add a Power BI slicer bound to the region field. Which alternative is the best correction for the original requirement?

  1. Use a geographic map visual with a valid location field.
  2. Add a Power BI slicer bound to the region field.
  3. Set an appropriate Power BI page-level filter.
  4. Create an appropriate many-to-one relationship from the sales fact to the product dimension.

Explanation

Correct Answer

D:

This correction addresses Fact dimension relationship. Product attributes can filter and group the related sales facts.

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 Slicer control, not the specific requirement. Users can interactively limit report visuals to selected regions.

C:

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

Question 744

A data architect recommends this approach: Create an appropriate many-to-one relationship from the sales fact to the product dimension. Which situation most clearly calls for that approach?

  1. An analyst has a sales fact table and a product dimension containing one row per product.
  2. A regional company wants sales values displayed by geographic city locations across the country.
  3. A dashboard page needs a visible control that lets viewers select one or more regions and filter its charts.
  4. A confidential management report should apply a persistent page-level filter across all page visuals for an approved business unit.

Explanation

Correct Answer

A:

This situation calls for Fact dimension relationship. Product attributes can filter and group the related sales facts.

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

Question 745

A warehouse report joins a central transaction table with date, store and product lookup tables. 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 card visual for the summarized measure.
  3. Use a line chart with time on the horizontal axis.
  4. Create a Power BI report with the required report pages.

Explanation

Correct Answer

A:

The requirement concerns Star schema. A clear fact-to-dimension design supports understandable analytical filtering.

Incorrect Answers

B:

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

C:

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 Star schema need.

D:

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 Star schema need.

Question 746

A data professional makes this decision: Model the data as a star schema with facts and dimensions. Which outcome is the most direct expected result?

  1. A single key figure is presented without unnecessary category axes.
  2. A clear fact-to-dimension design supports understandable analytical filtering.
  3. Users can explore related visuals and filter the modeled data interactively.
  4. Continuous time trends and changes across periods are easy to compare.

Explanation

Correct Answer

B:

This is the expected outcome for Star schema: A clear fact-to-dimension design supports understandable analytical filtering.

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.

C:

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.

D:

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.

Question 747

A warehouse report joins a central transaction table with date, store and product lookup tables. Someone instead proposes: Use a line chart with time on the horizontal axis. 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. Model the data as a star schema with facts and dimensions.
  4. Use a line chart with time on the horizontal axis.

Explanation

Correct Answer

C:

This correction addresses Star schema. A clear fact-to-dimension design supports understandable analytical filtering.

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 Line time trend, not the specific requirement. Continuous time trends and changes across periods are easy to compare.

Question 748

A data architect recommends this approach: Model the data as a star schema with facts and dimensions. Which situation most clearly calls for that approach?

  1. An executive needs one prominent value for the current quarter's net profit.
  2. A company needs an interactive multipage collection of sales visuals with filters and drilldown over an analytical model.
  3. Management needs to see how monthly customer subscriptions rose and fell over a two-year timeline.
  4. A warehouse report joins a central transaction table with date, store and product lookup tables.

Explanation

Correct Answer

D:

This situation calls for Star schema. A clear fact-to-dimension design supports understandable analytical filtering.

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 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 line chart with time on the horizontal axis. Continuous time trends and changes across periods are easy to compare.

Question 749

Users need total revenue recalculated as slicers change, not a fixed value saved in each row. 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 table visual.
  3. Create a DAX measure for the revenue aggregation.
  4. Use a bar chart with categories and a common numeric scale.

Explanation

Correct Answer

C:

The requirement concerns DAX measure. The displayed calculation responds to the active filter context.

Incorrect Answers

A:

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

B:

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

D:

That action instead addresses Bar category comparison: Relative magnitudes across many labeled categories can be compared. It does not directly satisfy the described DAX measure need.

Question 750

A data professional makes this decision: Create a DAX measure for the revenue aggregation. Which outcome is the most direct expected result?

  1. Relative magnitudes across many labeled categories can be compared.
  2. Pinned tiles provide one consolidated monitoring canvas.
  3. Precise row and column values can be reviewed directly.
  4. The displayed calculation responds to the active filter context.

Explanation

Correct Answer

D:

This is the expected outcome for DAX measure: The displayed calculation responds to the active filter context.

Incorrect Answers

A:

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.

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 Table detail decision (Use a Power BI table visual.) rather than the specified design.