Databricks Certified Data Engineer - Associate
Get started today
Ultimate access to all questions.
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?
Real Exam
Community
KKeng
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 1 day from the Jobs UI.
E
They can schedule the query to run every 12 hours from the Jobs UI.
Explanation:
Explanation
In Databricks SQL, there are multiple ways to schedule queries for automatic execution:
Correct Options:
-
Option C (Correct): You can schedule a query to refresh automatically from the query's page in Databricks SQL. This is the most direct approach for SQL queries - you can set up a refresh schedule (daily, hourly, etc.) directly on the query page.
-
Option D (Correct): You can schedule the query to run as a job from the Jobs UI. This approach is more flexible and allows for more complex scheduling, error handling, and integration with other workflows.
-
Option E (Correct): Similar to option D, scheduling every 12 hours from the Jobs UI would also work and would actually update the results twice daily, which meets the requirement of being updated each day.
Incorrect Options:
-
Option A (Incorrect): SQL endpoints don't have scheduling capabilities for queries. SQL endpoints are compute resources for running queries, not for scheduling them.
-
Option B (Incorrect): Same reason as option A - SQL endpoints don't provide query scheduling functionality.
Key Points:
- For simple query scheduling in Databricks SQL, use the scheduling feature on the query page
- For more complex scheduling or integration with other workflows, use Databricks Jobs
- The requirement is to update results each day, so both daily and twice-daily schedules meet this requirement
- SQL endpoints are for compute management, not query scheduling
Comments
Loading comments...