Question 167 of 388
Single answerIn Power BI Desktop, you are building a sales report that contains two tables. Both tables have row-level security (RLS) configured. You need to create a relationship between the tables. The solution must ensure that bidirectional cross-filtering honors the RLS settings.What should you do?
ACreate an active relationship between the tables and select Assume referential integrity.
BCreate an inactive relationship between the tables and select Assume referential integrity.
CCreate an inactive relationship between the tables and select Apply security filter in both directions.
✓DCreate an active relationship between the tables and select Apply security filter in both directions.
✓
Correct Answer: D
Create an active relationship between the tables and select Apply security filter in both directions.
▥
Explanation
The correct answer is highlighted above. Review the wording carefully, then use the next question to continue building your understanding of Microsoft certification topics.