A manager can represent only a single country.

Microsoft PL-300 Question Answer

You need to use row-level security (RLS) to meet the following requirements:

The managers must only see the data of their respective country.

The number of RLS roles must be minimized.

Which two actions should you perform? Each correct answer presents a complete solution.

NOTE: Each correct selection is worth one point.

Create a single role that filters Country[Manager_Email] by using the USERNAME DAX function.

Create a single role that filters Country[Manager_Email] by using the USEROBJECTID DAX function.

For the relationship between Purchase Detail and Purchase, select Apply security filter in both directions.

Create one role for each country.

For the relationship between Purchase and Purchase Detail, change the Cross filter direction to Single.

Microsoft PL-300 Summary

Price: $52.5 ~~$149.99~~