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

Questions 6–10

1. 6application · medium

   A sales analyst notices that revenue in the current month is significantly lower than the previous month. The analyst wants to understand which product categories and regions contributed most to this decline. What should the analyst do?

   • ACreate a scatter plot of revenue by category and region.
   • BUse the Analyze feature on the revenue visual to see the main contributors to the change.
   • CUse the Anomaly Detection feature to identify the months with unusual revenue.
   • DAdd a reference line at the previous month's revenue to compare visually.
   Reveal Solution Discussion Select an answer first
2. 7application · medium

   A marketing analyst has a list of 50 product categories and wants to simplify a report by combining related categories into broader groups, such as 'Electronics' and 'Apparel'. The analyst also wants to see the total sales for each group without creating a new column in the data model. What should the analyst do?

   • AUse the Clustering feature on a scatter chart with sales and profit.
   • BCreate bins on the category field with a bin size of 10.
   • CAdd a reference line to the category axis at the median sales value.
   • DCreate a grouping in the report that maps multiple categories to a single group and use that group in a visual.
   Reveal Solution Discussion Select an answer first
4. 8application · medium

   An operations analyst is monitoring daily server error counts over the past year. The analyst wants to automatically identify days where the error count was unusually high or low compared to the expected pattern, and then understand what might have caused those anomalies. What should the analyst do?

   • ACreate a forecast to predict future error counts and rely on the forecast line.
   • BAdd error bars to the line chart to show the expected range of error counts.
   • CManually scroll through the data and note any days that look different.
   • DUse the Anomaly Detection feature on a line chart, then use the Analyze feature to explore the detected anomalies.
   Reveal Solution Discussion Select an answer first
5. 9foundation · easy

   In Power BI Desktop, what is the primary purpose of the Analyze feature when working with a visual?

   • ATo export the visual's underlying data to a CSV file for further analysis
   • BTo create a new calculated column based on the visual's current filters
   • CTo identify the factors that contribute to a specific data point or overall trend in the visual
   • DTo automatically generate a narrative summary of the visual's data
   Reveal Solution Discussion Select an answer first
6. 10expert · hard

   An analyst is analyzing transaction amounts that range from $1 to $10,000. The analyst wants to create a histogram to see the distribution, but the default bin size of $1,000 makes the first bin (0–$1,000) dominate the chart, hiding important patterns. The analyst also wants to group certain transaction categories (e.g., 'Refund', 'Chargeback') separately from the main distribution. What should the analyst do?

   • ACreate a calculated column that categorizes transactions into large and small, then use that in a bar chart.
   • BUse the Analyze feature to explain why the first bin is dominant.
   • CChange the bin size to a smaller value, such as $100, and use a group for the special categories.
   • DAdd error bars to the histogram to show the variability within each bin.
   Reveal Solution Discussion Select an answer first