Data Engineering on Microsoft Azure — Question 116

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

You need to ensure that User1 can create a new lake database by using an Azure Synapse database template from Gallery. The solution must follow the principle of least privilege.

Which role should you assign to User1?

Answer options

• A. Synapse Contributor
• B. Synapse Administrator
• C. Synapse User
• D. Storage Blob Data Contributor

Correct answer: A

Explanation

The Synapse Contributor role is appropriate for User1 as it grants the necessary permissions to create and manage resources within Azure Synapse Analytics, including lake databases. The Synapse Administrator role provides broader permissions than needed, while Synapse User and Storage Blob Data Contributor roles do not include the ability to create databases.