Snowpro Advanced Architect · Free Practice Question Medium
Question 38
- A SnowSQL
- B JDBC Driver
- C SQL API
- D Snowflake CLI
- E Snowpark
Reveal correct answer
Correct answer: D
Explanation
✅ Snowflake CLI
Explanation:
The Snowflake CLI is the best tool for automating administrative operations in Snowflake, especially within CI/CD pipelines. It provides a broad set of commands for managing storage integrations, external volumes, notifications, and other Snowflake objects.
Designed for automation → Enables scripted execution of administrative tasks, making it ideal for DevOps workflows.
Supports object management → Allows creating, updating, and managing Snowflake objects efficiently.
Integrates with CI/CD → Works seamlessly with GitHub Actions and other automation frameworks.
For more details, check the official Snowflake CLI documentation and GitHub repository for Snowflake CLI automation.
❌ Why the other options are incorrect?
SnowSQL
→ Incorrect, because SnowSQL is primarily used for executing SQL queries, but does not provide extensive automation capabilities.
Snowpark
→ Incorrect, because Snowpark is designed for data processing and machine learning, not administrative automation.
JDBC Driver
→ Incorrect, because JDBC is used for database connectivity, but does not support object management automation.
SQL API
→ Incorrect, because SQL API enables remote query execution, but does not provide full administrative automation.
Discussion
Think the marked answer is wrong, or have a better explanation? Share it below — comments appear after review.
