Pass Microsoft Azure Data DP-900 Exam in First Attempt Easily
Real Microsoft Azure Data DP-900 Exam Questions, Accurate & Verified Answers As Experienced in the Actual Test!

Verified by experts
3 products

You save $69.98

DP-900 Premium Bundle

  • Premium File 332 Questions & Answers
  • Last Update: Nov 14, 2026
  • Training Course 32 Lectures
  • Study Guide 672 Pages
$79.99 $149.97

Purchase Individually

  • Premium File

    332 Questions & Answers
    Last Update: Nov 14, 2026

    $76.99
    $69.99
  • Training Course

    32 Lectures

    $43.99
    $39.99
  • Study Guide

    672 Pages

    $43.99
    $39.99

Microsoft Azure Data Fundamentals DP-900 Practice Test 40

Question 390

The model has one-row-per-customer Customers and many Sales rows but filters do not flow from selected customer attributes. A team proposes: Create a valid one-to-many relationship between Customers and Sales on the appropriate key. Which observation would BEST demonstrate that this exact requirement was met?

  1. The value recalculates when a viewer changes region or date filters.
  2. Changing the selected region updates the targeted report visuals.
  3. Filtering a customer dimension limits sales calculations to matching fact rows.
  4. Category amounts can be compared along a common quantitative axis.

Explanation

Correct Answer

C:

Filtering a customer dimension limits sales calculations to matching fact rows. Power BI relationships propagate filters along defined model paths. It is tied to this case: The model has one-row-per-customer Customers and many Sales rows but filters do not flow from selected customer attributes.

Incorrect Answers

A:

The value recalculates when a viewer changes region or date filters. This would validate a different scenario: A sales report needs a reusable NetRevenue calculation that respects the report's filter selections. The proposed change here is Create a valid one-to-many relationship between Customers and Sales on the appropriate key. and its decisive acceptance check is Filtering a customer dimension limits sales calculations to matching fact rows.

B:

Changing the selected region updates the targeted report visuals. This would validate a different scenario: A report viewer needs a visible on-page control to filter all relevant charts to one region. The proposed change here is Create a valid one-to-many relationship between Customers and Sales on the appropriate key. and its decisive acceptance check is Filtering a customer dimension limits sales calculations to matching fact rows.

D:

Category amounts can be compared along a common quantitative axis. This would validate a different scenario: The finance team wants to compare the size of expense categories for one quarter without geographic information. The proposed change here is Create a valid one-to-many relationship between Customers and Sales on the appropriate key. and its decisive acceptance check is Filtering a customer dimension limits sales calculations to matching fact rows.

Question 391

During an architecture review, the team proposes: Create a valid one-to-many relationship between Customers and Sales on the appropriate key. The requirement is: The model has one-row-per-customer Customers and many Sales rows but filters do not flow from selected customer attributes. Which technical explanation BEST justifies this specific recommendation?

  1. Power BI measures are evaluated dynamically in the model's filter context.
  2. Slicers are interactive report filters for selected fields.
  3. Bar and column charts support comparisons among discrete categories.
  4. Power BI relationships propagate filters along defined model paths.

Explanation

Correct Answer

D:

Power BI relationships propagate filters along defined model paths. Evidence would be: Filtering a customer dimension limits sales calculations to matching fact rows. The choice avoids this risk: Joining tables only by their display titles may not give a stable relationship key.

Incorrect Answers

A:

Power BI measures are evaluated dynamically in the model's filter context. That principle applies to the separate requirement: A sales report needs a reusable NetRevenue calculation that respects the report's filter selections. It may be true in that setting, but does not specifically explain why Create a valid one-to-many relationship between Customers and Sales on the appropriate key. is the best fit here. The relevant reason is Power BI relationships propagate filters along defined model paths.

B:

Slicers are interactive report filters for selected fields. That principle applies to the separate requirement: A report viewer needs a visible on-page control to filter all relevant charts to one region. It may be true in that setting, but does not specifically explain why Create a valid one-to-many relationship between Customers and Sales on the appropriate key. is the best fit here. The relevant reason is Power BI relationships propagate filters along defined model paths.

