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

Actual exam question for Databricks's Databricks-Certified-Data-Analyst-Associate exam

Question #: 28
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?

AReduce the SQL endpoint cluster size

BIncrease the SQL endpoint cluster size

CTurn off the Auto stop feature

DIncrease the minimum scaling value

EUse 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

Show Suggested Answer

Suggested Answer: E

A user-defined function (UDF) is a function defined by a user, allowing custom logic to be reused in the user environment1.To apply a UDF to a table, the syntax isSELECT udf_name(column_name) AS alias FROM table_name2. Therefore, option E is the correct way to use the UDFpriceto create a new columncustomer_pricebased on the existing columnscustomer_spendandcustomer_unitsfrom the tablecustomer_summary.Reference:

What are user-defined functions (UDFs)?

User-defined scalar functions - SQL

by Selma at Oct 23, 2024, 12:49 AM

Limited Time Offer

25%

Off

Get Premium Databricks-Certified-Data-Analyst-Associate Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Noelia

2 days ago

Option E looks like the best choice to me. A Serverless SQL endpoint should be able to start up much faster than a cluster-based endpoint, which should help reduce the startup time for the analyst's queries.

upvoted 0 times

...