A Power BI report shows sales by month. The analyst needs to show the running total of sales over the months. Which DAX expression should be used?

TOTALYTD(SUM(Sales[Amount]), Sales[Date])

CALCULATE(SUM(Sales[Amount]), FILTER(ALL(Sales[Date]), Sales[Date] <= MAX(Sales[Date])))

A financial analyst has a Power BI data model with a 'Sales' table containing 'Quantity' and 'UnitPrice' columns. The analyst needs to create a new field that calculates the total revenue for each row. What should the analyst create?

A calculated table that contains the revenue values

A calculated column with the formula = Sales[Quantity] * Sales[UnitPrice]

A measure with the formula = SUM(Sales[Quantity] * Sales[UnitPrice])

A measure with the formula = SUMX(Sales, Sales[Quantity] * Sales[UnitPrice])

A manager wants a single view that shows the most important metrics from multiple reports without requiring interaction. The manager needs to see this view on a TV screen in the office. What should be created?

A Power BI app with multiple dashboards

A Power BI dashboard with pinned visuals from multiple reports

A Power BI report with multiple pages

A data analyst is building a Power BI report from two tables: Sales (with SalesAmount and ProductID) and Product (with ProductID and Category). The analyst needs to create a measure that calculates total sales per category. What must the analyst do first to ensure the measure returns correct results?

Create a DAX measure that uses the LOOKUPVALUE function

Create a relationship between Sales and Product on ProductID

Merge the two tables into one using Power Query

Add a calculated column to Sales that looks up Category

A logistics company wants to visualize the number of shipments by delivery status (e.g., Delivered, In Transit, Delayed) and also allow users to filter by region. Which visual should be used in a Power BI report?

A pie chart with a slicer for region

A table with a slicer for region

A map visual with a slicer for region

A line chart with a slicer for region

Microsoft Certified:Azure Data Fundamentals

Domain 4Objective 3

Describe Data Visualization in Microsoft Power BI DP-900 Practice Questions (Page 7)

Part of the Describe an analytics workload on Azure domain, which accounts for 25–30% of the DP-900 exam. Microsoft does not publish an official question count, but from its 45-minute exam (~20–30 total, ~5–9 in this domain), expect 2–3 from this objective — we provide 39 practice questions to prepare you well beyond it. (estimate)

39questions here

8free pages

9concepts

25–30%of the exam

Questions 31–35

31application · medium
A Power BI report shows sales by month. The analyst needs to show the running total of sales over the months. Which DAX expression should be used?
Select an answer first
32application · medium
A financial analyst has a Power BI data model with a 'Sales' table containing 'Quantity' and 'UnitPrice' columns. The analyst needs to create a new field that calculates the total revenue for each row. What should the analyst create?
Select an answer first
33application · medium
A manager wants a single view that shows the most important metrics from multiple reports without requiring interaction. The manager needs to see this view on a TV screen in the office. What should be created?
Select an answer first
34application · medium
A data analyst is building a Power BI report from two tables: Sales (with SalesAmount and ProductID) and Product (with ProductID and Category). The analyst needs to create a measure that calculates total sales per category. What must the analyst do first to ensure the measure returns correct results?
Select an answer first
35application · medium
A logistics company wants to visualize the number of shipments by delivery status (e.g., Delivered, In Transit, Delayed) and also allow users to filter by region. Which visual should be used in a Power BI report?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to DP-900

Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by Microsoft. “DP-900” is a trademark of its owner, used for identification only.