Exam DA-100 topic 8 question 1 discussion

Correct answer is A because username() -> varchar

It can`t be B. Region_Manager Table does not contain a column named: "sales_manager_id".

For answer A: does this work in Power BI service?

A is the right answer. Principle will return email address

I think it's A

answer A exam 7/11/22

Yes A, because it's a varchar, but why not name. It's a varchar to, so why ?

I got it on my exam 03/17/2022. 90-95% questions were from here. 61 questions in 100 min. All 3 case studies that appeared in exam, where from here.

Correct answer is A username = UserName() ---> username = (Domain\User)

on exam 3/1/2022

on exam 12/10/2021

on exam - Nov 11, 2021. my answer: Create a security role that has a table filter on the Sales_Manager table where username = UserName().

On exam 10/14/21

USERNAME Returns the domain and login of the user in the domain\login format. USERPRINCIPALNAME Depending on how the Active Directory was set up, this function usually returns the email address of a user.

The correct answer is A. The suggested answer B is incorrect. Since data type of sales_manager_id is integer while UserPrincipalName() will return the user login email address which is a varchar data type. The where clause in answer B will never works. For the where clause in answer A, Username() will return the login credential in Power BI service, that is the email used to login. This can match with the username in the Sales_Manager table. Similar reason for answer C and D, the where clause will not work too. The only answer that will work is A. Thus, the answer is definitely A.

There is No Sales_Manager table in de study case.

B is indeed correct, for this reason: "Litware uses Azure Active Directory (Azure AD) to authenticate users." When Azure AD is set up, USERPRINCIPALNAME() will return the domain e-mail address