SOL-C01 Question #255: Real Exam Question with Answer & Explanation

Question

A data analyst wants to schedule a Snowflake Notebook to automatically refresh a dashboard that relies on the results of a complex data transformation pipeline. Which of the following methods are valid ways to schedule the execution of a Snowflake Notebook? (Choose all that apply)

Options

• AUsing the Snowflake Task feature to execute a stored procedure that calls the Snowflake
• BUsing the Snowflake web UI to directly schedule the notebook for periodic execution. Snowflake
• CUsing an external orchestration tool (e.g., Airflow, dbt Cloud) to trigger the execution of the
• DConverting the Snowflake Notebook into a Python script and using the operating system's built-in
• ELeveraging Snowpark Python UDFs to sequentially execute the code cells within the notebook and

Explanation

Snowflake Task with `SYSTEM$EXECUTE NOTEBOOK (A) allows scheduling via stored procedures. External orchestration tools (C) can also trigger Notebook execution via API or CLI. Snowflake does not have a nativeUIscheduling option for notebooks (B). Converting the notebook to a script and using the OS scheduler (D) is possible but complex and less manageable. UDFs can only execute simple tasks; the whole notebook cannot be implemented through UDF's (E).

No community discussion yet for this question.