C:

Bar and column charts support comparisons among discrete categories. That principle applies to the separate requirement: The finance team wants to compare the size of expense categories for one quarter without geographic information. It may be true in that setting, but does not specifically explain why Create a valid one-to-many relationship between Customers and Sales on the appropriate key. is the best fit here. The relevant reason is Power BI relationships propagate filters along defined model paths.

Question 392

The model has one-row-per-customer Customers and many Sales rows but filters do not flow from selected customer attributes. If the team ignores the targeted approach (Create a valid one-to-many relationship between Customers and Sales on the appropriate key.), which consequence or limitation MOST directly follows from leaving that requirement unaddressed?

  1. Joining tables only by their display titles may not give a stable relationship key.
  2. A text box with a fixed total does not respond to model filter context.
  3. A static text label will not propagate filtering to report data.
  4. A map requires meaningful geographic dimensions that the data does not have.

Explanation

Correct Answer

A:

Joining tables only by their display titles may not give a stable relationship key. This risk follows from the exact scenario: The model has one-row-per-customer Customers and many Sales rows but filters do not flow from selected customer attributes. The reason is power BI relationships propagate filters along defined model paths. The direct mitigation is: Create a valid one-to-many relationship between Customers and Sales on the appropriate key.

Incorrect Answers

B:

A text box with a fixed total does not respond to model filter context. This is a real potential problem in a different scenario: A sales report needs a reusable NetRevenue calculation that respects the report's filter selections. The present case instead concerns The model has one-row-per-customer Customers and many Sales rows but filters do not flow from selected customer attributes. With the targeted action omitted, the direct exposure is Joining tables only by their display titles may not give a stable relationship key.

C:

A static text label will not propagate filtering to report data. This is a real potential problem in a different scenario: A report viewer needs a visible on-page control to filter all relevant charts to one region. The present case instead concerns The model has one-row-per-customer Customers and many Sales rows but filters do not flow from selected customer attributes. With the targeted action omitted, the direct exposure is Joining tables only by their display titles may not give a stable relationship key.

D:

A map requires meaningful geographic dimensions that the data does not have. This is a real potential problem in a different scenario: The finance team wants to compare the size of expense categories for one quarter without geographic information. The present case instead concerns The model has one-row-per-customer Customers and many Sales rows but filters do not flow from selected customer attributes. With the targeted action omitted, the direct exposure is Joining tables only by their display titles may not give a stable relationship key.

Question 393

An analyst builds a multipage interactive Power BI report but the executive needs a single-page snapshot of several key report tiles. Which solution or configuration choice MOST directly satisfies the stated requirement without changing unrelated behavior?

  1. Create an explicit DAX measure for NetRevenue in the Power BI semantic model.
  2. Model Sales as a fact table and Products as a related dimension table.
  3. Pin appropriate report visuals to a Power BI dashboard in the service.
  4. Use a bar or column chart with category labels and the expense measure.

Explanation

Correct Answer

C:

Pin appropriate report visuals to a Power BI dashboard in the service. This directly addresses the case: An analyst builds a multipage interactive Power BI report but the executive needs a single-page snapshot of several key report tiles. The deciding technical reason is that a Power BI dashboard is a single-page canvas of pinned tiles in the service. Verify the solution by checking: The dashboard displays selected tiles from the source reports in one consolidated view.

Incorrect Answers

A:

Create an explicit DAX measure for NetRevenue in the Power BI semantic model. This is a legitimate approach for a different problem: A sales report needs a reusable NetRevenue calculation that respects the report's filter selections. Power BI measures are evaluated dynamically in the model's filter context. It does not directly satisfy the present constraint: An analyst builds a multipage interactive Power BI report but the executive needs a single-page snapshot of several key report tiles. The needed outcome is: The dashboard displays selected tiles from the source reports in one consolidated view.

B:

