Exam DP-203 topic 4 question 57 discussion

I found this question on my exam 30/04/2024, and I put D. I passed the exam with a high score, but I'm not sure if the answer is correct.

The Synapse User role is the lowest-privileged role that allows users to view Azure Synapse Analytics database templates from the gallery. This role does not allow users to create or manage databases, but it does allow them to explore and review existing templates Storage Blob Data Contributor: This role allows users to read and write data to Azure Blob Storage. It does not allow users to manage Azure Synapse Analytics databases or templates. Synapse Contributor: This role allows users to create and manage Azure Synapse Analytics databases and artifacts. It is a more powerful role than Synapse User, but it is not necessary for simply viewing database templates. Synapse Administrator: This role has full control over the Azure Synapse Analytics workspace. It is an excessive role for simply viewing database templates.

The Synapse User role is the lowest-privileged role that allows users to view Azure Synapse Analytics database templates from the gallery. This role does not allow users to create or manage databases, but it does allow them to explore and review existing templates Storage Blob Data Contributor: This role allows users to read and write data to Azure Blob Storage. It does not allow users to manage Azure Synapse Analytics databases or templates. Synapse Contributor: This role allows users to create and manage Azure Synapse Analytics databases and artifacts. It is a more powerful role than Synapse User, but it is not necessary for simply viewing database templates. Synapse Administrator: This role has full control over the Azure Synapse Analytics workspace. It is an excessive role for simply viewing database templates.

CHAT GPT Synapse User (Option D): This role is designed for users who need to interact with the Synapse workspace and its resources. It includes permissions to view templates, explore resources, and perform user-level actions without providing excessive administrative privileges.

At least Synapse User role permissions are required for exploring a lake database template from Gallery. Synapse Administrator, or Synapse Contributor permissions are required on the Synapse workspace for creating a lake database. Storage Blob Data Contributor permissions are required on data lake when using the create table From data lake option. https://learn.microsoft.com/en-us/azure/synapse-analytics/database-designer/create-lake-database-from-lake-database-templates

I believe the answer is D. Synapse User as it has less priviledges than contributor. I am unaware what roles can and cant view templates, some one will have to test this. But as you can just google the templates, i assume its the least priveledged role See link showing priveledges: https://learn.microsoft.com/en-us/azure/synapse-analytics/security/synapse-workspace-synapse-rbac-roles#:~:text=Can%20read%20and%20write%20artifacts%0ACan%20view%20saved%20notebook%20and%20pipeline%20output%0ACan%20do%20all%20actions%20on%20Spark%20activities%0ACan%20view%20Spark%20pool%20logs