SnowPro Associate: Platform Question 64
Single answer1.4 Work with Snowflake Notebooks.A data analyst wants to build an interactive prototype in Snowflake Notebooks to explore sales trends. The analyst needs to run SQL queries, use Python for data visualization, and keep all work inside Snowflake without exporting data to an external notebook service. Which Snowflake feature best satisfies this requirement?
- A
Create a Snowflake Notebook that uses SQL and Python cells backed by compute in Snowflake
- B
Use a standard worksheet, because worksheets support mixed SQL and Python cells in the same interactive document
- C
Export the data to a local Jupyter notebook, because Snowflake Notebooks only support SQL
- D
Create a Streamlit in Snowflake app, because Streamlit is the primary notebook authoring environment for mixed-language analysis
Show answer and explanation
Correct answer: A
Explanation
The best answer is to use Snowflake Notebooks. For SnowPro Associate-level knowledge, candidates should recognize that Snowflake Notebooks provide an in-platform, interactive environment for exploratory work using SQL and Python, helping teams analyze and visualize data without moving it outside Snowflake. By contrast, worksheets are more oriented to query and development tasks, and Streamlit in Snowflake is intended for building and sharing data apps rather than authoring notebook-style analysis. This aligns with Snowflake guidance that Notebooks support interactive, cell-based workflows directly on Snowflake-managed compute and data.
- A. Correct.
Correct. Snowflake Notebooks are designed for interactive, exploratory analysis within Snowflake. They support multiple cell types, including SQL and Python, allowing users to query data and build visualizations without moving data outside the platform. This matches the analyst's need to keep work inside Snowflake while combining SQL and Python in one notebook experience.
- B. Incorrect.
Incorrect. Worksheets are useful for SQL development and can support Python in specific contexts, but they are not the notebook-style environment intended for mixed-language, cell-based exploratory analysis and visualization in the same way as Snowflake Notebooks. Choosing this option reflects a common confusion between worksheets and notebooks.
- C. Incorrect.
Incorrect. This is the opposite of the requirement. The analyst specifically wants to avoid exporting data to an external service. In addition, Snowflake Notebooks are not limited to SQL only; they are intended to support interactive analysis workflows that include Python.
- D. Incorrect.
Incorrect. Streamlit in Snowflake is used to build interactive data applications, not as the primary notebook authoring environment for exploratory mixed-language notebook workflows. Someone might choose this option because both Streamlit and Notebooks can support Python-based analysis inside Snowflake, but their purposes are different.