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 37

Question 360

A mobile service has duplicate event delivery and must avoid double-counting business activities in streaming aggregates. If the team ignores the targeted approach (Apply suitable event-identity handling and deduplication logic in the stream processing design.), which consequence or limitation MOST directly follows from leaving that requirement unaddressed?

  1. Assuming each received notification is a unique business action can inflate metrics.
  2. Grouping a single daily CSV export does not produce continuously updating windows.
  3. A static Power BI slicer is not an ingestion pipeline for continuous device messages.
  4. A one-time static screenshot does not provide an updating operational view.

Explanation

Correct Answer

A:

Assuming each received notification is a unique business action can inflate metrics. This risk follows from the exact scenario: A mobile service has duplicate event delivery and must avoid double-counting business activities in streaming aggregates. The reason is streaming systems require explicit handling for duplicate deliveries and event identity. The direct mitigation is: Apply suitable event-identity handling and deduplication logic in the stream processing design.

Incorrect Answers

B:

Grouping a single daily CSV export does not produce continuously updating windows. This is a real potential problem in a different scenario: A data engineer needs to count checkout failures over sliding windows of a continuously arriving event stream. The present case instead concerns A mobile service has duplicate event delivery and must avoid double-counting business activities in streaming aggregates. With the targeted action omitted, the direct exposure is Assuming each received notification is a unique business action can inflate metrics.

C:

A static Power BI slicer is not an ingestion pipeline for continuous device messages. This is a real potential problem in a different scenario: An IoT team needs a no-code path to bring a supported event source into Fabric with light event transformations. The present case instead concerns A mobile service has duplicate event delivery and must avoid double-counting business activities in streaming aggregates. With the targeted action omitted, the direct exposure is Assuming each received notification is a unique business action can inflate metrics.

D:

A one-time static screenshot does not provide an updating operational view. This is a real potential problem in a different scenario: A technician wants dashboards that refresh against continuously arriving security telemetry. The present case instead concerns A mobile service has duplicate event delivery and must avoid double-counting business activities in streaming aggregates. With the targeted action omitted, the direct exposure is Assuming each received notification is a unique business action can inflate metrics.

Question 361

A Power BI model has Sales rows connected to a Products lookup and analysts need product attributes to filter totals. Which solution or configuration choice MOST directly satisfies the stated requirement without changing unrelated behavior?

  1. Use a proper Date dimension and model relationship for time-based grouping.
  2. Add a slicer connected to the Region field with the intended visual interactions.
  3. Model Sales as a fact table and Products as a related dimension table.
  4. Use a map visual with authorized geographic fields and appropriate location quality checks.

Explanation

Correct Answer

C:

Model Sales as a fact table and Products as a related dimension table. This directly addresses the case: A Power BI model has Sales rows connected to a Products lookup and analysts need product attributes to filter totals. The deciding technical reason is that a star schema relates fact tables to descriptive dimension tables. Verify the solution by checking: Selecting a product category filters the intended sales measure through the relationship.

Incorrect Answers

A:

Use a proper Date dimension and model relationship for time-based grouping. This is a legitimate approach for a different problem: A semantic model contains Date and Sales tables, but weekly totals differ when a report groups by text month names across years. A date dimension gives time analyses a consistent relational calendar context. It does not directly satisfy the present constraint: A Power BI model has Sales rows connected to a Products lookup and analysts need product attributes to filter totals. The needed outcome is: Selecting a product category filters the intended sales measure through the relationship.

B:

Add a slicer connected to the Region field with the intended visual interactions. This is a legitimate approach for a different problem: A report viewer needs a visible on-page control to filter all relevant charts to one region. Slicers are interactive report filters for selected fields. It does not directly satisfy the present constraint: A Power BI model has Sales rows connected to a Products lookup and analysts need product attributes to filter totals. The needed outcome is: Selecting a product category filters the intended sales measure through the relationship.

D:

Use a map visual with authorized geographic fields and appropriate location quality checks. This is a legitimate approach for a different problem: A logistics team has store latitude and longitude and wants to inspect delivery incidents by location. Map visuals display measures or events using location context. It does not directly satisfy the present constraint: A Power BI model has Sales rows connected to a Products lookup and analysts need product attributes to filter totals. The needed outcome is: Selecting a product category filters the intended sales measure through the relationship.

Question 362

A Power BI model has Sales rows connected to a Products lookup and analysts need product attributes to filter totals. A team proposes: Model Sales as a fact table and Products as a related dimension table. 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. Changing the selected region updates the targeted report visuals.
  3. The visual positions incidents at the intended stores rather than treating coordinates as sales values.
  4. Selecting a product category filters the intended sales measure through the relationship.

Explanation

Correct Answer

D:

