Exam PL-300 All Questions

View all questions & answers for the PL-300 exam

Exam PL-300 topic 8 question 2 discussion

Actual exam question from Microsoft's PL-300

Question #: 2
Topic #: 8

You need to provide a solution to provide the sales managers with the required access.
What should you include in the solution?

A. Create a security role that has a table filter on the Sales Manager table where username = UserName().
B. Create a security role that has a table filter on the Sales Manager table where username = sales_manager_id.
C. Create a security role that has a table filter on the Region Manager table where sales_manager_id = UserPrincipalName().
D. Create a security role that has a table filter on the Sales_Manager table where name = UserName().

Show Suggested Answer

Suggested Answer: A 🗳️

by Alexeyvykhodtsev at Oct. 6, 2022, 2:11 a.m.

Comments

Submit Cancel

DataEngDP

Highly Voted 1 year, 4 months ago

GUYS ATTENTION! There were 6-7 new questions, one of them I remember was: Do you have a power BI Report Visual (foto of a visual dashboard report) What can you do to make it color user friendly for visual defficiency? Choose 2 options, options: Sentiment colors, Theme colors, Divergent colors, First-level colors. My answers were: Theme colors and divergent colors. Good luck!

upvoted 25 times

Layla0322

7 months, 1 week ago

My answer is Sentiment colors, divergent colors

upvoted 2 times

...

ivanb94

Highly Voted 2 years, 8 months ago

Well I would agree if a table names Sales Manager (with space) existed, but only the Sales-Manager table exists as written in D so I see no reason why it wouldn't be D. Especially bc the name column used for the USERNAME DAX function in D exists in the table as well.

upvoted 14 times

meswdf4

2 years, 2 months ago

Just passed the exam. There is no typo like shown here. It is written "Sales_Manager" in all options. So it is A.

upvoted 22 times

...

lukelin08

2 years, 8 months ago

Good spotting. Damn Microsoft and weird ambiguous questions

upvoted 6 times

...

jaume

Most Recent 8 months, 2 weeks ago

Selected Answer: A

Filter must be applied to Sales_Manager table as this is the information would be used to filter data (Region details to be picked up through the related tables) and this is discarding option C (moreover we cannot match [sales_manager_id] which is an INTEGER with the result of the USERPRINCIPALNAME() which is teaxt (mail address)) Option B would try to match username (supposedly to be text) with sales_manage_id which is INTEGER, so can also be discarded Remaining options A an D will match UserName() (this is the credentials used by the user to reach access to the report) with [username] or [name] fields from "Sales_Manager" table. Since there are no other details than both are text (VarChar for SQL) fields, we should assume the one matching the result of USERNAME() function is the field using the same name so Option A

upvoted 3 times

...

Koalakueh

1 year, 8 months ago

Is it because we might have repeated names in Sales_Manager[Name] that's why we do not choose D?

upvoted 1 times

...

Shalaleh

2 years, 3 months ago

Selected Answer: A

This time I would go with A :D because there is also username column.

upvoted 2 times

LuluSkyy

9 months, 3 weeks ago

I agree

upvoted 1 times

...

Shalaleh

2 years, 3 months ago

Selected Answer: D

The column that consists the name of managers is "name". so the DAX function should be [name] = USERNAME()

upvoted 1 times

...

Sanatandharma

2 years, 5 months ago

Even I picked up D bcos of the space between Sales Manager.

upvoted 1 times

...

NuriaIzard

2 years, 8 months ago

to Ivan: I just found out in a different website that here is a typo: All four options seem to have the correct table name Sales_Manager, therefore, it is still answer A

upvoted 4 times

...