- (Topic 4)
You have a Power BI model that contains a table named Sales. The Sales table contains the following columns:
• Order Line ID
• Product ID
• Unit Price
• Order ID
• Quantity
Orders are uniquely identified by using the order ID and can have multiple order lines Each order line within an order contains a different product ID.
You need to write a DAX measure that counts the number of orders. Which formula should you use?

1. A. CountRows('Sales')
2. B. Count ('Sales'(Order ID])
3. C. CountA (Sale** (Order ID])
4. D. DistinctCount (sales'[Order ID])

Correct Answer: D

- (Topic 4)
You have a Microsoft Power Bl report. The size of PBIX file is 550 MB. The report is accessed by using an App workspace in shared capacity of powerbi.com.
The report uses an imported dataset that contains one fact table. The fact table contains 12 million rows. The dataset is scheduled to refresh twice a day at 08:00 and 17:00.
The report is a single page that contains 15 custom visuals and 10 default visuals.
Users say that the report is slow to load the visuals when they access and interact with the report
You need to recommend a solution to improve the performance of the report. What should you recommend?

1. A. Split the visuals onto multiple pages.
2. B. Implement row-level security (RLS).
3. C. Replace the default visuals with custom visuals.
4. D. Increase the number of times that the dataset is refreshed.

Correct Answer: A

- (Topic 1)
You need to create the required relationship for the executive's visual. What should you do before you can create the relationship?

1. A. Change the data type of Sales[region_id] to Whole Number.
2. B. In the Sales table, add a measure for sum(sales_amount).
3. C. Change the data type of sales[sales_id] to Text.
4. D. Change the data type of sales [region_id] to Decimal Number.

Correct Answer: A
Scenario: Executives require a visual that shows sales by region.
Need to change the sales_id column from Varchar to Whole Number (Integer).

HOTSPOT - (Topic 4)
You need to create a visual as shown in the following exhibit.

The indicator color for Total Sales will be based on % Growth to Last Year. The solution must use the existing calculations only.
How should you configure the visual? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Solution:
Box 1: Background color
To format the Color column based on its field values, select Conditional formatting for the Color field, and then select Background color or Font color.
In the Background color or Font color dialog box, select Field value from the Format by drop-down field.
Box 2: Field value
With conditional formatting for tables in Power BI Desktop, you can specify customized cell colors, including color gradients, based on field values.

Does this meet the goal?

1. A. Yes
2. B. No

Correct Answer: A

HOTSPOT - (Topic 4)
You have a Power BI model that contains the following data.

The Date table relates to the Sales table by using the Date columns. You need to create a calculated table that v/ill contain the following:

Solution:


Does this meet the goal?

1. A. Yes
2. B. No

Correct Answer: A