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 38

Question 370

Management wants to see monthly revenue trend over the last two years in chronological order. A team proposes: Use a line chart with Month on the time axis and Revenue as its measure. 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. The visual shows changes over time with correctly ordered monthly periods.
  3. The visual positions incidents at the intended stores rather than treating coordinates as sales values.
  4. The dashboard displays selected tiles from the source reports in one consolidated view.

Explanation

Correct Answer

B:

The visual shows changes over time with correctly ordered monthly periods. Line charts emphasize trends across ordered time periods. It is tied to this case: Management wants to see monthly revenue trend over the last two years in chronological order.

Incorrect Answers

A:

A year-and-month axis separates corresponding periods and aggregates sales consistently. This would validate a different scenario: A semantic model contains Date and Sales tables, but weekly totals differ when a report groups by text month names across years. The proposed change here is Use a line chart with Month on the time axis and Revenue as its measure. and its decisive acceptance check is The visual shows changes over time with correctly ordered monthly periods.

C:

The visual positions incidents at the intended stores rather than treating coordinates as sales values. This would validate a different scenario: A logistics team has store latitude and longitude and wants to inspect delivery incidents by location. The proposed change here is Use a line chart with Month on the time axis and Revenue as its measure. and its decisive acceptance check is The visual shows changes over time with correctly ordered monthly periods.

D:

The dashboard displays selected tiles from the source reports in one consolidated view. This would validate a different scenario: An analyst builds a multipage interactive Power BI report but the executive needs a single-page snapshot of several key report tiles. The proposed change here is Use a line chart with Month on the time axis and Revenue as its measure. and its decisive acceptance check is The visual shows changes over time with correctly ordered monthly periods.

Question 371

During an architecture review, the team proposes: Use a line chart with Month on the time axis and Revenue as its measure. The requirement is: Management wants to see monthly revenue trend over the last two years in chronological order. Which technical explanation BEST justifies this specific recommendation?

  1. A date dimension gives time analyses a consistent relational calendar context.
  2. Map visuals display measures or events using location context.
  3. Line charts emphasize trends across ordered time periods.
  4. A Power BI dashboard is a single-page canvas of pinned tiles in the service.

Explanation

Correct Answer

C:

Line charts emphasize trends across ordered time periods. Evidence would be: The visual shows changes over time with correctly ordered monthly periods. The choice avoids this risk: A pie chart is less suitable for showing many sequential time points.

Incorrect Answers

A:

A date dimension gives time analyses a consistent relational calendar context. That principle applies to the separate requirement: A semantic model contains Date and Sales tables, but weekly totals differ when a report groups by text month names across years. It may be true in that setting, but does not specifically explain why Use a line chart with Month on the time axis and Revenue as its measure. is the best fit here. The relevant reason is Line charts emphasize trends across ordered time periods.

B:

Map visuals display measures or events using location context. That principle applies to the separate requirement: A logistics team has store latitude and longitude and wants to inspect delivery incidents by location. It may be true in that setting, but does not specifically explain why Use a line chart with Month on the time axis and Revenue as its measure. is the best fit here. The relevant reason is Line charts emphasize trends across ordered time periods.

D:

A Power BI dashboard is a single-page canvas of pinned tiles in the service. That principle applies to the separate requirement: An analyst builds a multipage interactive Power BI report but the executive needs a single-page snapshot of several key report tiles. It may be true in that setting, but does not specifically explain why Use a line chart with Month on the time axis and Revenue as its measure. is the best fit here. The relevant reason is Line charts emphasize trends across ordered time periods.

Question 372

Management wants to see monthly revenue trend over the last two years in chronological order. If the team ignores the targeted approach (Use a line chart with Month on the time axis and Revenue as its measure.), which consequence or limitation MOST directly follows from leaving that requirement unaddressed?

  1. Grouping only by month name merges January across different years.
  2. A line chart over store IDs does not show geographic proximity.
  3. Publishing another multipage report is not the same as building a single dashboard canvas.
  4. A pie chart is less suitable for showing many sequential time points.

Explanation

Correct Answer

D:

A pie chart is less suitable for showing many sequential time points. This risk follows from the exact scenario: Management wants to see monthly revenue trend over the last two years in chronological order. The reason is line charts emphasize trends across ordered time periods. The direct mitigation is: Use a line chart with Month on the time axis and Revenue as its measure.

