CERTIFIED-DATA-ANALYST-ASSOCIATE Question #16: Real Exam Question with Answer & Explanation

Question

Which of the following statements about a refresh schedule is incorrect?

Options

• AA query can be refreshed anywhere from 1 minute to 2 weeks
• BRefresh schedules can be configured in the Query Editor.
• CA query being refreshed on a schedule does not use a SQL Warehouse (formerly known as SQL
• DA refresh schedule is not the same as an alert.
• EYou must have workspace administrator privileges to configure a refresh schedule

Explanation

Option C is the incorrect statement because scheduled query refreshes do require a SQL Warehouse (formerly SQL Endpoint) to execute - the warehouse is what actually runs the SQL on the scheduled interval. Without a running warehouse, there is no compute to process the query.

Why the distractors are correct (and thus not the answer):

• A is true: Databricks SQL allows refresh intervals ranging from 1 minute up to 2 weeks.
• B is true: the Query Editor UI includes a schedule configuration option directly in the interface.
• D is true: these are distinct features - a refresh schedule re-executes the query periodically, while an alert monitors a query result and triggers a notification when a condition is met.
• E is true: workspace administrator privileges are required to set or modify a refresh schedule.

Memory tip: Think "refresh = re-run = needs compute." Any time a query executes - scheduled or manual - it must have a SQL Warehouse to run on. The word "does not use" in option C is the giveaway that it contradicts how Databricks SQL actually works.

No community discussion yet for this question.