Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

Salesforce Analytics-Con-301 Exam - Topic 4 Question 17 Discussion

A data analyst sets up a calculation to filter a dashboard so that it displays only the users' information. The dashboard will then be published to Tableau Cloud.The data analyst plans to use the following calculation to filter the data: USERNAME() = [Correct Answer]Which column in the table below should the data analyst reference in the calculation?
B) Email
A) Abbreviated Name
C) Lower case Name

Salesforce Analytics-Con-301 Exam - Topic 4 Question 17 Discussion

Actual exam question for Salesforce's Analytics-Con-301 exam
Question #: 17
Topic #: 4
[All Analytics-Con-301 Questions]

A data analyst sets up a calculation to filter a dashboard so that it displays only the users' information. The dashboard will then be published to Tableau Cloud.

The data analyst plans to use the following calculation to filter the data: USERNAME() = [Correct Answer]

Which column in the table below should the data analyst reference in the calculation?

Show Suggested Answer Hide Answer
Suggested Answer: B

When dashboards are published to Tableau Cloud, the function USERNAME() returns the user's Tableau Cloud username, which is the email address associated with their Tableau Cloud account.

Tableau documentation states:

On Tableau Cloud, the value returned by USERNAME() is always the user's email address.

Row-Level Security (RLS) is typically implemented using a comparison of USERNAME() to an email field in the data source.

For secure filtering, the field compared to USERNAME() must match the authentication identity exactly.

Looking at the provided table:

''Abbreviated Name'' contains short custom codes like ''SMiller,'' which do not match Tableau Cloud usernames.

''Lower Case Name'' contains names like ''sean miller,'' which also do not match Tableau Cloud usernames.

''Email'' contains the full email address for each user, such as ''Sean.Miller@superstore.com,'' which is the only field that corresponds to what USERNAME() returns in Tableau Cloud.

Therefore, the correct field to reference is Email.

Tableau Cloud authentication documentation stating USERNAME() returns the user's email address.

Row-Level Security setup guidance recommending the comparison USERNAME() = [Email Field].

Tableau security practices indicating only the email column will match USERNAME() values on Tableau Cloud.


Contribute your Thoughts:

0/2000 characters
Skye
13 days ago
A) Abbreviated Name seems too vague. Email is definitely better.
upvoted 0 times
...
Marjory
18 days ago
I agree, but C) Lower case Name could work too. It's consistent.
upvoted 0 times
...
Stevie
23 days ago
I think it should be B) Email. It's unique for each user.
upvoted 0 times
...
Jillian
29 days ago
Hmm, I’m not so sure about that. What if the usernames are in a different format?
upvoted 0 times
...
Luther
1 month ago
Totally agree with C, it’s the only one that matches USERNAME().
upvoted 0 times
...
Audrie
1 month ago
Wait, is it really just about case sensitivity?
upvoted 0 times
...
Lashandra
1 month ago
I think B) Email makes more sense.
upvoted 0 times
...
Nu
2 months ago
Gotta go with C) Lower case Name.
upvoted 0 times
...
Kenneth
2 months ago
I recall that USERNAME() often corresponds to the user’s login details. Could it be the Abbreviated Name? That seems plausible.
upvoted 0 times
...
Lemuel
2 months ago
I’m a bit confused. I thought USERNAME() would relate to the Lower case Name, but now I’m not so sure.
upvoted 0 times
...
Ozell
2 months ago
I remember practicing a similar question where we had to match user identifiers. I feel like the Email column might be the right choice here.
upvoted 0 times
...
Cary
2 months ago
I think the USERNAME() function should match the format of the user identifiers in the data. I’m not entirely sure which column that would be though.
upvoted 0 times
...

Save Cancel