- (Exam Topic 4)
You have a Power Bl report that contains five pages. Pages 1 to 4 are visible and page 5 is hidden.
You need to create a solution that will enable users to quickly navigate from the first page to all the other visible pages. The solution must minimize development and maintenance effort as pages are added to the report.
What should you do first?

1. A. Add a blank button to page 1.
2. B. Add a bookmark navigation button to page 1.
3. C. Create a bookmark for each page.
4. D. Add a page navigation button to page 1.

Correct Answer: D

- (Exam Topic 4)
You are creating a sales report in Power Bl for the NorthWest region sales territory of your company. Data will come from a view in a Microsoft SQL Server database. A sample of the data is shown in the following table:

The report will facilitate the following analysis:
• The count of orders and the sum of total sales by Order Date
• The count of customers who placed an order
• The average quantity per order
You need to reduce data refresh times and report query times.
Which two actions should you perform? Each correct answer presents part of the solution
NOTE: Each correct selection is worth one point.

1. A. Fillet the data to only the NorthWest region sales territory.
2. B. Remove the CustomerKey and ProductKey columns.
3. C. Remove the TaxAmt and Freight columns.
4. D. Set the data type for SatesOrderNumber to Decimal Number

Correct Answer: AC

- (Exam Topic 3)
You need to create a solution to meet the notification requirements of the warehouse shipping department. What should you do? To answer, select the appropriate options in the answer area.
NOTE: Each correct select is worth one point:

Solution:


Does this meet the goal?

1. A. Yes
2. B. No

Correct Answer: A

- (Exam Topic 4)
You are modeling data in table named SalesDetail by using Microsoft Power Bl.
You need to provide end users with access to the summary statistics about the SalesDetail data. The users require insights on the completeness of the data and the value distributions.
Which three 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:


Does this meet the goal?

1. A. Yes
2. B. No

Correct Answer: A

- (Exam Topic 4)
You have a Microsoft Power BI data model that contains three tables named Orders, Date, and City. There is a one-to-many relationship between Date and Orders and between City and Orders.
The model contains two row-level security (RLS) roles named Role1 and Role2. Role1 contains the following filter.
City[State Province] = "Kentucky"
Role2 contains the following filter. Date[Calendar Year] = 2020
If a user is a member of both Role1 and Role2, what data will they see in a report that uses the model?

1. A. The user will see data for which the State Province value is Kentucky and the Calendar Year is 2020.
2. B. The user will see data for which the State Province value is Kentucky or the Calendar Year is 2020.
3. C. The user will see only data for which the State Province value is Kentucky.
4. D. The user will receive an error and will not be able to see the data in the report.

Correct Answer: B
When a report user is assigned to multiple roles, RLS filters become additive. It means report users can see table rows that represent the union of those filters.
Reference:
https://docs.microsoft.com/en-us/power-bi/guidance/rls-guidance