SnowPro Associate: Platform Question 86
Single answer● Visualize data using StreamlitA data engineering team wants to give business users an interactive dashboard directly inside Snowflake to explore daily sales by region and product category. The team needs a solution that lets users filter results and view charts without moving data out of Snowflake or managing a separate web application infrastructure. Which approach best meets these requirements?
- A
Build a Streamlit in Snowflake app that queries Snowflake tables and uses Streamlit widgets and charts for interactivity.
- B
Export the sales data to a local CSV file each day and use a desktop BI tool to create interactive charts for users.
- C
Create a Snowflake task that writes aggregated sales results to an internal stage and ask users to download and visualize the files manually.
- D
Use a virtual warehouse only, because warehouses can directly render dashboards for end users without any application layer.
Show answer and explanation
Correct answer: A
Explanation
The best answer is to use Streamlit in Snowflake. Streamlit in Snowflake enables teams to build interactive applications directly within the Snowflake environment using Python and Streamlit components. This is well suited for scenarios where users need filters, charts, and quick exploration of Snowflake data without exporting it or deploying separate infrastructure. In contrast, warehouses only provide compute, tasks provide automation, and staged files or CSV exports do not satisfy the requirement for native interactive visualization. Snowflake documentation for Streamlit in Snowflake emphasizes building data apps that run inside Snowflake and access governed Snowflake data directly, which aligns with security, simplicity, and operational efficiency best practices.
- A. Correct.
Correct. Streamlit in Snowflake is designed for building and running interactive data applications natively in Snowflake. It allows developers to create Python-based apps with widgets such as filters and selectors, and to display charts while querying Snowflake data directly. This approach keeps data in Snowflake and avoids managing separate application infrastructure, which matches the scenario requirements.
- B. Incorrect.
Incorrect. Exporting data to CSV and using a desktop BI tool moves data out of Snowflake and creates manual or external operational dependencies. It also does not provide a centrally managed in-platform interactive experience for business users inside Snowflake.
- C. Incorrect.
Incorrect. Tasks can automate SQL or procedural operations, but they do not provide an interactive user interface for filtering and charting. Writing files to a stage may support downstream processes, but users would still need a separate tool to visualize data.
- D. Incorrect.
Incorrect. A virtual warehouse provides compute resources for executing queries, but it does not by itself create or render dashboards. An application layer such as Streamlit in Snowflake is needed to present interactive visualizations to end users.