HOTSPOT -You need to create a KPI visualization to meet the reporting requirements of the sales managers.How should you create the visualization? To answer, select the appropriate options in the answer area.NOTE: Each correct selection is worth one point.Hot Area:
You need to create relationships to meet the reporting requirements of the customer service department.What should you create?
You have a project management app that is fully hosted in Microsoft Teams. The app was developed by using Microsoft Power Apps.You need to create a Power BI report that connects to the project management app.Which connector should you select?
You have a collection of reports for the HR department of your company. The datasets use row-level security (RLS). The company has multiple sales regions.Each sales region has an HR manager.You need to ensure that the HR managers can interact with the data from their region only. The HR managers must be prevented from changing the layout of the reports.How should you provision access to the reports for the HR managers?
HOTSPOT -You need to create a measure that returns the percent of revenue by product category.How should you complete the measure? To answer, select the appropriate options in the answer area.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:
