Identify Patterns and Trends PL-300 Practice Questions (Page 3)

Questions 11–15

1. 11foundation · easy

   What does the Clustering feature in Power BI do?

   • AIt automatically groups similar data points based on selected fields
   • BIt sorts data points in ascending order by a numeric field
   • CIt removes outliers from the dataset
   • DIt creates a calculated column that categorizes data based on a text field
   Reveal Solution Discussion Select an answer first
2. 12expert · hard

   A supply chain analyst wants to forecast inventory demand for the next 6 months. The historical data contains a major one-time spike due to a promotion. The analyst wants the forecast to be robust to that spike and also wants to visualize the expected range. Which approach should the analyst take?

   • ARemove the promotion period from the data, then add a forecast with a 95% confidence interval.
   • BUse the Anomaly Detection feature to flag the spike and then add a constant line at the average demand.
   • CAdd a forecast without removing the spike, and rely on the confidence interval to account for it.
   • DAdd error bars using the standard deviation of demand.
   Reveal Solution Discussion Select an answer first
4. 13application · medium

   A sales manager wants to see monthly revenue against a target of $500,000. The manager also wants to quickly spot months where revenue was unusually high or low compared to the overall trend. The report currently has a line chart of monthly revenue. What should the analyst add to the visual?

   • AAdd a median line and change the chart to a stacked bar chart.
   • BAdd a constant line at 500,000 and enable the Analyze feature to detect outliers.
   • CAdd a trend line and enable data labels for each data point.
   • DAdd a forecast line and extend the forecast for 12 months.
   Reveal Solution Discussion Select an answer first
5. 14expert · hard

   A financial analyst is reviewing monthly revenue data and spots a month with revenue that is much higher than the trend. The analyst wants to determine if this is a genuine business event or a data error. The analyst also wants to see if similar anomalies occurred in the past. What should the analyst do?

   • AUse the forecasting feature to see if the spike was predicted.
   • BUse the Anomaly Detection feature to flag the month and then use the Analyze feature to explore potential causes.
   • CCreate a scatter plot of revenue by month and visually inspect the outlier.
   • DAdd a reference line at the average revenue and consider any month above it an anomaly.
   Reveal Solution Discussion Select an answer first
6. 15foundation · easy

   Which Power BI visual is commonly used to visually identify outliers in a dataset?

   • AScatter chart
   • BTable visual
   • CPie chart
   • DSlicer
   Reveal Solution Discussion Select an answer first