nerdexam
Databricks

DATABRICKS-CERTIFIED-DATA-ENGINEER-ASSOCIATE · Question #50

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…

The correct answer is C. They can schedule the query to refresh every 1 day from the query's page in Databricks SQL. In Databricks SQL, individual queries can be scheduled to refresh automatically directly from the query's own page. You can set a refresh interval (e.g., every 1 day) so the query reruns on that cadence without manual intervention. This is distinct from the SQL…

Submitted by tunde_lagos· Apr 18, 2026Monitoring and Logging

Question

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?

Options

  • AThey can schedule the query to refresh every 1 day from the SQL endpoint's page in Databricks
  • BThey can schedule the query to refresh every 12 hours from the SQL endpoint's page in
  • CThey can schedule the query to refresh every 1 day from the query's page in Databricks SQL.
  • DThey can schedule the query to run every 1 day from the Jobs UI.
  • EThey can schedule the query to run every 12 hours from the Jobs UI.

How the community answered

(26 responses)
  • B
    4% (1)
  • C
    92% (24)
  • E
    4% (1)

Explanation

In Databricks SQL, individual queries can be scheduled to refresh automatically directly from the query's own page. You can set a refresh interval (e.g., every 1 day) so the query reruns on that cadence without manual intervention. This is distinct from the SQL endpoint/warehouse page (which manages compute, not query schedules) and from the Jobs UI (which is designed for notebook/pipeline jobs, not SQL queries). Scheduling from the query's page in Databricks SQL is the correct location and mechanism for this use case.

Topics

#Databricks SQL#Query Scheduling#Data Monitoring#Automation

Community Discussion

No community discussion yet for this question.

Full DATABRICKS-CERTIFIED-DATA-ENGINEER-ASSOCIATE Practice