Microsoft Power BI Data Analyst — Question 2

You have a Power BI report.
You have a table named Data1 that contains 10 million rows.
Data1 is used in the following visuals:
✑ A card that shows the number of records
✑ A bar chart that shows total transaction amount by territory
✑ A scatter plot that shows transaction amount and profit amount on the axes and points colored by territory
You need to modify the scatter plot to make it easier for users to identify meaningful patterns. The solution must not affect the accuracy of the other visuals.
What should you do?

Answer options

• A. Add a count field of the transaction amount to the size bucket of the scatter plot.
• B. Add a trend line to the scatter plot.
• C. Enable high-density sampling on the scatter plot.
• D. Apply a row filter to the Data1 query in Power Query Editor.

Correct answer: C

Explanation

The correct answer is C because enabling high-density sampling allows the scatter plot to effectively visualize a large number of data points, making patterns more discernible without altering the underlying data accuracy. Options A and B do not specifically address the need for pattern recognition in large datasets, while D may overly restrict the data and negatively impact the other visuals.