Snowflake Updated SOL-C01 Exam Questions and Answers by cezar

Roles gain access to objects in Snowflake throughdirect privilege grantsor throughinheritancewithin a role hierarchy. A role may be explicitly granted privileges such as SELECT, OWNERSHIP, or USAGE. Alternatively, if a role is assigned to another role, it inherits all privileges of its parent role. Neither network settings nor data storage processes determine role access.

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

The Snowflake Data Cloud allows organizations toseamlessly share, access, and collaborate on dataacross departments and external partners, without copying or moving data. Through secure data sharing, listings, and data clean rooms, Snowflake eliminates data silos and dramatically improves data collaboration.

It does not eliminate the need for governance—Snowflake enhances governance via RBAC, masking policies, and centralized controls. It does not provide access to underlying cloud infrastructure; Snowflake abstracts that. It is not an on-premises solution; Snowflake is fully cloud-native.

Thus, the primary benefit is unifying and securely sharing data across the ecosystem.

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

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.

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

SHOW GRANTS is used to list privileges, including roles assigned to a user.

SHOW GRANTS TO USER reveals all the roles that user inherits.

SHOW ROLES lists roles, SHOW USERS lists users, SHOW DATABASES lists databases—not SHOW GRANTS.

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