HOTSPOT -You have the Power BI 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.Hot Area:
DRAG DROP -You have the line chart shown in the exhibit. (Click the Exhibit tab.)You need to modify the chart to meet the following requirements:✑ Identify months that have order counts above the mean.✑ Display the mean monthly order count.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:
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:
HOTSPOT -You view a query named Transactions as shown in the following exhibit.The query gets CSV files from a folder.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.Hot Area:
Your company has employees in 10 states.The company recently decided to associate each state to one of the following three regions: East, West, and North.You have a data model that contains employee information by state. The model does NOT include region information.You have a report that shows the employees by state.You need to view the employees by region as quickly as possible.What should you do?
HOTSPOT -You are creating a Microsoft Power BI imported data model to perform basket analysis. The goal of the analysis is to identify which products are usually bought together in the same transaction across and within sales territories.You import a fact table named Sales as shown in the exhibit. (Click the Exhibit tab.)The related dimension tables are imported into the model.Sales contains the data shown in the following table.You are evaluating how to optimize the model.For each of the following statements, select Yes if the statement is true. Otherwise, select No.NOTE: Each correct selection is worth one point.Hot Area:
