Databricks Certified Data Engineer Associate — Question 106

An engineering manager uses a Databricks SQL query to monitor ingestion latency for each data source. The manager checks the results of the query every day, but they are manually rerunning the query each day and waiting for the results.

Which of the following approaches can the manager use to ensure the results of the query are updated each day?

Answer options

• A. They can schedule the query to refresh every 1 day from the SQL endpoint's page in Databricks SQL.
• B. They can schedule the query to refresh every 12 hours from the SQL endpoint's page in Databricks SQL.
• C. They can schedule the query to refresh every 1 day from the query's page in Databricks SQL.
• D. They can schedule the query to run every 12 hours from the Jobs UI.

Correct answer: C

Explanation

The correct answer is C because scheduling the query from the query's page specifically allows for daily updates. Options A and B refer to the SQL endpoint's page, which may not have the same functionality, while option D suggests using the Jobs UI, which is not the right context for the query's scheduling in this scenario.