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, queries can be scheduled to refresh automatically from the query's page itself. This is the most direct and appropriate approach for scheduling a SQL query to refresh on a regular basis.
Key points:
- Query scheduling in Databricks SQL: Queries can be scheduled directly from their individual query pages in Databricks SQL, not from the SQL endpoint page.
- SQL Endpoint vs Query page: SQL endpoints are compute resources for running queries, while individual queries have their own scheduling options.
- Jobs UI alternative: While you could schedule a query to run via the Jobs UI, this is more complex and typically used for more comprehensive workflows rather than simple query refreshes.
- Daily refresh requirement: Since the manager checks results every day, a daily refresh (every 1 day) is appropriate, not every 12 hours.
Why option C is correct:
- Scheduling from the query's page is the standard method for automating query refreshes in Databricks SQL
- It's simpler and more direct than using the Jobs UI
- It matches the daily refresh requirement
Why other options are incorrect:
- A & B: SQL endpoint pages don't provide query scheduling options
- D & E: While possible via Jobs UI, it's not the most direct approach for simple query refreshes
- B & E: 12-hour refresh is unnecessary for daily checking
This approach allows the manager to automate the query execution and have fresh results available daily without manual intervention.
Comments
Loading comments...