dp-900 Practice Question 1845
Exam: dp-900
Domain: Describe an analytics workload on Azure
Topic: Describe components of a modern data warehouse
Difficulty: medium
Contoso Ltd is migrating its data warehousing solution to Azure Synapse Analytics. They have a large dataset that needs to be processed in parallel and they want to avoid managing any infrastructure. Which component should they use and how does it benefit them?
Answer Options
A
Use Dedicated SQL Pools
B
Use Serverless SQL Pools
C
Use Delta Lake Architecture
D
Use Hybrid Configuration
Correct Answer
B: Use Serverless SQL Pools
Explanation
Serverless SQL pools in Azure Synapse Analytics are ideal for this scenario because they automatically scale resources up and down based on the workload, eliminating the need for manual management of infrastructure.