SnowPro Associate: Platform Question 42
Single answer1.3 Describe how to use the Snowsight user interface.A data analyst is new to Snowsight and needs to quickly investigate why a dashboard metric changed overnight. They want to open a worksheet, run a query against a specific warehouse, review the results visually, and then share the worksheet with a teammate for follow-up. Which action in Snowsight best supports this workflow?
- A
Open a SQL worksheet in Snowsight, select the database/schema context and warehouse, run the query, use the built-in results visualization, and share the worksheet with the teammate.
- B
Open Classic Console, create a virtual warehouse monitor, and export query results to a local file before sending them by email.
- C
Use the Data loading page in Snowsight to inspect dashboard calculations, because it is the primary interface for reviewing query logic and visualizing result sets.
- D
Create a stage in Snowsight, upload a file, and use the stage properties page to compare yesterday's and today's metric values.
Show answer and explanation
Correct answer: A
Explanation
This question tests practical use of the Snowsight user interface. For investigative analysis, Snowsight's SQL worksheets are the appropriate tool because they let users choose execution context such as warehouse, database, and schema, run queries, inspect results, and create simple visualizations directly in the UI. Snowsight also supports collaboration features such as sharing worksheets. By contrast, data loading pages and stages are intended for ingestion workflows, and warehouse monitoring is operational rather than a direct replacement for query-based investigation. These behaviors align with Snowflake documentation describing Snowsight worksheets, result exploration, visualizations, and worksheet sharing as core UI capabilities.
- A. Correct.
Correct. In Snowsight, users commonly work in SQL worksheets to write and run queries. They can set the active role, warehouse, database, and schema context, execute SQL, view tabular results, and switch to chart-based visualizations for supported result sets. Snowsight also supports sharing worksheets, which makes it appropriate for collaborative investigation and follow-up.
- B. Incorrect.
Incorrect. Although warehouses can be monitored in Snowflake, creating a warehouse monitor in Classic Console does not address the analyst's immediate need to investigate a metric change through interactive querying and visualization. Exporting to a local file and emailing it is also less aligned with Snowsight's built-in collaborative worksheet capabilities.
- C. Incorrect.
Incorrect. The Data loading area in Snowsight is used for loading data into Snowflake, not as the primary place to inspect dashboard SQL logic or analyze ad hoc query results. A candidate might choose this option because it is a prominent Snowsight feature, but it does not fit the stated workflow.
- D. Incorrect.
Incorrect. Stages are used for file storage and data loading workflows, not for investigating dashboard metrics through SQL analysis. Uploading files and reviewing stage properties would not help the analyst query existing warehouse data and visualize result changes.