dp-900 Practice Question 1846
Exam: dp-900
Domain: Describe an analytics workload on Azure
Topic: Describe components of a modern data warehouse
Difficulty: medium
During a performance review of Azure Synapse Analytics, you notice that the query performance is slow despite having adequate resources. Upon investigation, you find that the queries are running on a Dedicated SQL Pool. What could be the issue and how can it be resolved?
Answer Options
A
Increase the number of nodes in the Dedicated SQL Pool
B
Switch to Serverless SQL Pools
C
Implement Delta Lake architecture
D
Configure hybrid configuration
Correct Answer
B: Switch to Serverless SQL Pools
Explanation
To resolve this, you should consider using the Serverless SQL Pool, which automatically optimizes queries and scales resources based on demand, leading to better performance without manual intervention.