Snowflake Certification Practice Test

Can users have access to multiple roles that are all active in every session?

1. True

2. False

3. Depends on the settings

4. Only for admin users

The correct answer is: False

In Snowflake, users cannot have multiple roles active simultaneously within a session. Each user session can have only one active role at a time, although users can switch between roles as needed. This design maintains a clear security model where access rights are defined by the single role that is active, allowing better control over permissions and actions that users can perform. While users may have access to several roles, only one can be active in any particular session, ensuring that the security and access governance provided by the roles are upheld. This restriction plays a crucial role in managing data access and compliance with organizational policies, as it limits the complexity and risk associated with unauthorized access. As a result, the notion that users can have multiple roles active in every session is incorrect.