Question 299 - PL-300 discussion

DRAG DROP

You have the Power Bl data model shown in the following exhibit.

You create two row-level security (RlS) roles named Manager and CFO.

You plan to publish the dataset to the Power Bl service.

You need to create DAX expressions for the RLS filters. The solution must meet the following requirements:

• Each manager must see only the data in the Sales and Human Resources tables for their own country.

• The CFO must be prevented from seeing the data in the Human Resources table.

• The CFO must see the sales data of all countries.

How should you complete the DAX expressions to meet the requirements? To answer, drag the appropriate expressions to the correct targets. Each expression may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.

NOTE: Each correct selection is worth one point.

The Country table contains the following data.

You plan to publish the dataset to the Power Bl service.

You need to create DAX expressions for the RLS filters. The solution must meet the following requirements:

• Each manager must see only the data in the Sales and Human Resources tables for their own country.

• The CFO must be prevented from seeing the data in the Human Resources table.

• The CFO must see the sales data of all countries.

How should you complete the DAX expressions to meet the requirements? To answer, drag the appropriate expressions to the correct targets. Each expression may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.

NOTE: Each correct selection is worth one point.