Snowflake Certification Practice Test

True or False: Custom roles can provide users with the ability to create objects across all schemas.

1. True

2. False

3. Only with proper grants

4. Only for ACCOUNTADMIN role

The correct answer is: False

The statement regarding whether custom roles can provide users with the ability to create objects across all schemas is indeed false. Custom roles in Snowflake are designed to grant specific privileges tailored to particular needs, which can include the ability to create objects but are not automatically granted the ability to do so across all schemas. Each schema requires specific grants to allow object creation. Therefore, a custom role would need to have those privileges explicitly defined for each schema where users need to create objects. This means that a user with a custom role can create objects only in schemas where they have been granted the appropriate permissions. Thus, without the explicit grants for all schemas, a custom role does not inherently allow for object creation across all schemas.