Which command parameter allows scheduling a task with a CRON expression?

• A. SET FIXED_TIME
• B. SET CRON
• C. SET SCHEDULE
• D. USING CRON

Answer: (C)

Scheduling a task is controlled by the SCHEDULE parameter. This is the field that tells Snowflake when the task should run. You can use a fixed interval or a CRON-based schedule, with the CRON expression embedded inside the SCHEDULE value as USING CRON, for example: SCHEDULE = 'USING CRON 0 0 * * *'. Because the timing logic for a task is defined through SCHEDULE, this is the correct parameter to use. The other options aren’t valid parameter names, and USING CRON isn’t a standalone parameter—it’s part of the Schedule value.