A data analyst has a Power BI model with a 'Sales' table and a 'Date' table. The analyst creates a measure 'Total Sales' = SUM(Sales[Amount]). When the analyst places 'Total Sales' on a visual with 'Year' from the Date table, the values are correct. However, when the analyst creates a new measure 'Total Sales Previous Year' = CALCULATE([Total Sales], SAMEPERIODLASTYEAR('Date'[Date])) and places it on a visual with 'Year', the values for the previous year are blank. What is the most likely cause?

The Date table does not contain dates for the previous year

The Sales table has no relationship to the Date table

The Sales table has no data for the previous year

The Date table is not marked as a date table

A data analyst needs to build a Power BI report that combines data from an Azure SQL Database and an Excel spreadsheet stored in OneDrive. The analyst wants to refresh the data automatically on a schedule. What should the analyst do?

Import both sources into Power BI Desktop and rely on manual refresh only

Use Power BI Report Builder to create a paginated report

Use Power Query to connect to both sources and then publish the report to the Power BI service with a scheduled refresh

Copy the data from both sources into a single CSV file and import that file

What is the primary way to share a Power BI report with others in an organization?

Publish the report to the Power BI service and share it with specific users or groups

Print the report and distribute it physically

Send the .pbix file as an email attachment

Export the report to a PDF and post it on a website

A Power BI report has a bar chart showing sales by product. The analyst wants to allow users to see only the top 10 products by sales. What should the analyst do?

Create a measure that returns only the top 10 products

Apply a visual-level filter to the bar chart to show only the top 10

Add a slicer for product and instruct users to select the top 10

Change the data model to include only the top 10 products

A data analyst needs to import data from an on-premises SQL Server database into Power BI. The analyst wants to refresh the data daily. What should the analyst configure?

A VPN connection to the SQL Server

Microsoft Certified:Azure Data Fundamentals

Domain 4Objective 3

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

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 6–10

6expert · hard
A data analyst has a Power BI model with a 'Sales' table and a 'Date' table. The analyst creates a measure 'Total Sales' = SUM(Sales[Amount]). When the analyst places 'Total Sales' on a visual with 'Year' from the Date table, the values are correct. However, when the analyst creates a new measure 'Total Sales Previous Year' = CALCULATE([Total Sales], SAMEPERIODLASTYEAR('Date'[Date])) and places it on a visual with 'Year', the values for the previous year are blank. What is the most likely cause?
Select an answer first
7application · medium
A data analyst needs to build a Power BI report that combines data from an Azure SQL Database and an Excel spreadsheet stored in OneDrive. The analyst wants to refresh the data automatically on a schedule. What should the analyst do?
Select an answer first
8foundation · easy
What is the primary way to share a Power BI report with others in an organization?
Select an answer first
9application · medium
A Power BI report has a bar chart showing sales by product. The analyst wants to allow users to see only the top 10 products by sales. What should the analyst do?
Select an answer first
10application · medium
A data analyst needs to import data from an on-premises SQL Server database into Power BI. The analyst wants to refresh the data daily. What should the analyst configure?
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.