A data analyst imports a large CSV file with millions of rows. The analyst notices that the import takes a long time and the resulting Power BI model is slow. The analyst only needs a few columns for the report. What should the analyst do to improve performance?

Increase the number of rows in the CSV file

Load all columns and then hide the unnecessary ones in the report

Use Power Query to remove unnecessary columns before loading

Use a calculated table to filter the data

A data analyst imports a table that has a 'CustomerName' column with values like 'John Smith' and 'Jane Doe'. The analyst wants to split this column into 'FirstName' and 'LastName' for better analysis. Where should the analyst perform this transformation?

In the model view by creating a new relationship

In the data view by changing the data type

In Power Query Editor by using the Split Column feature

In the report view by creating a calculated column

In Power BI, what is a relationship between two tables?

A visual that shows how data changes over time

A rule that filters data before it is loaded

A connection that defines how rows in one table relate to rows in another table

A DAX formula that calculates a value

What is the purpose of a slicer in a Power BI report?

To create relationships between tables

To transform data before loading

To allow users to filter data interactively by selecting values

Microsoft Certified:Azure Data Fundamentals

Domain 4Objective 3

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

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 16–20

16expert · hard
A data analyst imports a large CSV file with millions of rows. The analyst notices that the import takes a long time and the resulting Power BI model is slow. The analyst only needs a few columns for the report. What should the analyst do to improve performance?
Select an answer first
17foundation · easy
Which feature in Power BI allows multiple people to work on the same report simultaneously?
Select an answer first
18application · medium
A data analyst imports a table that has a 'CustomerName' column with values like 'John Smith' and 'Jane Doe'. The analyst wants to split this column into 'FirstName' and 'LastName' for better analysis. Where should the analyst perform this transformation?
Select an answer first
19foundation · easy
In Power BI, what is a relationship between two tables?
Select an answer first
20foundation · easy
What is the purpose of a slicer 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.