SnowPro Associate: Platform Question 19
Single answer1.2 Outline the key Snowflake user interfaces.A data engineering team wants different Snowflake users to work in the interface best suited to their tasks. An analyst needs to run ad hoc SQL queries and visualize results in worksheets, while a platform engineer needs to automate administrative tasks such as creating warehouses and managing users from scripts. Which Snowflake user interface combination best fits these requirements?
- A
Use Snowsight for the analyst, and use SnowSQL or the Python Connector for the platform engineer's scripted administration
- B
Use Classic Console for the analyst's worksheet visualizations, and use Streamlit in Snowflake for the platform engineer's scripted administration
- C
Use SnowCD for the analyst's ad hoc SQL work, and use Snowsight for the platform engineer's external automation scripts
- D
Use Snowflake Marketplace for the analyst's worksheets, and use the Web Interface only for the platform engineer's user management scripts
Show answer and explanation
Correct answer: A
Explanation
This question tests whether the candidate can match Snowflake interfaces to realistic job responsibilities. Snowsight is the key web-based Snowflake UI for interactive SQL development, worksheets, monitoring, and visual exploration. By contrast, automation from scripts is typically done with SnowSQL, the Snowflake CLI where applicable, or language connectors/drivers such as the Python Connector. SnowCD is only for connectivity diagnostics, not SQL execution, and Marketplace is for accessing listings rather than day-to-day query work. Snowflake documentation distinguishes between browser-based interfaces like Snowsight and programmatic interfaces such as drivers, connectors, and command-line tools for automation and integration. This aligns with best practice: use interactive web interfaces for human-driven analysis and command-line/programmatic interfaces for repeatable administration and orchestration.
- A. Correct.
Correct. Snowsight is Snowflake's modern web UI and is appropriate for analysts who need worksheets, query execution, and result exploration/visualization. For the platform engineer, scripted automation is better handled through programmatic or command-line interfaces such as SnowSQL or a supported connector like the Python Connector, which can execute SQL commands for administration tasks including creating warehouses and managing users and roles.
- B. Incorrect.
Incorrect. Although the Classic Console historically provided some web-based administration capabilities, it is not the best answer for worksheet visualizations compared with Snowsight, which is the primary modern interface for SQL worksheets and data exploration. Streamlit in Snowflake is for building data applications, not for general scripted platform administration such as automating warehouse and user creation.
- C. Incorrect.
Incorrect. SnowCD is a connectivity diagnostic tool used to validate network connectivity to Snowflake services; it is not an interface for running ad hoc SQL queries. Snowsight is a browser-based UI for interactive work, not the right choice for external automation scripts, which should use APIs, drivers, connectors, SnowSQL, or tools built on them.
- D. Incorrect.
Incorrect. Snowflake Marketplace is used to discover and access data products and applications, not to run worksheets. The web interface can be used interactively for some administrative tasks, but 'user management scripts' require a scripting or programmatic interface rather than only a browser UI.