You have the Power BI model shown in the following exhibit.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?
In Power BI Desktop, you are building a sales report that contains two tables. Both tables have row-level security (RLS) configured.You need to create a relationship between the tables. The solution must ensure that bidirectional cross-filtering honors the RLS settings.What should you do?
HOTSPOT -You have a column named UnitsInStock as shown in the following exhibit.UnitsInStock has 75 non-null values, of which 51 are unique.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:
HOTSPOT -You have a Power BI report.You have the following tables.You have the following DAX measure.Accounts :=CALCULATE (DISTINCTCOUNT (Balances[AccountID]),LASTDATE ('Date'[Date])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:
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.
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:
