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

Both statements C and E are factually incorrect based on the fundamental architecture and permission model of Databricks SQL.

Statement C is incorrect because scheduled queries require compute resources to execute. In Databricks SQL, this compute is provided by a SQL Warehouse (formerly SQL Endpoint). The documentation explicitly states that each scheduled execution runs on a selected SQL warehouse.

Statement E is incorrect because configuring a refresh schedule does not require workspace administrator privileges. The required permission is CAN RUN on the query. This allows data analysts and other non-administrator users to manage their own query schedules, which is a core part of the intended workflow.

A. A query can be refreshed anywhere from 1 minute to 2 weeks: This is a correct statement. The scheduling interface in the Query Editor provides options within this exact range.

B. Refresh schedules can be configured in the Query Editor: This is a correct statement. The "Schedule" button to configure the refresh frequency is located at the bottom of the SQL Query Editor UI.

D. A refresh schedule is not the same as an alert: This is a correct statement. A refresh schedule simply re-executes a query. An alert is a separate object that uses a scheduled query to evaluate a condition and trigger a notification.

1. Databricks Documentation

"Schedule a query": This document confirms that scheduled queries run on a SQL warehouse and details the required permissions.

Reference for Answer C: Under the "Schedule a query" section

it states

"Each scheduled execution runs with the query owner’s credential and runs on the SQL warehouse selected in the query."

Reference for Answer E: In the same document

under the "Manage query schedules and permissions" section

it specifies

"To schedule a query

you must have at least CAN RUN permission on the query."

Reference for Answer B: The document's initial instructions state

"To set a schedule for a query

open the query in the SQL editor. Click Schedule at the bottom of the editor."

2. Databricks Documentation

"What are Databricks SQL alerts?": This document clarifies the distinction between alerts and scheduled queries.

Reference for Answer D: It defines alerts as objects that "periodically run queries

evaluate defined conditions

and send notifications if a condition is met

" establishing them as a distinct feature from a simple refresh schedule.

3. Databricks Documentation

"Access control in Databricks SQL": This document provides details on the permission levels for various Databricks SQL objects.

Reference for Answer E: The section on "Query permissions" lists CAN RUN as the permission required to execute a query

which is a prerequisite for scheduling

confirming that workspace administrator privileges are not necessary.