You have an Azure subscription that contains an Azure Synapse Analytics workspace and a user named User1. You need to ensure that User1 can review the Azure Synapse Analytics database templates from…

The correct answer is D. Synapse User. At least Synapse User role permissions are required for exploring a lake database template from Synapse Administrator, or Synapse Contributor permissions are required on the Synapse workspace for creating a lake database. Storage Blob Data Contributor permissions are required…

Submitted by khalil_dz· Mar 30, 2026Secure, monitor, and optimize data storage and data processing

Question

You have an Azure subscription that contains an Azure Synapse Analytics workspace and a user named User1. 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?

Options

AStorage Blob Data Contributor.
BSynapse Administrator
CSynapse Contributor
DSynapse User

How the community answered

(62 responses)

A
2% (1)
B
5% (3)
C
10% (6)
D
84% (52)

Explanation

At least Synapse User role permissions are required for exploring a lake database template from 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

Topics

#Synapse RBAC#Synapse User role#least privilege#database templates gallery

Community Discussion

No community discussion yet for this question.

Full DP-203 Practice