SnowPro Associate: Platform Question 32
Single answer● WorksheetsA data analyst is using Snowsight Worksheets to investigate a sales issue. She needs to run several SQL statements one after another, review only the result of a specific statement in the worksheet, and then share the worksheet with a teammate so the teammate can continue editing the same analysis. Which action best meets these requirements?
- A
Run all statements as a single batch, then use the results pane to select the statement result she wants to review, and share the worksheet with edit access
- B
Convert the worksheet to a dashboard, because dashboards are the primary way to share editable SQL analysis with teammates
- C
Save each SQL statement in a separate worksheet, because Snowsight Worksheets cannot display results for individual statements in a multi-statement worksheet
- D
Export the worksheet results to a CSV file and send it to the teammate, because worksheet sharing only supports read-only access
Show answer and explanation
Correct answer: A
Explanation
This question tests practical use of Snowsight Worksheets. Worksheets are designed for interactive SQL development and analysis, including executing multiple statements and reviewing statement-specific results. They also support collaboration by allowing users to share worksheets with others so they can view or continue development, subject to the organization's access controls and object privileges. Best practice is to keep exploratory or iterative SQL work in a worksheet and use sharing when collaboration is needed, rather than exporting static files or converting prematurely to dashboards. This aligns with Snowflake documentation on Snowsight Worksheets and collaboration features.
- A. Correct.
Correct. In Snowsight Worksheets, users can run multiple SQL statements in a worksheet and inspect results for individual statements. Worksheets can also be shared with collaborators, including edit access when appropriate permissions are granted. This directly satisfies the need to execute multiple statements, review a specific statement's output, and let a teammate continue the work.
- B. Incorrect.
Incorrect. Dashboards are used to present and monitor results visually, not as the primary mechanism for collaborative editing of SQL worksheet analysis. Converting to a dashboard would not be the best fit when the teammate needs to continue editing the SQL logic in the worksheet itself.
- C. Incorrect.
Incorrect. A worksheet can contain multiple SQL statements, and Snowsight supports reviewing the results associated with individual statements. Splitting every statement into separate worksheets is unnecessary and reflects a misunderstanding of worksheet behavior.
- D. Incorrect.
Incorrect. Exporting to CSV only shares static output, not the worksheet logic or editable analysis. Also, worksheet sharing is not limited to read-only access; collaborators can be granted permissions that allow continued editing, depending on the sharing model and role privileges.