HOTSPOT - (Topic 4)
You are creating a quick measure as shown in the following exhibit.

You need to create a monthly rolling average measure for Sales over time-How should you configure the quick measure calculation? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Solution:
Box 1: Total Sales
We select the field Total Sales
Box 2: Date Select a date field.
Box 3: Month Monthly periods.

Does this meet the goal?

1. A. Yes
2. B. No

Correct Answer: A

- (Topic 4)
You publish a Microsoft Power BI dataset to powerbi.com. The dataset appends data from an on-premises Oracle database and an Azure SQL database by using one query.
You have admin access to the workspace and permission to use an existing On-premises data gateway for which the Oracle data source is already configured.
You need to ensure that the data is updated every morning. The solution must minimize configuration effort.
Which two actions should you perform when you configure scheduled refresh? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

1. A. Configure the dataset to use the existing On-premises data gateway.
2. B. Deploy an On-premises data gateway in personal mode.
3. C. Set the refresh frequency to Daily.
4. D. Configure the dataset to use the personal gateway.

Correct Answer: AC
https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-personal-mode

- (Topic 4)
The Sales table contains records of sales by day from the last five years up until today's date.
You plan to create a measure to return the total sales Of March 2021 when March 2022 is selected.
Which DAX expression should you use?

1. A. Option A
2. B. Option B
3. C. option C
4. D. Option D

Correct Answer: B

- (Topic 4)
You manage a Power BI model has a table named Sales and product.
You need to ensure that a sales team can view only data that has a CountryRegionName value of United States and a ProductCategory value of Clothing.
What should you do from Power BI Desktop?

1. A. From Power BI Desktop, create a new role that has the following filter.[countryRegionName]= “United States” && [ProductCategory]= “Clothing”
2. B. Add the following filters in Query Editor.CountryRegionName is United StatesProductCategory is Clothing
3. C. From Power BI Desktop, create a new role that has the following filters.[CountryRegionName]= “United States”
4. D. Add the following filters to a report.CountryRegionName is United SatesProductCategory is Clothing

Correct Answer: D
References: https://docs.microsoft.com/en-us/power-bi/power-bi-how-to-report-filter

- (Topic 4)
You have a Power BI app named App1. The privacy for the App1 workspace is set to Private.
A user named User1 reports that App1 does not appear in the My organization AppSource. App1 appears in the My organization AppSource for your account.
You need to ensure that User sees App1 from the My organization AppSource. What should you do?

1. A. From the app workspace, click Update app, configure the Content settings, and then click Update app.
2. B. From the app workspace settings, add a member.
3. C. From the app workspace, click Update app, configure the Access setting, and then click Update app.
4. D. From the app workspace, share the dashboard.

Correct Answer: C
References: https://docs.microsoft.com/en-us/power-bi/service-organizational-content-pack-introduction#what-is-appsource