COF-C03 - Snowflake AI Data Cloud Features and Architecture (31% of the exam) - Section 1.3
Identify Snowflake interfaces and tools including Snowsight, the Snowflake CLI and SnowSQL, worksheets, drivers, and connectors.
Identify how users interact with Snowflake: the Snowsight web interface and worksheets, the Snowflake CLI and the SnowSQL command-line client, and the drivers and connectors that applications use. Match a task (ad hoc analysis, scripting, application connectivity) to the appropriate interface.
SnowsightSnowSQLSnowflake CLIworksheetsdrivers and connectors
Practice question for this objective
lock_openFree sampleSnowflake AI Data Cloud Features and Architectureeasy
A data analyst wants a browser-based interface to write SQL in worksheets, view results, and build dashboards and charts without installing anything locally. Which Snowflake interface should the analyst use?
ASnowsight, the web interface reached through a browser where users author worksheets, view query results, and build dashboards and charts with no local installcheck_circle Correct
BSnowSQL, the command-line client that the analyst installs locally to run SQL scripts and that also renders charts and shareable dashboards in a desktop window
CThe Snowflake CLI, a locally installed developer tool for deploying apps and running queries that opens worksheets and dashboards inside a browser tab
DA JDBC driver, the connectivity library that an analyst configures so a browser can open Snowflake worksheets and render the dashboards and charts directly
Identify Snowsight as the browser-based Snowflake web interface offering worksheets, results, and dashboards with charts. Snowsight is Snowflake's web interface, accessed through a browser, where users write SQL in worksheets, inspect results, and build dashboards with visualisations, all without installing client software on their machine.
Why A is correct: Snowsight is the browser-based web interface that provides worksheets, result grids, and dashboards with charts, so it matches every part of the requirement without any local install.
Why B is wrong: SnowSQL is a local command-line client for running SQL, and it does not provide a browser interface or built-in dashboards and charts, so it does not match the request.
Why C is wrong: The Snowflake CLI is a locally installed developer tool focused on app deployment and scripting, and it does not provide browser worksheets or dashboards, so it is wrong here.
Why D is wrong: A JDBC driver is a connectivity library used by applications and tools, not a user interface, so it cannot present worksheets, dashboards, or charts on its own.
Exam traps in Snowflake AI Data Cloud Features and Architecture
Answers that look right on this material and are not. Each one is a distractor from a different question in the COF-C03 bank for this domain.
A worksheet, because the Java application embeds a Snowsight worksheet at runtime to open the connection and run its queries directly against the Snowflake account
errorWhy it is wrong: A worksheet is an interactive editing surface inside Snowsight, not a library an application embeds, so it cannot provide programmatic connectivity for custom code.
The "Classic Console", because it remains the default and recommended browser experience for running worksheets and building dashboards and charts in the Snowflake account
errorWhy it is wrong: The Classic Console is the older web UI that is being phased out and replaced; it is the interface being retired, so it is not the new default and recommended experience.
Snowsight, the browser-based web interface, because its worksheets can be triggered from a terminal to run scheduled SQL scripts and file loads without any interactive session
errorWhy it is wrong: Snowsight is a browser interface meant for interactive use, and it is not invoked from a terminal for scripted scheduled runs, so it does not fit the requirement.