Model Sales as a fact table and Products as a related dimension table. This is a legitimate approach for a different problem: A Power BI model has Sales rows connected to a Products lookup and analysts need product attributes to filter totals. A star schema relates fact tables to descriptive dimension tables. It does not directly satisfy the present constraint: An analyst builds a multipage interactive Power BI report but the executive needs a single-page snapshot of several key report tiles. The needed outcome is: The dashboard displays selected tiles from the source reports in one consolidated view.

D:

Use a bar or column chart with category labels and the expense measure. This is a legitimate approach for a different problem: The finance team wants to compare the size of expense categories for one quarter without geographic information. Bar and column charts support comparisons among discrete categories. It does not directly satisfy the present constraint: An analyst builds a multipage interactive Power BI report but the executive needs a single-page snapshot of several key report tiles. The needed outcome is: The dashboard displays selected tiles from the source reports in one consolidated view.

Question 394

An analyst builds a multipage interactive Power BI report but the executive needs a single-page snapshot of several key report tiles. A team proposes: Pin appropriate report visuals to a Power BI dashboard in the service. Which observation would BEST demonstrate that this exact requirement was met?

  1. The value recalculates when a viewer changes region or date filters.
  2. Selecting a product category filters the intended sales measure through the relationship.
  3. Category amounts can be compared along a common quantitative axis.
  4. The dashboard displays selected tiles from the source reports in one consolidated view.

Explanation

Correct Answer

D:

The dashboard displays selected tiles from the source reports in one consolidated view. A Power BI dashboard is a single-page canvas of pinned tiles in the service. It is tied to this case: An analyst builds a multipage interactive Power BI report but the executive needs a single-page snapshot of several key report tiles.

Incorrect Answers

A:

The value recalculates when a viewer changes region or date filters. This would validate a different scenario: A sales report needs a reusable NetRevenue calculation that respects the report's filter selections. The proposed change here is Pin appropriate report visuals to a Power BI dashboard in the service. and its decisive acceptance check is The dashboard displays selected tiles from the source reports in one consolidated view.

B:

Selecting a product category filters the intended sales measure through the relationship. This would validate a different scenario: A Power BI model has Sales rows connected to a Products lookup and analysts need product attributes to filter totals. The proposed change here is Pin appropriate report visuals to a Power BI dashboard in the service. and its decisive acceptance check is The dashboard displays selected tiles from the source reports in one consolidated view.

C:

Category amounts can be compared along a common quantitative axis. This would validate a different scenario: The finance team wants to compare the size of expense categories for one quarter without geographic information. The proposed change here is Pin appropriate report visuals to a Power BI dashboard in the service. and its decisive acceptance check is The dashboard displays selected tiles from the source reports in one consolidated view.

Question 395

During an architecture review, the team proposes: Pin appropriate report visuals to a Power BI dashboard in the service. The requirement is: An analyst builds a multipage interactive Power BI report but the executive needs a single-page snapshot of several key report tiles. Which technical explanation BEST justifies this specific recommendation?

  1. A Power BI dashboard is a single-page canvas of pinned tiles in the service.
  2. Power BI measures are evaluated dynamically in the model's filter context.
  3. A star schema relates fact tables to descriptive dimension tables.
  4. Bar and column charts support comparisons among discrete categories.

Explanation

Correct Answer

A:

A Power BI dashboard is a single-page canvas of pinned tiles in the service. Evidence would be: The dashboard displays selected tiles from the source reports in one consolidated view. The choice avoids this risk: Publishing another multipage report is not the same as building a single dashboard canvas.

Incorrect Answers

B:

Power BI measures are evaluated dynamically in the model's filter context. That principle applies to the separate requirement: A sales report needs a reusable NetRevenue calculation that respects the report's filter selections. It may be true in that setting, but does not specifically explain why Pin appropriate report visuals to a Power BI dashboard in the service. is the best fit here. The relevant reason is A Power BI dashboard is a single-page canvas of pinned tiles in the service.

C:

