- (Topic 4)

Each employee has one manager as shown in the ParentEmployeelD column, All reporting paths lead to the CEO at the top of the organizational hierarchy.
You need to create a calculated column that returns the count of levels from each employee to the CEO.
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 build a Power Bi report that displays loT temperature data streaming from a refrigerator.
You publish the report to the Power BI service.
You need to be notified when the temperature rises above four degrees Celsius. What should you do?

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

Correct Answer: A

FILL IN THE BLANK - (Topic 4)
You have a Power Bl visual that uses indicators to show values that are out of range as shown in the following exhibit.

Solution:


Does this meet the goal?

1. A. Yes
2. B. No

Correct Answer: A

- (Topic 4)
You have a custom connector that returns ID, From, To, Subject, Body, and Has Attachments for every email sent during the past year. More than 10 million records are returned.
You build a report analyzing the internal networks of employees based on whom they send emails to.
You need to prevent report recipients from reading the analyzed emails. The solution must minimize the model size.
What should you do?

1. A. Implement row-level security (RLS) so that the report recipients can only see results based on the emails they sent.
2. B. Remove the Subject and Body columns during the import.
3. C. From Model view, set the Subject and Body columns to Hidden.

Correct Answer: B

DRAG DROP - (Topic 4)
You are building a dataset from a JSON file that contains an array of documents.
You need to import attributes as columns from all the documents in the JSON file. The solution must ensure that date attributes can be used as date hierarchies in Microsoft Power BI reports.
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:
1- Convert list to table 2- Expand Column
3- Set Date type
Here is an example: https://youtu.be/B4kzyxnhQfI
The definition of the function which expand columns: https://docs.microsoft.com/en-us/powerquery-m/table-expandrecordcolumn

Does this meet the goal?

1. A. Yes
2. B. No

Correct Answer: A