DRAG DROP -You have a Microsoft Excel spreadsheet that contains the data shown in the following table.You plan to build a data model for a Power BI report.You need to prepare the data so that it is available to the model in the format shown in the following table.Which three actions should you perform in sequence in Power Query Editor? 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 need to design the data model and the relationships for the Customer Details worksheet and the Orders table by using Power BI. The solution must meet the report requirements.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:
HOTSPOT -You need to grant access to the business unit analysts.What should you configure? To answer, select the appropriate options in the answer area.NOTE: Each correct selection is worth one point.Hot Area:
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.Hot Area:
HOTSPOT -You have a Power BI tenant that hosts the datasets shown in the following table.You have the following requirements:The export of reports that contain Personally Identifiable Information (PII) must be prevented.Data used for financial decisions must be reviewed and approved before use.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:
HOTSPOT -You plan to create the Power BI model shown in the exhibit. (Click the Exhibit tab.)The data has the following refresh requirements:✑ Customer must be refreshed daily.✑ Date must be refreshed once every three years.✑ Sales must be refreshed in near real time.✑ SalesAggregate must be refreshed once per week.You need to select the storage modes for the tables. The solution must meet the following requirements:✑ Minimize the load times of visuals.✑ Ensure that the data is loaded to the model based on the refresh requirements.Which storage mode should you select for each table? To answer, select the appropriate options in the answer area.NOTE: Each correct selection is worth one point.Hot Area:
