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?

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

Comment: *

Name: *

Email: *

Verification: *

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?

• A.1318
• B.1319
• C.21318 Lasalle Street
• 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

Comment: *

Name: *

Email: *

Verification: *

You have a Power BI model that has the following tables:
Product (Product_id, Product_Name)
Sales (Order_id, Order_Date, Product_id, Salesperson_id, Sales_Amount)
Salesperson (Salesperson_id, Salesperson_name, address)
You plan to create the following measure.
Measure1 = DISTINCTCOUNT(Sales[ProductID])
You need to create the following relationships:
Sales to Product
Sales to Salesperson
The solution must ensure that you can use Measure1 to display the count of products sold by each salesperson.
How should you configure the relationships? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Correct Answer:

Comment: *

Name: *

Email: *

Verification: *

You are creating a Power Bi model in Power BI Desktop
You need to create a calculated table named Numbers that will contain all the integers from -100 to 100. How should you complete the DAX calculation? To answer, select the appropriate options in the answer area.
NOTE Each correct selection is worth one point.

Correct Answer:

Explanation

Comment: *

Name: *

Email: *

Verification: *

You have a dataset that has the permissions shown in the following exhibit.
Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.
NOTE: Each correct selection is worth one point.

Correct Answer:

Explanation
Answer as selected.

Comment: *

Name: *

Email: *

Verification: *