Question 31

You are creating a Power Bi model and report.
You have a single table in a data mode) named Product Product contains the following fields:
* ID
* Name
* Color
* Category
* Total Sales
You need to create a calculated table that shows only the top eight products based on the highest value in Total Sales.
How should you complete the DAX expression? To answer, drag the appropriate values to the coned targets.
Each value may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.

Question 32

You plan to create the Power Bl 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:

Question 33

Your company plans to completely separate development and production assets such as datasets, reports, and dashboards in Microsoft Power Bl.
You need to recommend an application lifecycle strategy. The solution must minimize maintenance to update access and prevent end users from viewing the development assets.
What should you recommend?
  • Question 34

    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 (Pll) 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

    Question 35

    You need to configure access for the sales department users. The solution must me meet the security requirements. What should you do?