This post is a part of the PL-300: Microsoft Power BI Data Analyst Exam Prep Hub; and this topic falls under these sections:
Visualize and analyze the data (25–30%)
--> Identify patterns and trends
--> Use AI visuals
Below are 10 practice questions (with answers and explanations) for this topic of the exam.
There are also 2 practice tests for the PL-300 exam with 60 questions each (with answers) available on the hub.
Practice Questions
Question 1
A business user wants to understand which factors most strongly influence customer churn. They want Power BI to automatically rank those factors. Which AI visual should you use?
A. Decomposition Tree
B. Key Influencers
C. Scatter chart with clustering
D. Anomaly detection
Correct Answer: B
Explanation:
The Key Influencers visual is designed to identify and rank factors that influence a selected outcome, such as churn or customer satisfaction.
Question 2
You want to break down total sales into region, product category, and salesperson, allowing users to dynamically explore contributing factors. Which AI visual is best?
A. Key Influencers
B. Decomposition Tree
C. Waterfall chart
D. Table visual
Correct Answer: B
Explanation:
The Decomposition Tree supports hierarchical exploration and allows AI-assisted or manual splitting of a measure across dimensions.
Question 3
A report shows daily website visits, and you want Power BI to automatically highlight unusual spikes or drops in traffic. Which feature should you use?
A. Key Influencers
B. Binning
C. Anomaly Detection
D. Explain the increase
Correct Answer: C
Explanation:
Anomaly Detection identifies unexpected deviations in time-series data and is ideal for spotting spikes and dips.
Question 4
Which requirement must be met for anomaly detection to work in a Power BI visual?
A. The data must be categorical
B. The visual must include a continuous time field
C. The model must use DirectQuery
D. A calculated column must exist
Correct Answer: B
Explanation:
Anomaly detection requires time-series data with a continuous date or time axis.
Question 5
A user right-clicks a bar in a chart and selects “Explain the increase.” What does Power BI do next?
A. Creates a new DAX measure
B. Filters the dataset
C. Uses AI to identify contributing factors
D. Applies clustering
Correct Answer: C
Explanation:
Explain the increase/decrease uses AI to analyze changes and surfaces factors that contributed to the increase or decrease.
Question 6
Which AI visual is best suited for explaining why a KPI differs across categories rather than how much it differs?
A. Line chart
B. Decomposition Tree
C. Key Influencers
D. Bar chart
Correct Answer: C
Explanation:
Key Influencers focuses on causation and influence, not just comparison.
Question 7
Which statement about AI visuals in Power BI is true?
A. They permanently modify the dataset
B. They replace the need for data modeling
C. Their insights depend on data quality
D. They only work in Power BI Desktop
Correct Answer: C
Explanation:
AI visuals rely heavily on clean, well-modeled data. Poor data quality can produce misleading insights.
Question 8
You want Power BI to automatically suggest the best way to split a metric when analyzing performance drivers. Which visual supports this behavior?
A. Key Influencers
B. Decomposition Tree
C. Matrix
D. Scatter chart
Correct Answer: B
Explanation:
The Decomposition Tree supports AI-generated splits, allowing Power BI to suggest the most meaningful breakdowns.
Question 9
Which of the following scenarios most strongly indicates the use of an AI visual?
A. Formatting a report page
B. Sorting a bar chart
C. Investigating unexpected changes in metrics
D. Applying conditional formatting
Correct Answer: C
Explanation:
AI visuals are ideal for exploratory analysis, especially when investigating unexpected patterns or changes.
Question 10
Why should AI-generated insights always be reviewed by the report author?
A. AI visuals require manual refresh
B. AI visuals are experimental features
C. AI visuals can misinterpret business context
D. AI visuals only work with small datasets
Correct Answer: C
Explanation:
AI visuals identify statistical patterns but do not understand business context, making human validation essential.
Exam Tip Summary
For the PL-300 exam, remember:
- Key Influencers → explains why outcomes occur
- Decomposition Tree → explores how metrics break down
- Anomaly Detection → identifies unusual trends
- Explain the increase/decrease → quick AI explanations
- AI visuals support, not replace, solid data modeling
Go back to the PL-300 Exam Prep Hub main page
