ADA-C01 Question 284
Single answerGenerate and share Snowsight chartsA Snowflake administrator built a Snowsight worksheet that queries monthly revenue by region and created a chart from the query results. The finance team wants to review the chart each month in Snowsight, but they should not be able to modify the worksheet or underlying SQL. The administrator also wants to avoid exporting data outside Snowflake. Which action should the administrator take to meet these requirements?
- A
Share the worksheet directly with the finance team and grant them edit access so they can open the chart in Snowsight
- B
Publish the chart to a dashboard and share the dashboard with the finance team with appropriate access
- C
Download the chart as an image each month and upload it to an internal portal for the finance team
- D
Create a secure data share containing the source table so the finance team can build the chart themselves in their own worksheet
Show answer and explanation
Correct answer: B
Explanation
The best solution is to publish the worksheet chart to a Snowsight dashboard and share that dashboard with the intended audience. Dashboards are designed for presenting and sharing visual query visualizations in Snowsight, while worksheets are primarily for authoring and analysis. When the requirement is to let users consume a chart without changing the worksheet or SQL, dashboards provide the correct abstraction. This also keeps access and visualization inside Snowflake rather than relying on exported files. In Snowflake best practices, administrators should grant the minimum level of access needed and use dashboards for broad consumption of charts created in Snowsight.
- A. Incorrect.
Incorrect. Sharing the worksheet directly would expose the underlying SQL and worksheet contents, and edit access would explicitly allow modification, which violates the requirement that the finance team should not be able to modify the worksheet or SQL. Even if view-only access were considered, the more appropriate Snowsight mechanism for distributing charts to business consumers is a dashboard.
- B. Correct.
Correct. In Snowsight, charts created from worksheet results can be added to dashboards, and dashboards are the intended way to present and share visualizations with other users in Snowflake. This approach keeps consumption inside Snowsight, avoids exporting data, and allows business users to review the chart without granting them the ability to edit the original worksheet SQL.
- C. Incorrect.
Incorrect. Exporting the chart as an image and distributing it through another portal moves the reporting artifact outside Snowflake, which conflicts with the requirement to avoid exporting data outside the platform. It also introduces a manual monthly process and removes the benefit of centralized access in Snowsight.
- D. Incorrect.
Incorrect. A secure data share is used to share database objects, not to distribute a Snowsight chart experience to internal consumers who simply need to view an existing visualization. This option also shifts the burden to the finance team to recreate the chart and exposes more underlying data access than necessary.