Databricks Certified Data Engineer - Associate
Get started today
Ultimate access to all questions.
Comments
Loading comments...
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.