Snowflake Updated SOL-C01 Exam Questions and Answers by amaan

The correct SQL command for creating a new database in Snowflake isCREATE DATABASE database_name;. This initializes a new logical container for schemas and objects. USE DATABASE switches the active database context but does not create one. Snowflake does not support the shorthand CREATE DB or USE DB syntax. Therefore, CREATE DATABASE is the correct and only valid command for creating a database.

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

Changing a Snowflake virtual warehouse from Medium to Large increases the compute resources allocated to that warehouse—such as CPU cores, memory, and I/O bandwidth. This process is calledscaling up, or vertical scaling. It is typically performed to improve performance for complex queries, large joins, or computationally heavy workloads.

Scaling down is the reverse—reducing warehouse size from Large to Medium or similar.

Scaling out refers to adding more clusters to a multi-cluster warehouse, enabling increased concurrency rather than increasing power per cluster.

Scaling in is the reverse of scaling out—reducing the number of active clusters.

Thus, increasing the size from Medium to Large is vertical scaling, also known as scaling up.

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

On the Snowsight Schema Details page, one of the supported operations is renaming the schema. The UI exposes controls that allow users with appropriate privileges to change the schema name, which can help maintain consistent naming conventions or reflect project reorganizations.

Sharing data with other accounts is typically done using secure shares at the database or object level, not from a simple “Share this schema” function on the Schema Details page. Truncation is a table-level operation (e.g., TRUNCATE TABLE), not something that applies at the schema level. Metrics visible on the Schema Details page (such as object counts or storage usage) are informational and not directly editable; they are derived from system metadata.

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

SECURITYADMIN manages identity and access control, including creating, modifying, and dropping users and roles.

USERADMIN manages users but lacks full privilege management capability.

SYSADMIN manages object creation.

ACCOUNTADMIN holds full administrative privileges but delegates user/role management to SECURITYADMIN.

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