Microsoft Exam DP-203 Topic 7 Question 86 Discussion

Actual exam question for Microsoft's DP-203 exam

Question #: 86
Topic #: 7

You have an Azure subscription that contains an Azure Synapse Analytics workspace and a user named Used.

You need to ensure that User1 can review the Azure Synapse Analytics database templates from the gallery. The solution must follow the principle of least privilege.

Which role should you assign to User1?

ASynapse User

BSynapse Contributor

CStorage blob Data Contributor

DSynapse Administrator

Show Suggested Answer

Suggested Answer: A

by Lonna at Apr 10, 2024, 11:00 PM

Limited Time Offer

25%

Off

Get Premium DP-203 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Coleen

6 months ago

I think assigning the Synapse Contributor role might give User1 more access than necessary. So, I agree with User1.

upvoted 0 times

...

Velda

6 months ago

I see your point, but I think the Synapse user role aligns better with the principle of least privilege.

upvoted 0 times

...

Carmela

6 months ago

But what about the Synapse Contributor role? Wouldn't that also allow User1 to review the database templates?

upvoted 0 times

...

Otis

6 months ago

I agree, the Synapse user role seems to be the most appropriate for reviewing database templates.

upvoted 0 times

...

Velda

6 months ago

I think I should be assigned the Synapse user role.

upvoted 0 times

...

Lorrie

6 months ago

I believe Synapse Contributor might be too much access for just reviewing templates, so I still think Synapse User is the way to go.

upvoted 0 times

...

Jacki

7 months ago

I would go with Synapse Contributor, it might be more appropriate for User1 to have a bit more control.

upvoted 0 times

...

Micaela

7 months ago

I agree with Shala, assigning Synapse User role would provide just enough access for reviewing templates.

upvoted 0 times

...

Shala

7 months ago

I think User1 should be assigned the Synapse User role.

upvoted 0 times

...

Barrett

8 months ago

Yeah, I agree. The Synapse Contributor role would allow User1 to view the templates, but not make any changes or have administrative access. That seems like the best fit.

upvoted 0 times

...

Val

8 months ago

I don't know, you guys. I feel like D) Synapse Administrator would give User1 the broadest access to the Synapse workspace, including the templates. That seems like the safest option to me.

upvoted 0 times

...

Lourdes

8 months ago

I'm leaning towards either B) Synapse Contributor or C) Storage Blob Data Contributor. Those roles seem to align with the requirement of being able to access the database templates.

upvoted 0 times

...

Inocencia

8 months ago

Okay, the key here is to follow the principle of least privilege. We want to give User1 the minimum permissions required to review the database templates.

upvoted 0 times

...

Sophia

8 months ago

Ah, good point! The question specifically mentions Azure Synapse Analytics workspace, so I think C) Storage blob Data Contributor is the better choice here.

upvoted 0 times

...

Glendora

8 months ago

Hmm, this seems like a straightforward question about Azure Synapse roles. Let's think this through carefully.

upvoted 0 times

Carmela

7 months ago

Agreed, it's the best option to ensure least privilege.

upvoted 0 times

...

Carmela

7 months ago

B) Synapse Contributor

upvoted 0 times

...

Hmm, I'm not so sure. Synapse Contributor seems a bit overkill for just viewing templates. Maybe C) Storage blob Data Contributor would be more appropriate since the templates are likely stored in blob storage.

upvoted 0 times

...

Jovita

8 months ago

I think the answer is B) Synapse Contributor. This role allows users to read, write, and delete data in the Synapse workspace, which should be enough for reviewing the templates.

upvoted 0 times

...

Garry

8 months ago

You're right. We need to carefully consider the options and choose the one that allows User1 to access the database templates without giving them unnecessary permissions.

upvoted 0 times

...

Minna

8 months ago

I feel this question is testing our understanding of Azure Synapse Analytics roles and permissions. It's important to identify the right role that aligns with the principle of least privilege.

upvoted 0 times

Kasandra

7 months ago

Let's go with Synapse Contributor then.

upvoted 0 times

...

Mabel

8 months ago

Agreed, the principle of least privilege is key here.

upvoted 0 times

...

Merissa

8 months ago

I don't think we should give User1 more permissions than necessary.

upvoted 0 times

...

Gail

8 months ago

What about Synapse Administrator?

upvoted 0 times

...

Brynn

8 months ago

Yes, I agree. Synapse Contributor should provide just the right level of access.

upvoted 0 times

...

Rosalind

8 months ago

I think B is the correct option for User1.

upvoted 0 times

...

Renea

8 months ago

B) Synapse Contributor

upvoted 0 times

...

Microsoft Exam DP-203 Topic 7 Question 86 Discussion

Contribute your Thoughts:

Coleen

Velda

Carmela

Otis

Velda

Lorrie

Jacki

Micaela

Shala

Barrett

Val

Lourdes

Inocencia

Sophia

Glendora

Carmela

Carmela

Annelle

Jovita

Garry

Minna

Kasandra

Mabel

Merissa

Gail

Brynn

Rosalind

Renea