Implementing Analytics Solutions Using Microsoft Fabric — Question 132
Note: This section contains one or more sets of questions with the same scenario and problem. Each question presents a unique solution to the problem. You must determine whether the solution meets the stated goals. More than one solution in the set might solve the problem. It is also possible that none of the solutions in the set solve the problem.
After you answer a question in this section, you will NOT be able to return. As a result, these questions do not appear on the Review Screen.
Your network contains an on-premises Active Directory Domain Services (AD DS) domain named contoso.com that syncs with a Microsoft Entra tenant by using Microsoft Entra Connect.
You have a Fabric tenant that contains a semantic model.
You enable dynamic row-level security (RLS) for the model and deploy the model to the Fabric service.
You query a measure that includes the USERNAME() function, and the query returns a blank result.
You need to ensure that the measure returns the user principal name (UPN) of a user.
Solution: You create a role in the model.
Does this meet the goal?
Answer options
- A. Yes
- B. No
Correct answer: B
Explanation
Creating a role in the model does not directly ensure that the measure returns the user principal name (UPN) of a user, which is required. The USERNAME() function relies on the context of the data and the permissions set through RLS, and simply creating a role won't correct the blank result returned by the query.