SnowPro Associate: Platform Question 85
Single answer● Visualize data using StreamlitA data analyst needs to build an interactive dashboard directly in Snowflake so business users can explore daily sales by region without exporting data to another BI tool. The analyst wants to use Python code to create charts and simple UI controls, while keeping the data in Snowflake and minimizing external infrastructure. Which Snowflake capability is the best fit for this requirement?
- A
Create a Streamlit in Snowflake app that queries Snowflake tables and renders interactive visualizations in the Snowflake environment.
- B
Use Snowpipe to load the sales data continuously and automatically generate interactive dashboards for end users.
- C
Create a standard SQL view and rely on Snowsight worksheets alone to provide an interactive application experience with Python-based widgets.
- D
Deploy a Java UDF to render charts in query results so users can interact with filters inside SQL output.
Show answer and explanation
Correct answer: A
Explanation
The best answer is Streamlit in Snowflake because it enables developers to build and run interactive data apps natively in Snowflake using Python. This is aligned with the scenario's goals: visualizing Snowflake data, providing user controls, and minimizing external infrastructure. Snowpipe handles ingestion, not visualization. Snowsight worksheets can support query exploration and some charting, but they are not a replacement for a dedicated interactive app built with Streamlit. UDFs extend processing logic, not end-user visualization. Snowflake documentation describes Streamlit in Snowflake as the native way to create and share data applications with Python-based UI and visualizations directly on Snowflake data.
- A. Correct.
Correct. Streamlit in Snowflake is designed for building interactive data applications using Python directly in Snowflake. It allows developers to create UI elements such as selectors and charts while querying data stored in Snowflake, which fits the requirement to keep data in Snowflake and avoid managing separate application infrastructure.
- B. Incorrect.
Incorrect. Snowpipe is used for continuous data ingestion into Snowflake, not for building user-facing dashboards or visual applications. Someone might choose this option because it supports near-continuous updates, but it does not provide visualization or interactive UI capabilities.
- C. Incorrect.
Incorrect. A SQL view can simplify data access, and Snowsight supports worksheets and some visualization features, but worksheets are not the same as a Streamlit app and do not provide the full Python-based interactive application framework described in the scenario. This option reflects the misconception that Snowsight worksheet visuals replace app development.
- D. Incorrect.
Incorrect. Java UDFs in Snowflake are not used to render interactive charts for end users inside SQL query results. UDFs are for extending computation logic, not for building dashboard interfaces. This distractor targets the misconception that database programmability features can substitute for an application UI layer.