COF-C03 Question 11
Single answer1.2 Use Snowflake Interfaces and toolsA data engineering team needs a repeatable way to deploy SQL scripts to Snowflake from a CI/CD pipeline. The pipeline runs non-interactively on a build server, and the team wants command-line automation that can execute SQL files and return exit codes to the pipeline. A developer suggests using Snowsight worksheets because they are easy to use interactively. Which Snowflake interface or tool is the BEST fit for this requirement?
- A
Use Snowsight worksheets, because they are the primary interface for writing and running SQL in Snowflake
- B
Use SnowSQL, because it is a command-line client designed for scripted and automated execution of SQL against Snowflake
- C
Use the Classic Console, because it is intended for browser-based administration and can be embedded directly into CI/CD jobs
- D
Use a Python worksheet in Snowsight, because worksheets are the preferred method for non-interactive production deployments
Show answer and explanation
Correct answer: B
Explanation
The key requirement is non-interactive, repeatable execution of SQL scripts from a build server in a CI/CD pipeline. Among Snowflake interfaces and tools, SnowSQL is the best match because it is a CLI built for scripted access to Snowflake. Snowsight and the Classic Console are browser-based interfaces primarily intended for interactive use. For SnowPro Core, candidates should distinguish between interactive interfaces such as Snowsight and automation-oriented tools such as SnowSQL. This aligns with Snowflake documentation describing SnowSQL as a command-line client for connecting to Snowflake and executing SQL, including from scripts and automated workflows.
- A. Incorrect.
Incorrect. Snowsight worksheets are excellent for interactive exploration, ad hoc SQL, dashboards, and administrative tasks in a web UI, but they are not the best fit for non-interactive CI/CD execution. A pipeline typically needs command-line invocation, script execution, and process exit codes, which are better aligned with SnowSQL.
- B. Correct.
Correct. SnowSQL is Snowflake's command-line client and is well suited for automation scenarios such as CI/CD pipelines, batch execution of SQL files, and scripted administrative tasks. It can run SQL non-interactively and return status information useful to orchestration tools. This matches the requirement for repeatable deployment from a build server.
- C. Incorrect.
Incorrect. The Classic Console is a browser-based interface for using and administering Snowflake, but it is not intended to be embedded into automated CI/CD jobs as the execution mechanism. Browser UIs are designed for interactive use, not command-line pipeline automation.
- D. Incorrect.
Incorrect. Python worksheets in Snowsight are interactive development tools within the web interface. They are useful for development and experimentation, but they are not the preferred mechanism for non-interactive production SQL deployments from a build server. The scenario specifically calls for command-line automation of SQL scripts.