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 133 discussion

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

An engineering manager wants to monitor the performance of a recent project using a Databricks SQL query. For the first week following the project’s release, the manager wants the query results to be updated every minute. However, the manager is concerned that the compute resources used for the query will be left running and cost the organization a lot of money beyond the first week of the project’s release.

Which approach can the engineering team use to ensure the query does not cost the organization any money beyond the first week of the project’s release?

  • A. They can set a limit to the number of DBUs that are consumed by the SQL Endpoint.
  • B. They can set the query’s refresh schedule to end after a certain number of refreshes.
  • C. They can set the query’s refresh schedule to end on a certain date in the query scheduler.
  • D. They can set a limit to the number of individuals that are able to manage the query’s refresh schedule.
Show Suggested Answer Hide Answer
Suggested Answer: C 🗳️
by 9d4d68a at Aug. 26, 2024, 8:06 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
Worldmaster
4 months, 2 weeks ago
Selected Answer: C
C. They can set the query’s refresh schedule to end on a certain date in the query scheduler. This is the best solution. By setting the refresh schedule to automatically stop on a specific date (e.g., one week after the project release), the engineering team ensures that the query will only refresh during the desired period, preventing unnecessary costs after that date. This automated stopping of the refresh process avoids the need for manual intervention after the project’s first week.
upvoted 1 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