Microsoft Certified Azure Data Engineer Associate · Free Practice Question Medium
Question 12
True or False: When using Azure Synapse Analytics, the preferred method for loading data is to use the service administrator account as this ensures the required permissions are available to write the content to the appropriate destinations. Lesser accounts run the risk of failure due to permission restrictions.
-
A
False
-
B
True
Reveal correct answer
Correct answer: A
Explanation
A mistake that many people make when first exploring dedicated SQL Pools are to use the service administrator account as the one used for loading data. This account is limited to using the smallrc dynamic resource class that can use between 3% and 25% of the resources depending on the performance level of the provisioned SQL Pools.
Instead, it’s better to create specific accounts assigned to different resource classes dependent on the anticipated task. This will optimize load performance and maintain concurrency as required by managing the available resource slots available within the dedicated SQL Pool.
A. False. Using the service administrator account for loading data in Azure Synapse Analytics is not the preferred method. It is recommended to follow the principle of least privilege and assign specific roles and permissions to users or service principals based on their required tasks. This approach enhances security and reduces the risk of unauthorized access or accidental data modifications.
B.
It is important to assign appropriate roles and permissions to users or service principals in Azure Synapse Analytics to ensure data security and compliance. Using the service administrator account for all data loading tasks can lead to potential security risks and data integrity issues. It is best practice to grant minimal necessary permissions to users based on their specific job roles and responsibilities.
Discussion
Think the marked answer is wrong, or have a better explanation? Share it below — comments appear after review.
