Snowflake Updated SOL-C01 Exam Questions and Answers by arjan

Snowflake is best described as anAI Data Cloud Platform. While Snowflake originated as a cloud data warehouse, its capabilities have expanded to include secure data sharing, application development, machine learning workloads, unstructured data processing, Snowpark, and integrated LLM/AI functions (such as Snowflake Cortex and Streamlit). This broad ecosystem supports analytic workloads, governance, multi-cloud architecture, and AI-driven applications. It is not simply an ETL tool or a transactional database.

=======================================

An external stage is the Snowflake object that encapsulates a secure connection to external cloud storage such as Amazon S3, Azure Blob Storage, or Google Cloud Storage. It stores the location (URL or bucket path) and, where required, credentials or role-based access configuration, and may also reference a file format. External stages are used as the source or target for COPY INTO operations when loading from or unloading to external storage.

An external table provides a logical SQL interface to data stored externally but relies on a stage for connectivity; it does not itself define the connection. A directory table exposes metadata about files stored in a stage, not the connection. A named file format defines parsing rules (type, delimiter, compression) but has no knowledge of or connection to a specific external storage location.

==================

TheCloud Services Layeris responsible for Snowflake’s global security, coordination, and metadata management. It orchestrates all authentication and authorization processes, including username/password login, MFA, OAuth, SSO, key-pair authentication, and integration with enterprise identity providers. It also manages role-based access control (RBAC), privilege enforcement, session management, and secure query orchestration.

This layer centralizes encryption policy enforcement, including the management of Snowflake-managed and customer-managed encryption keys (Tri-Secret Secure). While all data stored and transmitted in Snowflake is encrypted by default, it is the Cloud Services Layer that handles the key lifecycle, rotation, and hierarchy.

The Compute Layer only runs queries.

The Storage Layer keeps compressed, encrypted columnar data but does not manage security controls.

The Query Processing Layer executes SQL but does not manage authentication or RBAC.

Thus, the Cloud Services Layer is the authoritative control plane for Snowflake security.

====================================================

Auto-scale enables Snowflake to dynamically start or stop clusters in a multi-cluster warehouse depending on workload pressure. When concurrency rises, Snowflake adds clusters; when demand decreases, it scales back down. This provides seamless performance during peak workloads and efficient resource usage during off-peak times. Auto-scale does not require manual action—it is fully automated once configured. It is not limited to standard warehouses; multi-cluster mode is available in Enterprise Edition and above. Ultimately, auto-scale ensures elasticity and cost-efficient compute allocation.

=======================================