Answer-first summary for fast verification
Answer: Expand the cluster size from X small to 3XL to evaluate performance and choose a size that meets the required SLA.
The correct approach is to increase the cluster size (Scale Up) from 2X-Small to 4XL to review performance and select a size that meets your SLA. This improves query performance by providing additional memory and worker nodes, allowing more tasks to run concurrently in the cluster. The question tests your understanding of scaling a SQL Endpoint (SQL Warehouse), emphasizing the importance of recognizing whether queries run sequentially (scale up) or concurrently (scale out). Scaling up enhances the performance of individual queries by increasing the resources available, such as worker nodes and memory, which can lead to faster query execution times.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
To enhance the performance of a funnel analysis query on an e-commerce platform's customer traffic, which currently takes about 30 minutes to run on a small SQL endpoint cluster with max scaling set to 1 cluster, what steps can be taken?
A
Enable the Serverless feature for the SQL endpoint and adjust the Spot Instance Policy to 'Reliability Optimized'.
B
Modify the Auto Stop feature for the SQL endpoint to extend beyond 30 minutes.
C
Expand the cluster size from X small to 3XL to evaluate performance and choose a size that meets the required SLA.
D
Activate the Serverless feature for the SQL endpoint.
E
Adjust the maximum scaling range of the SQL endpoint from 1 to 100 to assess performance and select an appropriate size for the SLA.
No comments yet.