ExamTopics Logo
Mail Us[email protected]
Menu
Databricks Discussions
exam questions

Exam Certified Data Engineer Associate All Questions

View all questions & answers for the Certified Data Engineer Associate exam
Go to Exam

Exam Certified Data Engineer Associate topic 1 question 88 discussion

Actual exam question from Databricks's Certified Data Engineer Associate
Question #: 88
Topic #: 1
[All Certified Data Engineer Associate Questions]

A data engineer wants to schedule their Databricks SQL dashboard to refresh every hour, but they only want the associated SQL endpoint to be running when it is necessary. The dashboard has multiple queries on multiple datasets associated with it. The data that feeds the dashboard is automatically processed using a Databricks Job.

Which of the following approaches can the data engineer use to minimize the total running time of the SQL endpoint used in the refresh schedule of their dashboard?

  • A. They can turn on the Auto Stop feature for the SQL endpoint.
  • B. They can ensure the dashboard's SQL endpoint is not one of the included query's SQL endpoint.
  • C. They can reduce the cluster size of the SQL endpoint.
  • D. They can ensure the dashboard's SQL endpoint matches each of the queries' SQL endpoints.
  • E. They can set up the dashboard's SQL endpoint to be serverless.
Show Suggested Answer Hide Answer
Suggested Answer: A 🗳️
by SD5713 at Oct. 21, 2023, 12:21 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
meow_akk
Highly Voted 1 year, 3 months ago
Ans A : the keyword in the question is " running only when its necessary "
upvoted 6 times
...
806e7d2
Most Recent 2 months, 3 weeks ago
Selected Answer: E
By using serverless SQL endpoints, Databricks automatically handles the provisioning and management of compute resources. This approach minimizes the total running time of the SQL endpoint because resources are only allocated when queries are actively running. After the query execution completes, the resources are automatically deallocated, which reduces cost and ensures efficiency. A. They can turn on the Auto Stop feature for the SQL endpoint: This can help reduce idle time, but it does not minimize running time as effectively as serverless SQL endpoints, which start instantly without manual configuration.
upvoted 1 times
...
hussamAlHunaiti
8 months, 1 week ago
Selected Answer: A
Answer is A. The question about minimize the total running times not enhance the performance.
upvoted 1 times
...
Lavpak
1 year, 2 months ago
Selected Answer: A
They can turn on the Auto Stop feature
upvoted 2 times
...
Huroye
1 year, 2 months ago
The correct answer is A. They can use the Auto Stop feature. When the query is idel it will stop the compute
upvoted 3 times
...
SD5713
1 year, 3 months ago
Selected Answer: A
A. They can turn on the Auto Stop feature for the SQL endpoint.
upvoted 3 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago