dp-900 Practice Question 1849
Exam: dp-900
Domain: Describe an analytics workload on Azure
Topic: Describe components of a modern data warehouse
Difficulty: medium
Contoso Ltd is facing permission bottlenecks when multiple users need access to their Azure Synapse Analytics environment. They want to ensure that users can only access specific databases and tables. How can they achieve this and what are the benefits of using this approach?
Answer Options
A
Use Dedicated SQL Pools
B
Use Azure Active Directory (AAD) Roles
C
Use Delta Lake Architecture
D
Configure Hybrid Configuration
Correct Answer
B: Use Azure Active Directory (AAD) Roles
Explanation
Contoso Ltd can achieve fine-grained access control by using Azure Active Directory (AAD) roles and permissions within Azure Synapse Analytics, enhancing security and governance.