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

1 years ago

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

upvoted 0 times

...

Velda

1 years ago

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

upvoted 0 times

...

Carmela

1 years ago

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

upvoted 0 times

...

Otis

1 years ago

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

upvoted 0 times

...

Velda

1 years ago

I think I should be assigned the Synapse user role.

upvoted 0 times

...

Lorrie

1 years 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

1 years ago

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

upvoted 0 times

...

Micaela

1 years ago

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

upvoted 0 times

...

Shala

1 years ago

I think User1 should be assigned the Synapse User role.

upvoted 0 times

...

Barrett

1 years 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

1 years 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

1 years 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

1 years 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

1 years 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

1 years ago

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

upvoted 0 times

Carmela

1 years ago

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

upvoted 0 times

...

Carmela

1 years 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

1 years 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

1 years 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

1 years 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

1 years ago

Let's go with Synapse Contributor then.

upvoted 0 times

...

Mabel

1 years ago

Agreed, the principle of least privilege is key here.

upvoted 0 times

...

Merissa

1 years ago

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

upvoted 0 times

...

Gail

1 years ago

What about Synapse Administrator?

upvoted 0 times

...

Brynn

1 years ago

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

upvoted 0 times

...

Rosalind

1 years ago

I think B is the correct option for User1.

upvoted 0 times

...

Renea

1 years 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