Selecting a product category filters the intended sales measure through the relationship. A star schema relates fact tables to descriptive dimension tables. It is tied to this case: A Power BI model has Sales rows connected to a Products lookup and analysts need product attributes to filter totals.

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 Model Sales as a fact table and Products as a related dimension table. and its decisive acceptance check is Selecting a product category filters the intended sales measure through the relationship.

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 Model Sales as a fact table and Products as a related dimension table. and its decisive acceptance check is Selecting a product category filters the intended sales measure through the relationship.

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 Model Sales as a fact table and Products as a related dimension table. and its decisive acceptance check is Selecting a product category filters the intended sales measure through the relationship.

Question 363

During an architecture review, the team proposes: Model Sales as a fact table and Products as a related dimension table. The requirement is: A Power BI model has Sales rows connected to a Products lookup and analysts need product attributes to filter totals. 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. Slicers are interactive report filters for selected fields.
  4. Map visuals display measures or events using location context.

Explanation

Correct Answer

A:

A star schema relates fact tables to descriptive dimension tables. Evidence would be: Selecting a product category filters the intended sales measure through the relationship. The choice avoids this risk: Duplicating product descriptions into every sales row can create inconsistent lookup values.

Incorrect Answers

B:

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 Model Sales as a fact table and Products as a related dimension table. is the best fit here. The relevant reason is A star schema relates fact tables to descriptive dimension tables.

C:

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 Model Sales as a fact table and Products as a related dimension table. is the best fit here. The relevant reason is A star schema relates fact tables to descriptive dimension tables.

D:

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 Model Sales as a fact table and Products as a related dimension table. is the best fit here. The relevant reason is A star schema relates fact tables to descriptive dimension tables.

Question 364

A Power BI model has Sales rows connected to a Products lookup and analysts need product attributes to filter totals. If the team ignores the targeted approach (Model Sales as a fact table and Products as a related dimension table.), which consequence or limitation MOST directly follows from leaving that requirement unaddressed?

  1. Grouping only by month name merges January across different years.
  2. Duplicating product descriptions into every sales row can create inconsistent lookup values.
  3. A static text label will not propagate filtering to report data.
  4. A line chart over store IDs does not show geographic proximity.

Explanation

Correct Answer

B:

Duplicating product descriptions into every sales row can create inconsistent lookup values. This risk follows from the exact scenario: A Power BI model has Sales rows connected to a Products lookup and analysts need product attributes to filter totals. The reason is a star schema relates fact tables to descriptive dimension tables. The direct mitigation is: Model Sales as a fact table and Products as a related dimension table.

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 A Power BI model has Sales rows connected to a Products lookup and analysts need product attributes to filter totals. With the targeted action omitted, the direct exposure is Duplicating product descriptions into every sales row can create inconsistent lookup values.

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 A Power BI model has Sales rows connected to a Products lookup and analysts need product attributes to filter totals. With the targeted action omitted, the direct exposure is Duplicating product descriptions into every sales row can create inconsistent lookup values.

D:

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 A Power BI model has Sales rows connected to a Products lookup and analysts need product attributes to filter totals. With the targeted action omitted, the direct exposure is Duplicating product descriptions into every sales row can create inconsistent lookup values.

Question 365

A sales report needs a reusable NetRevenue calculation that respects the report's filter selections. Which solution or configuration choice MOST directly satisfies the stated requirement without changing unrelated behavior?

  1. Pin appropriate report visuals to a Power BI dashboard in the service.
  2. Use a proper Date dimension and model relationship for time-based grouping.
  3. Use a bar or column chart with category labels and the expense measure.
  4. Create an explicit DAX measure for NetRevenue in the Power BI semantic model.

Explanation

Correct Answer

D:

Create an explicit DAX measure for NetRevenue in the Power BI semantic model. This directly addresses the case: A sales report needs a reusable NetRevenue calculation that respects the report's filter selections. The deciding technical reason is that power BI measures are evaluated dynamically in the model's filter context. Verify the solution by checking: The value recalculates when a viewer changes region or date filters.

Incorrect Answers

A:

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: A sales report needs a reusable NetRevenue calculation that respects the report's filter selections. The needed outcome is: The value recalculates when a viewer changes region or date filters.

B:

Use a proper Date dimension and model relationship for time-based grouping. This is a legitimate approach for a different problem: A semantic model contains Date and Sales tables, but weekly totals differ when a report groups by text month names across years. A date dimension gives time analyses a consistent relational calendar context. It does not directly satisfy the present constraint: A sales report needs a reusable NetRevenue calculation that respects the report's filter selections. The needed outcome is: The value recalculates when a viewer changes region or date filters.

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 sales report needs a reusable NetRevenue calculation that respects the report's filter selections. The needed outcome is: The value recalculates when a viewer changes region or date filters.

Question 366

A sales report needs a reusable NetRevenue calculation that respects the report's filter selections. A team proposes: Create an explicit DAX measure for NetRevenue in the Power BI semantic model. Which observation would BEST demonstrate that this exact requirement was met?

  1. The value recalculates when a viewer changes region or date filters.
  2. The dashboard displays selected tiles from the source reports in one consolidated view.
  3. A year-and-month axis separates corresponding periods and aggregates sales consistently.
  4. Category amounts can be compared along a common quantitative axis.

