SnowPro Associate: Platform Question 23
Single answer● SnowsightA data analyst needs to share monthly sales results with business users who do not write SQL. The analyst has already built a chart in Snowsight from a worksheet query and wants the business users to be able to open a single Snowsight page each month to view the latest results. The analyst also wants to minimize repeated manual work. Which Snowsight feature should the analyst use?
- A
Save the worksheet query results to a temporary table and ask users to query that table directly in Snowsight
- B
Add the chart to a dashboard so users can view the visualization in one place
- C
Export the chart as a CSV file from Snowsight each month and upload it to a stage for users to access
- D
Clone the worksheet for each business user so each person has a separate copy of the chart
Show answer and explanation
Correct answer: B
Explanation
The best answer is to use a Snowsight dashboard. Dashboards in Snowsight are intended for sharing visual insights from worksheet results in a way that is accessible to users who may not be writing SQL themselves. This is the most practical option when the goal is a single page that business users can revisit to view updated results with minimal manual effort. By contrast, temporary tables are not suitable for cross-user sharing in this way, CSV exports create extra operational work and lose the native visualization experience, and duplicating worksheets does not scale well for consumption. This aligns with Snowflake documentation and common best practices for using Snowsight worksheets for analysis and dashboards for presenting results to stakeholders.
- A. Incorrect.
Incorrect. Although the analyst could persist data in a table, this does not meet the goal of giving non-SQL business users a simple, single Snowsight page for visualization. It also shifts work to the users, who would need to query or navigate data rather than consume a ready-made visual. Temporary tables are also session-scoped and not appropriate for sharing across users in this scenario.
- B. Correct.
Correct. In Snowsight, dashboards are designed to present charts and tiles in a single consumable interface for viewers. Adding the chart to a dashboard aligns with the requirement to let business users open one page to see the latest results, and it reduces manual effort because the dashboard can reflect the underlying query results rather than requiring a new exported artifact each month.
- C. Incorrect.
Incorrect. Exporting to CSV and uploading to a stage creates unnecessary manual steps and does not provide an interactive Snowsight viewing experience. A CSV is a raw data export, not a dashboard or visualization-first solution for business users.
- D. Incorrect.
Incorrect. Cloning or duplicating worksheets for each user increases maintenance overhead and does not provide a centralized viewing experience. Worksheets are useful for development and analysis, but for broad consumption of visual results in Snowsight, dashboards are the more appropriate feature.