- (Exam Topic 4)
You build a Power Bl report that displays 10T temperature data streaming from a refrigerator. You publish the report to the Bl service.
You need to be notified when the temperature rises above four degrees Celsius. What should you do?

1. A. Pin a report page to a dashboard and set an alert on the page.
2. B. Set an alert on a KPI visual in the report.
3. C. Pin a card visual to a dashboard and set an alert on the tile.
4. D. Pin a card visual to a dashboard and create a subscription.

Correct Answer: A

- (Exam Topic 4)
You create the following step by using Power Query Editor.
= Table.ReplaceValue(SalesLT_Address,"1318","1319",Replacer.ReplaceText,{"AddressLine1"})
A row has a value of 21318 Lasalle Street in the AddressLine1 column. What will the value be when the step is applied?

1. A. 1318
2. B. 1319
3. C. 21318 Lasalle Street
4. D. 21319 Lasalle Street

Correct Answer: D
Example:
Replace the text "ur" with the text "or" in the table.

Reference:
https://docs.microsoft.com/en-us/powerquery-m/table-replacevalue

- (Exam Topic 4)
You have the Power Bl 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?

1. A. Create a row-level security (RLS) role for each department, and then define the membership of the role.
2. B. Create a DepartmentID parameter to filter the Departments table.
3. C. To the ConfidentialData table, add a calculated measure that uses the currentgroup DAX function.
4. D. Create a slicer that filters Departments based on DepartmentID.

Correct Answer: A

- (Exam Topic 4)
You are using existing reports to build a dashboard that will be viewed frequently in portrait mode on mobile phones.
You need to build the dashboard.
Which four actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

Solution:
* 1. Pin items from report to Dashboard.
* 2. Open Dashboard.
* 3. Change the dashboard view to Phone view.
* 4. Rearrange, resize the visuals.

Does this meet the goal?

1. A. Yes
2. B. No

Correct Answer: A

- (Exam 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