U.S. Independence Day Deal! Unlock 25% OFF Today – Limited-Time Offer - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

Databricks Certified Data Analyst Associate Exam - Topic 3 Question 55 Discussion

A data analyst has set up a SQL query to run every four hours on a SQL endpoint, but the SQL endpoint is taking too long to start up with each run.Which of the following changes can the data analyst make to reduce the start-up time for the endpoint while managing costs?
E) Use a Serverless SQL endpoint A Serverless SQL endpoint is a type of SQL endpoint that does not require a dedicated cluster to run queries. Instead, it uses a shared pool of resources that can scale up and down automatically based on the demand. This means that a Serverless SQL endpoint can start up much faster than a SQL endpoint that uses a cluster, and it can also save costs by only paying for the resources that are used. A Serverless SQL endpoint is suitable for ad-hoc queries and exploratory analysis, but it may not offer the same level of performance and isolation as a SQL endpoint that uses a cluster. Therefore, a data analyst should consider the trade-offs between speed, cost, and quality when choosing between a Serverless SQL endpoint and a SQL endpoint that uses a cluster.Reference:Databricks SQL endpoints,Serverless SQL endpoints,SQL endpoint clusters
A) Reduce the SQL endpoint cluster size
B) Increase the SQL endpoint cluster size
C) Turn off the Auto stop feature
D) Increase the minimum scaling value

Databricks Certified Data Analyst Associate Exam - Topic 3 Question 55 Discussion

Actual exam question for Databricks's Databricks Certified Data Analyst Associate exam
Question #: 55
Topic #: 3
[All Databricks Certified Data Analyst Associate Questions]

A data analyst has set up a SQL query to run every four hours on a SQL endpoint, but the SQL endpoint is taking too long to start up with each run.

Which of the following changes can the data analyst make to reduce the start-up time for the endpoint while managing costs?

Show Suggested Answer Hide Answer
Suggested Answer: E

Contribute your Thoughts:

0/2000 characters

Currently there are no comments in this discussion, be the first to comment!


Save Cancel