DRAG DROP -You have a query named Customer that imports CSV files from a data lake. The query contains 50,000 rows as shown in the exhibit. (Click the Exhibit tab.)Each file contains deltas of any new or modified rows from each load to the data lake. Multiple files can have the same customer ID.You need to keep only the last modified row for each customer ID.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.Select and Place:
You have a line chart that shows the number of employees in a department over time.You need to see the total salary costs of the employees when you hover over a data point.What are two possible ways to achieve this goal? Each correct answer presents a complete solution.NOTE: Each correct selection is worth one point.
HOTSPOT -You need to calculate the last day of the month in the balance sheet data to ensure that you can relate the balance sheet data to the Date table.Which type of calculation and which formula should you use? To answer, select the appropriate options in the answer area.NOTE: Each correct selection is worth one point.Hot Area:
You have the tables shown in the following table.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.
You have four sales regions. Each region has multiple sales managers.You implement row-level security (RLS) in a data model. You assign the relevant distribution lists to each role.You have sales reports that enable analysis by region. The sales managers can view the sales records of their region. The sales managers are prevented from viewing records from other regions.A sales manager changes to a different region.You need to ensure that the sales manager can see the correct sales data.What should you do?
What is the minimum number of Power BI datasets needed to support the reports?