A star schema relates fact tables to descriptive dimension tables. That principle applies to the separate requirement: A Power BI model has Sales rows connected to a Products lookup and analysts need product attributes to filter totals. It may be true in that setting, but does not specifically explain why Pin appropriate report visuals to a Power BI dashboard in the service. is the best fit here. The relevant reason is A Power BI dashboard is a single-page canvas of pinned tiles in the service.

D:

Bar and column charts support comparisons among discrete categories. That principle applies to the separate requirement: The finance team wants to compare the size of expense categories for one quarter without geographic information. It may be true in that setting, but does not specifically explain why Pin appropriate report visuals to a Power BI dashboard in the service. is the best fit here. The relevant reason is A Power BI dashboard is a single-page canvas of pinned tiles in the service.

Question 396

An analyst builds a multipage interactive Power BI report but the executive needs a single-page snapshot of several key report tiles. If the team ignores the targeted approach (Pin appropriate report visuals to a Power BI dashboard in the service.), which consequence or limitation MOST directly follows from leaving that requirement unaddressed?

  1. A text box with a fixed total does not respond to model filter context.
  2. Publishing another multipage report is not the same as building a single dashboard canvas.
  3. Duplicating product descriptions into every sales row can create inconsistent lookup values.
  4. A map requires meaningful geographic dimensions that the data does not have.

Explanation

Correct Answer

B:

Publishing another multipage report is not the same as building a single dashboard canvas. This risk follows from the exact scenario: An analyst builds a multipage interactive Power BI report but the executive needs a single-page snapshot of several key report tiles. The reason is a Power BI dashboard is a single-page canvas of pinned tiles in the service. The direct mitigation is: Pin appropriate report visuals to a Power BI dashboard in the service.

Incorrect Answers

A:

A text box with a fixed total does not respond to model filter context. This is a real potential problem in a different scenario: A sales report needs a reusable NetRevenue calculation that respects the report's filter selections. The present case instead concerns An analyst builds a multipage interactive Power BI report but the executive needs a single-page snapshot of several key report tiles. With the targeted action omitted, the direct exposure is Publishing another multipage report is not the same as building a single dashboard canvas.

C:

Duplicating product descriptions into every sales row can create inconsistent lookup values. This is a real potential problem in a different scenario: A Power BI model has Sales rows connected to a Products lookup and analysts need product attributes to filter totals. The present case instead concerns An analyst builds a multipage interactive Power BI report but the executive needs a single-page snapshot of several key report tiles. With the targeted action omitted, the direct exposure is Publishing another multipage report is not the same as building a single dashboard canvas.

D:

A map requires meaningful geographic dimensions that the data does not have. This is a real potential problem in a different scenario: The finance team wants to compare the size of expense categories for one quarter without geographic information. The present case instead concerns An analyst builds a multipage interactive Power BI report but the executive needs a single-page snapshot of several key report tiles. With the targeted action omitted, the direct exposure is Publishing another multipage report is not the same as building a single dashboard canvas.

Question 397

A semantic model contains Date and Sales tables, but weekly totals differ when a report groups by text month names across years. Which solution or configuration choice MOST directly satisfies the stated requirement without changing unrelated behavior?

  1. Model Sales as a fact table and Products as a related dimension table.
  2. Create a valid one-to-many relationship between Customers and Sales on the appropriate key.
  3. Use a bar or column chart with category labels and the expense measure.
  4. Use a proper Date dimension and model relationship for time-based grouping.

Explanation

Correct Answer

D:

Use a proper Date dimension and model relationship for time-based grouping. This directly addresses the case: A semantic model contains Date and Sales tables, but weekly totals differ when a report groups by text month names across years. The deciding technical reason is that a date dimension gives time analyses a consistent relational calendar context. Verify the solution by checking: A year-and-month axis separates corresponding periods and aggregates sales consistently.

Incorrect Answers

A:

Model Sales as a fact table and Products as a related dimension table. This is a legitimate approach for a different problem: A Power BI model has Sales rows connected to a Products lookup and analysts need product attributes to filter totals. A star schema relates fact tables to descriptive dimension tables. It does not directly satisfy the present constraint: A semantic model contains Date and Sales tables, but weekly totals differ when a report groups by text month names across years. The needed outcome is: A year-and-month axis separates corresponding periods and aggregates sales consistently.

B:

Create a valid one-to-many relationship between Customers and Sales on the appropriate key. This is a legitimate approach for a different problem: The model has one-row-per-customer Customers and many Sales rows but filters do not flow from selected customer attributes. Power BI relationships propagate filters along defined model paths. It does not directly satisfy the present constraint: A semantic model contains Date and Sales tables, but weekly totals differ when a report groups by text month names across years. The needed outcome is: A year-and-month axis separates corresponding periods and aggregates sales consistently.

C:

Use a bar or column chart with category labels and the expense measure. This is a legitimate approach for a different problem: The finance team wants to compare the size of expense categories for one quarter without geographic information. Bar and column charts support comparisons among discrete categories. It does not directly satisfy the present constraint: A semantic model contains Date and Sales tables, but weekly totals differ when a report groups by text month names across years. The needed outcome is: A year-and-month axis separates corresponding periods and aggregates sales consistently.

Question 398

A semantic model contains Date and Sales tables, but weekly totals differ when a report groups by text month names across years. A team proposes: Use a proper Date dimension and model relationship for time-based grouping. Which observation would BEST demonstrate that this exact requirement was met?

  1. A year-and-month axis separates corresponding periods and aggregates sales consistently.
  2. Selecting a product category filters the intended sales measure through the relationship.
  3. Filtering a customer dimension limits sales calculations to matching fact rows.
  4. Category amounts can be compared along a common quantitative axis.

Explanation

Correct Answer

A:

A year-and-month axis separates corresponding periods and aggregates sales consistently. A date dimension gives time analyses a consistent relational calendar context. It is tied to this case: A semantic model contains Date and Sales tables, but weekly totals differ when a report groups by text month names across years.

Incorrect Answers

B:

Selecting a product category filters the intended sales measure through the relationship. This would validate a different scenario: A Power BI model has Sales rows connected to a Products lookup and analysts need product attributes to filter totals. The proposed change here is Use a proper Date dimension and model relationship for time-based grouping. and its decisive acceptance check is A year-and-month axis separates corresponding periods and aggregates sales consistently.

C:

Filtering a customer dimension limits sales calculations to matching fact rows. This would validate a different scenario: The model has one-row-per-customer Customers and many Sales rows but filters do not flow from selected customer attributes. The proposed change here is Use a proper Date dimension and model relationship for time-based grouping. and its decisive acceptance check is A year-and-month axis separates corresponding periods and aggregates sales consistently.

D:

Category amounts can be compared along a common quantitative axis. This would validate a different scenario: The finance team wants to compare the size of expense categories for one quarter without geographic information. The proposed change here is Use a proper Date dimension and model relationship for time-based grouping. and its decisive acceptance check is A year-and-month axis separates corresponding periods and aggregates sales consistently.

Question 399

During an architecture review, the team proposes: Use a proper Date dimension and model relationship for time-based grouping. The requirement is: A semantic model contains Date and Sales tables, but weekly totals differ when a report groups by text month names across years. Which technical explanation BEST justifies this specific recommendation?

  1. A star schema relates fact tables to descriptive dimension tables.
  2. A date dimension gives time analyses a consistent relational calendar context.
  3. Power BI relationships propagate filters along defined model paths.
  4. Bar and column charts support comparisons among discrete categories.

Explanation

Correct Answer

B:

A date dimension gives time analyses a consistent relational calendar context. Evidence would be: A year-and-month axis separates corresponding periods and aggregates sales consistently. The choice avoids this risk: Grouping only by month name merges January across different years.

Incorrect Answers

A:

A star schema relates fact tables to descriptive dimension tables. That principle applies to the separate requirement: A Power BI model has Sales rows connected to a Products lookup and analysts need product attributes to filter totals. It may be true in that setting, but does not specifically explain why Use a proper Date dimension and model relationship for time-based grouping. is the best fit here. The relevant reason is A date dimension gives time analyses a consistent relational calendar context.