Incorrect Answers

A:

Grouping only by month name merges January across different years. This is a real potential problem in a different scenario: A semantic model contains Date and Sales tables, but weekly totals differ when a report groups by text month names across years. The present case instead concerns Management wants to see monthly revenue trend over the last two years in chronological order. With the targeted action omitted, the direct exposure is A pie chart is less suitable for showing many sequential time points.

B:

A line chart over store IDs does not show geographic proximity. This is a real potential problem in a different scenario: A logistics team has store latitude and longitude and wants to inspect delivery incidents by location. The present case instead concerns Management wants to see monthly revenue trend over the last two years in chronological order. With the targeted action omitted, the direct exposure is A pie chart is less suitable for showing many sequential time points.

C:

Publishing another multipage report is not the same as building a single dashboard canvas. This is a real potential problem in a different scenario: An analyst builds a multipage interactive Power BI report but the executive needs a single-page snapshot of several key report tiles. The present case instead concerns Management wants to see monthly revenue trend over the last two years in chronological order. With the targeted action omitted, the direct exposure is A pie chart is less suitable for showing many sequential time points.

Question 373

The finance team wants to compare the size of expense categories for one quarter without geographic information. Which solution or configuration choice MOST directly satisfies the stated requirement without changing unrelated behavior?

  1. Use a line chart with Month on the time axis and Revenue as its measure.
  2. Use a bar or column chart with category labels and the expense measure.
  3. Create an explicit DAX measure for NetRevenue in the Power BI semantic model.
  4. Pin appropriate report visuals to a Power BI dashboard in the service.

Explanation

Correct Answer

B:

Use a bar or column chart with category labels and the expense measure. This directly addresses the case: The finance team wants to compare the size of expense categories for one quarter without geographic information. The deciding technical reason is that bar and column charts support comparisons among discrete categories. Verify the solution by checking: Category amounts can be compared along a common quantitative axis.

Incorrect Answers

A:

Use a line chart with Month on the time axis and Revenue as its measure. This is a legitimate approach for a different problem: Management wants to see monthly revenue trend over the last two years in chronological order. Line charts emphasize trends across ordered time periods. It does not directly satisfy the present constraint: The finance team wants to compare the size of expense categories for one quarter without geographic information. The needed outcome is: Category amounts can be compared along a common quantitative axis.

C:

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: The finance team wants to compare the size of expense categories for one quarter without geographic information. The needed outcome is: Category amounts can be compared along a common quantitative axis.

D:

Pin appropriate report visuals to a Power BI dashboard in the service. This is a legitimate approach for a different problem: An analyst builds a multipage interactive Power BI report but the executive needs a single-page snapshot of several key report tiles. A Power BI dashboard is a single-page canvas of pinned tiles in the service. It does not directly satisfy the present constraint: The finance team wants to compare the size of expense categories for one quarter without geographic information. The needed outcome is: Category amounts can be compared along a common quantitative axis.

Question 374

The finance team wants to compare the size of expense categories for one quarter without geographic information. A team proposes: Use a bar or column chart with category labels and the expense measure. Which observation would BEST demonstrate that this exact requirement was met?

  1. The visual shows changes over time with correctly ordered monthly periods.
  2. The value recalculates when a viewer changes region or date filters.
  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

C:

Category amounts can be compared along a common quantitative axis. Bar and column charts support comparisons among discrete categories. It is tied to this case: The finance team wants to compare the size of expense categories for one quarter without geographic information.

Incorrect Answers

A:

The visual shows changes over time with correctly ordered monthly periods. This would validate a different scenario: Management wants to see monthly revenue trend over the last two years in chronological order. The proposed change here is Use a bar or column chart with category labels and the expense measure. and its decisive acceptance check is Category amounts can be compared along a common quantitative axis.

B:

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 Use a bar or column chart with category labels and the expense measure. and its decisive acceptance check is Category amounts can be compared along a common quantitative axis.

D:

