Snowflake SnowPro Certification Practice Test

True or False: Data Sharing Consumers must use the ACCOUNTADMIN role to create a database based on the share.

1. True

2. False

3. Conditional True

4. Only during certain times

The correct answer is: True

The statement is true because in Snowflake, the ACCOUNTADMIN role has elevated privileges that allow full access to the account's resources. When a data sharing consumer wants to create a database based on a shared data source, they must possess the necessary permissions. The ACCOUNTADMIN role provides these permissions without restrictions. While other roles might also have the capability, the requirement here specifically aligns with the need for the highest level of access to manage and create databases effectively. In contrast, other roles may not have the necessary permissions without further grants or may be limited in the actions they can perform in relation to creating objects based on shared data. Therefore, the assertion that the ACCOUNTADMIN role must be used is accurate, confirming the statement as true.