C:

Power BI relationships propagate filters along defined model paths. That principle applies to the separate requirement: The model has one-row-per-customer Customers and many Sales rows but filters do not flow from selected customer attributes. It may be true in that setting, but does not specifically explain why Use a proper Date dimension and model relationship for time-based grouping. is the best fit here. The relevant reason is A date dimension gives time analyses a consistent relational calendar context.

D:

Bar and column charts support comparisons among discrete categories. That principle applies to the separate requirement: The finance team wants to compare the size of expense categories for one quarter without geographic information. It may be true in that setting, but does not specifically explain why Use a proper Date dimension and model relationship for time-based grouping. is the best fit here. The relevant reason is A date dimension gives time analyses a consistent relational calendar context.

Question 400

A semantic model contains Date and Sales tables, but weekly totals differ when a report groups by text month names across years. If the team ignores the targeted approach (Use a proper Date dimension and model relationship for time-based grouping.), which consequence or limitation MOST directly follows from leaving that requirement unaddressed?

  1. Duplicating product descriptions into every sales row can create inconsistent lookup values.
  2. Joining tables only by their display titles may not give a stable relationship key.
  3. Grouping only by month name merges January across different years.
  4. A map requires meaningful geographic dimensions that the data does not have.

Explanation

Correct Answer

C:

Grouping only by month name merges January across different years. This risk follows from the exact scenario: A semantic model contains Date and Sales tables, but weekly totals differ when a report groups by text month names across years. The reason is a date dimension gives time analyses a consistent relational calendar context. The direct mitigation is: Use a proper Date dimension and model relationship for time-based grouping.

Incorrect Answers

A:

Duplicating product descriptions into every sales row can create inconsistent lookup values. This is a real potential problem in a different scenario: A Power BI model has Sales rows connected to a Products lookup and analysts need product attributes to filter totals. The present case instead concerns A semantic model contains Date and Sales tables, but weekly totals differ when a report groups by text month names across years. With the targeted action omitted, the direct exposure is Grouping only by month name merges January across different years.

B:

Joining tables only by their display titles may not give a stable relationship key. This is a real potential problem in a different scenario: The model has one-row-per-customer Customers and many Sales rows but filters do not flow from selected customer attributes. The present case instead concerns A semantic model contains Date and Sales tables, but weekly totals differ when a report groups by text month names across years. With the targeted action omitted, the direct exposure is Grouping only by month name merges January across different years.

D:

A map requires meaningful geographic dimensions that the data does not have. This is a real potential problem in a different scenario: The finance team wants to compare the size of expense categories for one quarter without geographic information. The present case instead concerns A semantic model contains Date and Sales tables, but weekly totals differ when a report groups by text month names across years. With the targeted action omitted, the direct exposure is Grouping only by month name merges January across different years.

Microsoft Azure Data Fundamentals (DP-900) Practice Tests

Purchase Individually

  • Premium File

    332 Questions & Answers
    Last Update: Nov 14, 2026

    $76.99
    $69.99
  • Training Course

    32 Lectures

    $43.99
    $39.99
  • Study Guide

    672 Pages

    $43.99
    $39.99

SPECIAL OFFER: GET 10% OFF
This is ONE TIME OFFER

You save
10%

Enter Your Email Address to Receive Your 10% Off Discount Code

SPECIAL OFFER: GET 10% OFF

You save
10%

Use Discount Code:

A confirmation link was sent to your e-mail.

Please check your mailbox for a message from support@examlabs.com and follow the directions.

Download Free Demo of VCE Exam Simulator

Experience Avanset VCE Exam Simulator for yourself.

Simply submit your email address below to get started with our interactive software demo of your free trial.

  • Realistic exam simulation and exam editor with preview functions
  • Whole exam in a single file with several different question types
  • Customizable exam-taking mode & detailed score reports