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

Questions 36–40

1. 36foundation · easy

   When you create a group in Power BI Desktop, what happens to the original field?

   • AThe original field is deleted from the data model
   • BThe original field is moved to a different table
   • CThe original field is renamed to the group name
   • DA new field is created that can be used in visuals, while the original field remains available
   Reveal Solution Discussion Select an answer first
2. 37expert · hard

   A business user wants to ask questions about the data in natural language, such as 'What were the top 5 products by sales last quarter?' The user also wants to get a quick summary of the key trends in the data without building visuals manually. The organization has enabled Copilot in Power BI. What should the user do?

   • ACreate a clustered column chart and manually sort by sales.
   • BUse the Q&A feature to ask the question and use Copilot to generate a summary of the data.
   • CUse the Analyze feature on a visual to get the top products.
   • DUse the Key Influencers visual to see which products are top sellers.
   Reveal Solution Discussion Select an answer first
4. 38foundation · easy

   What is the purpose of the Forecast feature in Power BI?

   • ATo group data into clusters for segmentation
   • BTo predict future values based on historical data patterns
   • CTo identify outliers in the data
   • DTo create a reference line that shows the average value
   Reveal Solution Discussion Select an answer first
5. 39expert · hard

   A sales analyst has a field with 100 product names. The analyst wants to create a report that shows sales by product category, but the categories are not in the data. The analyst also wants to allow users to toggle between viewing by individual product and by category. Which approach should the analyst take?

   • AUse the Clustering feature on a scatter chart with sales and profit.
   • BAdd a reference line to the product axis at the median sales value.
   • CCreate bins on the product name field with a bin size of 10.
   • DCreate a grouping on the product name field and use the group field in a visual, with the ability to drill down from group to product.
   Reveal Solution Discussion Select an answer first
6. 40expert · hard

   A sales analyst has a list of customer names and wants to analyze sales by customer size: 'Small', 'Medium', and 'Large'. The analyst has a column with the number of employees, but the thresholds for these categories are not fixed and may change in the future. The analyst also wants to add a line showing the average sales for each customer size. What should the analyst do?

   • AAdd a reference line at the average employee count to separate small and large customers.
   • BCreate a grouping on the customer name field and manually assign each customer to a size group.
   • CCreate a calculated column that uses IF statements to assign a size based on employee count.
   • DUse the binning feature on the employee count column with custom bin boundaries for Small, Medium, and Large.
   Reveal Solution Discussion Select an answer first