PL-300.pdf
The Impressions table contains approximately 30 million records per month.
You need to create an ad analytics system to meet the following requirements:
Present ad impression counts for the day, campaign, and Site_name. The analytics for the last year
are required.
Minimize the data model size.
Which two actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
The IOT ID columns are unique to each row in query.
You need to analyze 10T events by the hour and day of the year. The solution must improve dataset
performance.
Solution: You change the IOT DateTime column to the Date data type.
Does this meet the goal?HOTSPOT You have a Power BI imported dataset that contains the data model shown in the following exhibit. 
Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic. NOTE: Each correct selection is worth one point. 
You need to create a visual that compares profit across 10 product categories fora selected quarter.
What is the best visual to use to achieve the goal?
There are four departments in the Departments table.
You need to ensure that users can see the data of their respective department only.
What should you do?DRAG DROP You have a Power Bl report that contains a table visual with a measure named Revenue. The Revenue measure returns values within a range of 0 to S. You need to formal the visual so that the Revenue column displays a specific background color based on the value range shown in the following table. 
Which three actions should you perform in sequence in Power B) Desktop? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order. 
HOTSPOT You open powerbi.com as shown in the following exhibit. 
Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic. NOTE: Each correct selection is worth one point. 
DRAG DROP You create a data model in Power BI. Report developers and users provide feedback that the data model is too complex. The model contains the following tables. 
The model has the following relationships: *There is a one-to-one relationship between Sales_Region and Region_Manager. *There are more records in Manager than in Region_Manager, but every record in Region_Manager has a corresponding record in Manager. *There are more records in Sales_Manager than in Sales_Region, but every record in Sales_Region has a corresponding record in Sales_Manager. You need to denormalize the model into a single table. Only managers who are associated to a sales region must be included in the reports. Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order. NOTE: More than one order of answer choices is correct. You will receive credit for any of the correct orders you select. 
HOTSPOT You publish the dataset to powerbi.com. For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point. 
