Answer-first summary for fast verification
Answer: LOOKUPVALUE
The LOOKUPVALUE function in DAX is the most appropriate choice for implementing dynamic row-level security in this scenario. It allows you to return a value from a column based on a condition, which can be used to filter data according to the user's department. This approach is scalable and can easily accommodate new departments without the need for extensive reconfiguration. While USERPRINCIPALNAME can identify the user, it does not directly facilitate row-level security. CALCULATE and EVALUATE are powerful functions but are not specifically designed for implementing row-level security based on user attributes.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
As a Microsoft Fabric Analytics Engineer Associate, you are tasked with implementing dynamic row-level security in a semantic model for a financial services company. The company operates in a highly regulated environment and requires that access to sensitive financial data is strictly controlled based on the user's department. Additionally, the solution must be scalable to accommodate future departments without significant reconfiguration. Which DAX function should you use to create dynamic row-level security that meets these requirements? (Choose one correct answer)
A
LOOKUPVALUE
B
CALCULATE
C
EVALUATE
D
USERPRINCIPALNAME
No comments yet.