Exam DP-600 topic 1 question 131 discussion

Actual exam question from Microsoft's DP-600

Question #: 39
Topic #: 1

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 add user objects to the list of synced objects in Microsoft Entra Connect.

Does this meet the goal?

A. Yes
B. No

Show Suggested Answer

Suggested Answer: B 🗳️

by e810eb0 at Nov. 16, 2024, 8:19 a.m.

Comments

Submit Cancel

Mhunity

Highly Voted 5 months, 3 weeks ago

Selected Answer: A

Key Points for Evaluation: The USERNAME() function in Power BI returns the UPN of the logged-in user, which corresponds to the user's identity in Microsoft Entra ID (Azure AD). If the query returns a blank result, it indicates: Either the UPN is not properly synced between AD DS and Microsoft Entra ID. Or the user object is missing from the sync configuration. By adding the user objects to the list of synced objects in Microsoft Entra Connect: The UPNs for the users will be synced from AD DS to Microsoft Entra ID. This ensures that the USERNAME() function can retrieve the UPN correctly. Does the solution meet the goal? Yes. Adding the user objects to the sync configuration in Microsoft Entra Connect ensures that the UPNs are available in Microsoft Entra ID, allowing the USERNAME() function to return the correct result.

upvoted 8 times

...

MultiCloudIronMan

Highly Voted 5 months, 3 weeks ago

Selected Answer: B

To ensure that the measure returns the user principal name (UPN) of a user, you need to make sure that the USERNAME() function is correctly configured to retrieve the UPN. This typically involves ensuring that the UPN is correctly mapped and available in the data model.

upvoted 7 times

...

VojtechSima

Most Recent 1 month, 3 weeks ago

Selected Answer: B

I think it should be No. You should use USERPRINCIPALNAME(), if you want to make sure, you get always UPN.

upvoted 4 times

PradeepikaGadai

1 week, 6 days ago

Absolutely right!

upvoted 1 times

...

joedxb

1 month ago

absolutely right!

upvoted 2 times

...

Stants

5 months, 3 weeks ago

Selected Answer: A

The answer is A: Yes Here's why: The USERNAME() function requirement: USERNAME() returns the UPN of the current user UPN is needed for dynamic RLS to work properly UPN must be available in Microsoft Entra ID Microsoft Entra Connect sync: By default, not all user attributes might be synced User objects need to be explicitly included in sync configuration UPN is a critical attribute for user identification Why this solution works: Adding user objects to sync ensures UPN attributes are synchronized Ensures proper user identity flow from AD DS to Microsoft Entra ID Enables USERNAME() function to retrieve the correct UPN Completes the identity chain needed for dynamic RLS

upvoted 3 times

...

e810eb0

6 months, 1 week ago

Here should be Yes

upvoted 1 times

Ous01

6 months, 1 week ago

Could you please let me know where and how you found the answer?

upvoted 2 times

...