The dashboard displays selected tiles from the source reports in one consolidated view. This would validate a different scenario: An analyst builds a multipage interactive Power BI report but the executive needs a single-page snapshot of several key report tiles. The proposed change here is Use a bar or column chart with category labels and the expense measure. and its decisive acceptance check is Category amounts can be compared along a common quantitative axis.

Question 375

During an architecture review, the team proposes: Use a bar or column chart with category labels and the expense measure. The requirement is: The finance team wants to compare the size of expense categories for one quarter without geographic information. Which technical explanation BEST justifies this specific recommendation?

  1. Line charts emphasize trends across ordered time periods.
  2. Power BI measures are evaluated dynamically in the model's filter context.
  3. A Power BI dashboard is a single-page canvas of pinned tiles in the service.
  4. Bar and column charts support comparisons among discrete categories.

Explanation

Correct Answer

D:

Bar and column charts support comparisons among discrete categories. Evidence would be: Category amounts can be compared along a common quantitative axis. The choice avoids this risk: A map requires meaningful geographic dimensions that the data does not have.

Incorrect Answers

A:

Line charts emphasize trends across ordered time periods. That principle applies to the separate requirement: Management wants to see monthly revenue trend over the last two years in chronological order. It may be true in that setting, but does not specifically explain why Use a bar or column chart with category labels and the expense measure. is the best fit here. The relevant reason is Bar and column charts support comparisons among discrete categories.

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 Use a bar or column chart with category labels and the expense measure. is the best fit here. The relevant reason is Bar and column charts support comparisons among discrete categories.

C:

A Power BI dashboard is a single-page canvas of pinned tiles in the service. That principle applies to the separate requirement: An analyst builds a multipage interactive Power BI report but the executive needs a single-page snapshot of several key report tiles. It may be true in that setting, but does not specifically explain why Use a bar or column chart with category labels and the expense measure. is the best fit here. The relevant reason is Bar and column charts support comparisons among discrete categories.

Question 376

The finance team wants to compare the size of expense categories for one quarter without geographic information. If the team ignores the targeted approach (Use a bar or column chart with category labels and the expense measure.), which consequence or limitation MOST directly follows from leaving that requirement unaddressed?

  1. A map requires meaningful geographic dimensions that the data does not have.
  2. A pie chart is less suitable for showing many sequential time points.
  3. A text box with a fixed total does not respond to model filter context.
  4. Publishing another multipage report is not the same as building a single dashboard canvas.

Explanation

Correct Answer

A:

A map requires meaningful geographic dimensions that the data does not have. This risk follows from the exact scenario: The finance team wants to compare the size of expense categories for one quarter without geographic information. The reason is bar and column charts support comparisons among discrete categories. The direct mitigation is: Use a bar or column chart with category labels and the expense measure.

Incorrect Answers

B:

A pie chart is less suitable for showing many sequential time points. This is a real potential problem in a different scenario: Management wants to see monthly revenue trend over the last two years in chronological order. The present case instead concerns The finance team wants to compare the size of expense categories for one quarter without geographic information. With the targeted action omitted, the direct exposure is A map requires meaningful geographic dimensions that the data does not have.

C:

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 finance team wants to compare the size of expense categories for one quarter without geographic information. With the targeted action omitted, the direct exposure is A map requires meaningful geographic dimensions that the data does not have.

D:

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

Question 377

A logistics team has store latitude and longitude and wants to inspect delivery incidents by location. Which solution or configuration choice MOST directly satisfies the stated requirement without changing unrelated behavior?

  1. Use a bar or column chart with category labels and the expense measure.
  2. Create an explicit DAX measure for NetRevenue in the Power BI semantic model.
  3. Use a map visual with authorized geographic fields and appropriate location quality checks.
  4. Model Sales as a fact table and Products as a related dimension table.

Explanation

Correct Answer

C:

Use a map visual with authorized geographic fields and appropriate location quality checks. This directly addresses the case: A logistics team has store latitude and longitude and wants to inspect delivery incidents by location. The deciding technical reason is that map visuals display measures or events using location context. Verify the solution by checking: The visual positions incidents at the intended stores rather than treating coordinates as sales values.

Incorrect Answers

A:

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 logistics team has store latitude and longitude and wants to inspect delivery incidents by location. The needed outcome is: The visual positions incidents at the intended stores rather than treating coordinates as sales values.