Explanation

Correct Answer

A:

The value recalculates when a viewer changes region or date filters. Power BI measures are evaluated dynamically in the model's filter context. It is tied to this case: A sales report needs a reusable NetRevenue calculation that respects the report's filter selections.

Incorrect Answers

B:

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 Create an explicit DAX measure for NetRevenue in the Power BI semantic model. and its decisive acceptance check is The value recalculates when a viewer changes region or date filters.

C:

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 Create an explicit DAX measure for NetRevenue in the Power BI semantic model. and its decisive acceptance check is The value recalculates when a viewer changes region or date filters.

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 an explicit DAX measure for NetRevenue in the Power BI semantic model. and its decisive acceptance check is The value recalculates when a viewer changes region or date filters.

Question 367

During an architecture review, the team proposes: Create an explicit DAX measure for NetRevenue in the Power BI semantic model. The requirement is: A sales report needs a reusable NetRevenue calculation that respects the report's filter selections. 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 date dimension gives time analyses a consistent relational calendar context.
  4. Bar and column charts support comparisons among discrete categories.

Explanation

Correct Answer

B:

Power BI measures are evaluated dynamically in the model's filter context. Evidence would be: The value recalculates when a viewer changes region or date filters. The choice avoids this risk: A text box with a fixed total does not respond to model filter context.

Incorrect Answers

A:

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 Create an explicit DAX measure for NetRevenue in the Power BI semantic model. is the best fit here. The relevant reason is Power BI measures are evaluated dynamically in the model's filter context.

C:

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 Create an explicit DAX measure for NetRevenue in the Power BI semantic model. is the best fit here. The relevant reason is Power BI measures are evaluated dynamically in the model's filter 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 Create an explicit DAX measure for NetRevenue in the Power BI semantic model. is the best fit here. The relevant reason is Power BI measures are evaluated dynamically in the model's filter context.

Question 368

A sales report needs a reusable NetRevenue calculation that respects the report's filter selections. If the team ignores the targeted approach (Create an explicit DAX measure for NetRevenue in the Power BI semantic model.), which consequence or limitation MOST directly follows from leaving that requirement unaddressed?

  1. Publishing another multipage report is not the same as building a single dashboard canvas.
  2. Grouping only by month name merges January across different years.
  3. A text box with a fixed total does not respond to model filter context.
  4. A map requires meaningful geographic dimensions that the data does not have.

Explanation

Correct Answer

C:

A text box with a fixed total does not respond to model filter context. This risk follows from the exact scenario: A sales report needs a reusable NetRevenue calculation that respects the report's filter selections. The reason is power BI measures are evaluated dynamically in the model's filter context. The direct mitigation is: Create an explicit DAX measure for NetRevenue in the Power BI semantic model.

Incorrect Answers

A:

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 A sales report needs a reusable NetRevenue calculation that respects the report's filter selections. With the targeted action omitted, the direct exposure is A text box with a fixed total does not respond to model filter context.

B:

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 A sales report needs a reusable NetRevenue calculation that respects the report's filter selections. With the targeted action omitted, the direct exposure is A text box with a fixed total does not respond to model filter context.

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 sales report needs a reusable NetRevenue calculation that respects the report's filter selections. With the targeted action omitted, the direct exposure is A text box with a fixed total does not respond to model filter context.

Question 369

Management wants to see monthly revenue trend over the last two years in chronological order. 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 proper Date dimension and model relationship for time-based grouping.
  3. Use a map visual with authorized geographic fields and appropriate location quality checks.
  4. Pin appropriate report visuals to a Power BI dashboard in the service.

Explanation

Correct Answer

A:

Use a line chart with Month on the time axis and Revenue as its measure. This directly addresses the case: Management wants to see monthly revenue trend over the last two years in chronological order. The deciding technical reason is that line charts emphasize trends across ordered time periods. Verify the solution by checking: The visual shows changes over time with correctly ordered monthly periods.

Incorrect Answers

B:

Use a proper Date dimension and model relationship for time-based grouping. This is a legitimate approach for a different problem: A semantic model contains Date and Sales tables, but weekly totals differ when a report groups by text month names across years. A date dimension gives time analyses a consistent relational calendar context. It does not directly satisfy the present constraint: Management wants to see monthly revenue trend over the last two years in chronological order. The needed outcome is: The visual shows changes over time with correctly ordered monthly periods.

C:

Use a map visual with authorized geographic fields and appropriate location quality checks. This is a legitimate approach for a different problem: A logistics team has store latitude and longitude and wants to inspect delivery incidents by location. Map visuals display measures or events using location context. It does not directly satisfy the present constraint: Management wants to see monthly revenue trend over the last two years in chronological order. The needed outcome is: The visual shows changes over time with correctly ordered monthly periods.

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: Management wants to see monthly revenue trend over the last two years in chronological order. The needed outcome is: The visual shows changes over time with correctly ordered monthly periods.

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.

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