Answer-first summary for fast verification
Answer: Expand the cluster size of the SQL endpoint.
The correct approach is to increase the cluster size of the SQL endpoint. Since the queries are running sequentially, adding more clusters won't enhance performance. Instead, enlarging the cluster size allows the use of additional compute resources in a warehouse, thereby improving performance. It's crucial to distinguish between scaling up (increasing cluster size for better single query performance) and scaling out (adding more clusters for higher throughput with concurrent queries). In scenarios where queries run sequentially, scaling up is the recommended solution.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
The data analyst team has developed queries to identify out-of-stock items based on orders and replenishment data. However, when these queries are executed together for the final output, the process takes an unusually long time. Upon investigation, you notice that all queries run sequentially using a SQL endpoint cluster. Which of the following steps would effectively address this performance issue?
A
Enable the Serverless feature for the SQL endpoint.
B
Adjust the Spot Instance Policy to 'Reliability Optimized' and enable the Serverless feature for the SQL endpoint.
C
Expand the cluster size of the SQL endpoint.
D
Activate the Auto Stop feature for the SQL endpoint.
E
Raise the maximum limit of the SQL endpoint’s scaling range.