B:

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: A logistics team has store latitude and longitude and wants to inspect delivery incidents by location. The needed outcome is: The visual positions incidents at the intended stores rather than treating coordinates as sales values.

D:

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 logistics team has store latitude and longitude and wants to inspect delivery incidents by location. The needed outcome is: The visual positions incidents at the intended stores rather than treating coordinates as sales values.

Question 378

A logistics team has store latitude and longitude and wants to inspect delivery incidents by location. A team proposes: Use a map visual with authorized geographic fields and appropriate location quality checks. Which observation would BEST demonstrate that this exact requirement was met?

  1. Category amounts can be compared along a common quantitative axis.
  2. The value recalculates when a viewer changes region or date filters.
  3. Selecting a product category filters the intended sales measure through the relationship.
  4. The visual positions incidents at the intended stores rather than treating coordinates as sales values.

Explanation

Correct Answer

D:

The visual positions incidents at the intended stores rather than treating coordinates as sales values. Map visuals display measures or events using location context. It is tied to this case: A logistics team has store latitude and longitude and wants to inspect delivery incidents by location.

Incorrect Answers

A:

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 map visual with authorized geographic fields and appropriate location quality checks. and its decisive acceptance check is The visual positions incidents at the intended stores rather than treating coordinates as sales values.

B:

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 Use a map visual with authorized geographic fields and appropriate location quality checks. and its decisive acceptance check is The visual positions incidents at the intended stores rather than treating coordinates as sales values.

C:

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 map visual with authorized geographic fields and appropriate location quality checks. and its decisive acceptance check is The visual positions incidents at the intended stores rather than treating coordinates as sales values.

Question 379

During an architecture review, the team proposes: Use a map visual with authorized geographic fields and appropriate location quality checks. The requirement is: A logistics team has store latitude and longitude and wants to inspect delivery incidents by location. Which technical explanation BEST justifies this specific recommendation?

  1. Map visuals display measures or events using location context.
  2. Bar and column charts support comparisons among discrete categories.
  3. Power BI measures are evaluated dynamically in the model's filter context.
  4. A star schema relates fact tables to descriptive dimension tables.

Explanation

Correct Answer

A:

Map visuals display measures or events using location context. Evidence would be: The visual positions incidents at the intended stores rather than treating coordinates as sales values. The choice avoids this risk: A line chart over store IDs does not show geographic proximity.

Incorrect Answers

B:

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 map visual with authorized geographic fields and appropriate location quality checks. is the best fit here. The relevant reason is Map visuals display measures or events using location context.

C:

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 Use a map visual with authorized geographic fields and appropriate location quality checks. is the best fit here. The relevant reason is Map visuals display measures or events using location context.

D:

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 map visual with authorized geographic fields and appropriate location quality checks. is the best fit here. The relevant reason is Map visuals display measures or events using location context.

Question 380

A logistics team has store latitude and longitude and wants to inspect delivery incidents by location. If the team ignores the targeted approach (Use a map visual with authorized geographic fields and appropriate location quality checks.), which consequence or limitation MOST directly follows from leaving that requirement unaddressed?

  1. A map requires meaningful geographic dimensions that the data does not have.
  2. A line chart over store IDs does not show geographic proximity.
  3. A text box with a fixed total does not respond to model filter context.
  4. Duplicating product descriptions into every sales row can create inconsistent lookup values.

Explanation

Correct Answer

B:

A line chart over store IDs does not show geographic proximity. This risk follows from the exact scenario: A logistics team has store latitude and longitude and wants to inspect delivery incidents by location. The reason is map visuals display measures or events using location context. The direct mitigation is: Use a map visual with authorized geographic fields and appropriate location quality checks.

Incorrect Answers

A:

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 logistics team has store latitude and longitude and wants to inspect delivery incidents by location. With the targeted action omitted, the direct exposure is A line chart over store IDs does not show geographic proximity.

C:

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 A logistics team has store latitude and longitude and wants to inspect delivery incidents by location. With the targeted action omitted, the direct exposure is A line chart over store IDs does not show geographic proximity.

D:

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 logistics team has store latitude and longitude and wants to inspect delivery incidents by location. With the targeted action omitted, the direct exposure is A line chart over store IDs does not show geographic proximity.

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