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

Question

You're using a Snowflake Notebook to collaboratively develop a data pipeline. Several team members are working on the same notebook concurrently. One team member accidentally deletes a cell containing critical data transformation logic. What Snowflake features, accessible within or through the Notebook environment, can be used to recover the lost cell's content and minimize disruption to the workflow? Select TWO correct answers.

Options

• AUse the 'Undo' function within the Snowflake Notebook editor to revert the deletion. If the 'Undo'
• BLeverage the Snowflake Time Travel feature on the underlying table(s) used in the deleted cell's
• CCheck the Snowflake Notebook's version history (if enabled) to revert to a previous version of the
• DExamine the Snowflake query history associated with the notebook session. The SQL statements
• ESince Snowflake Notebooks automatically back up cell contents to a secure cloud storage location,

Explanation

Snowflake Notebook version history (C) is the primary mechanism for reverting to a previous state. The Snowflake query history (D) will contain the SQL commands executed by the cell, allowing for reconstruction of the logic. 'Undo' (A) is limited and may not be sufficient. Time Travel (B) applies to data , not code in the notebook. Snowflake does not automatically back up individual cells for restoration (E).

No community discussion yet for this question.