Snowflake SnowPro Associate: Platform Certification SOL-C01 Exam Questions

Answer : B

The Data Exchange feature is not automatically enabled for all Snowflake accounts. Instead, enabling this capability---particularly for private exchanges---typically requires submitting a request toSnowflake Support. Snowflake evaluates account type, region, and compliance requirements before enabling the Data Exchange functionality. Snowflake administrators cannot independently enable this through Snowsight, nor is there a SQL command available to turn it on. Once activated, account administrators can create private exchanges, manage listings, and define which Snowflake accounts can participate. This activation step ensures secure, intentional use of data-sharing capabilities at an account level.

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

Answer : B, C

Amulti-cluster warehouseprovides Snowflake's highest level of concurrency support by allocating multiple compute clusters behind a single warehouse definition. It automatically adds clusters during peak workload to eliminate query queuing and maintain stable performance for dashboards, BI tools, and multi-user environments.

Improved concurrencyis the primary benefit---large numbers of simultaneous queries are distributed across clusters.

Automatic scaling(scaling out and in) ensures compute cost efficiency, as Snowflake adds clusters only when needed and removes them when load decreases.

Incorrect options:

Storage costs are unaffected because compute and storage are independent.

Faster data loading may occur if warehouse size increases, but multi-cluster design is driven by concurrency, not ingestion performance.

The design enables smooth operation in high-demand enterprise environments.

Answer : C

Scalingup or downrefers tovertical scaling, meaning the warehouse's compute size is increased or decreased. For example, moving fromSmall Medium Largeincreases CPU, memory, and I/O capacity, enabling faster processing for compute-intensive workloads.

Vertical scaling improves single-query performance, large ETL jobs, complex joins, or transformations. It does not improve concurrency unless multi-cluster mode is also used.

Horizontal scaling (scaling out/in), by contrast, adjusts thenumber of clustersand is used for concurrency.

Region selection is fixed at account creation and cannot be changed by resizing a warehouse. Storage movement is unrelated to compute rescaling.

Answer : B

TheGET_DDLfunction retrieves the Data Definition Language (DDL) script that was used to create a given object. Executing:

SELECT GET_DDL('TABLE', 'MY_TABLE');

returns the full DDL including column definitions, comments, clustering keys, constraints, masking policies, and other metadata. This makes it essential for schema migration, replication, compliance audits, and environment synchronization.

DESCRIBE TABLEshows only column-level metadata---names, types, nullability---but does not return the full DDL.

SHOW TABLEis not a valid Snowflake command; tables are listed using SHOW TABLES.

INFORMATION_SCHEMA.TABLES lists table metadata, but the provided option ''ABLES'' is invalid and still would not provide DDL even if corrected.

Thus,GET_DDL()is the only method that returns the complete table definition directly.

Answer : B

In Snowflake Notebooks, a Markdown cell is a non-executable cell type used for formatted text. It allows the user to format text using Markdown syntax, including headings, lists, tables, emphasis, inline code, and links. This makes it possible to document the analysis, describe steps, and provide commentary alongside SQL and Python cells, improving clarity and collaboration.

Markdown cells do not execute code in ''more than one computer language''; they are not code cells at all. Notebook cells are not nested; each cell exists as a separate element in the notebook. There is no concept of ''older data'' associated specifically with Markdown cells; they simply store text content defined by the user.

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

Answer : C

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.

Answer : A, C

Snowflake's object hierarchy begins with theaccount, which contains one or moredatabases. Each database can contain multipleschemas, and each schema contains objects such astables,views,stages, and functions. The schema is a logical boundary for grouping related database objects. A schema cannot contain databases, and tables cannot contain schemas. Instead, tables and views are contained within schemas. Therefore, the two correct hierarchical relationships are that a database can contain multiple schemas, and a schema can contain multiple tables and views.

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