SnowPro Associate: Platform Question 84
Single answer○ Cell execution statusA data engineer is using a Snowflake Notebook to validate a new transformation pipeline. One SQL cell has been running longer than expected after the engineer clicked Run. The engineer wants to know whether the cell is still executing, completed successfully, or failed before deciding whether to investigate the SQL or move to the next step. Which Notebook feature should the engineer rely on to determine the current state of that specific cell?
- A
The cell execution status indicator shown for the individual cell
- B
The warehouse size currently selected for the Notebook session
- C
The Snowsight worksheet folder where the Notebook is saved
- D
The database and schema drop-down values at the top of the Notebook
Show answer and explanation
Correct answer: A
Explanation
This question tests practical use of Snowflake Notebooks in Snowsight. When working in a Notebook, execution status is tracked at the cell level, allowing users to see whether a given cell is running, succeeded, or failed. This is the correct way to assess the state of a specific step in an interactive workflow. Warehouse selection, saved location, and database/schema context may affect execution behavior or organization, but they do not communicate cell execution status. This aligns with Snowflake documentation and product behavior for Notebooks, where users monitor execution directly from the cell's status and output area.
- A. Correct.
Correct. In Snowflake Notebooks, each cell displays an execution status indicator that shows whether the cell is queued/running, completed successfully, or failed. This is the appropriate feature to check when monitoring the progress or outcome of a specific cell.
- B. Incorrect.
Incorrect. Warehouse size can affect performance, but it does not directly indicate whether an individual Notebook cell is currently running, has succeeded, or has failed. A user might choose this option because long runtimes can be related to warehouse capacity, but it is not a status indicator.
- C. Incorrect.
Incorrect. The folder location in Snowsight is only an organizational attribute for saving and finding content. It provides no information about the execution state of a Notebook cell.
- D. Incorrect.
Incorrect. The selected database and schema define object resolution context for SQL statements, but they do not show the execution state of a cell. Someone might pick this if they are thinking about query context rather than execution monitoring.