Which of the following commands cannot be used within a reader account?
Which of the following commands cannot be used within a reader account?
A reader account in Snowflake is designed with read-only access capabilities, meaning it is restricted from performing any actions that would modify the data or metadata. The command CREATE SHARE is used to create a new share, which involves modifying metadata, and thus cannot be used within a reader account. However, commands like ALTER WAREHOUSE, DROP ROLE, SHOW SCHEMAS, and DESCRIBE TABLE can be used as they either query metadata or manage sessions without altering data or metadata directly.
https://docs.snowflake.com/en/user-guide/data-sharing-reader-create.html#what-is-restricted-allowed-in-a-reader-account
A. CREATE SHARE In Snowflake, a reader account is a special type of user account that has read-only access to data in Snowflake. This means that reader accounts can only perform actions that are related to querying data, such as running SELECT statements and viewing metadata. As a result, reader accounts cannot perform actions that modify the data or metadata stored in Snowflake, such as creating new objects, modifying existing objects, or dropping objects. This includes the CREATE SHARE command, which is used to create a new share and make it available to other users. The other commands listed (ALTER WAREHOUSE, DROP ROLE, SHOW SCHEMAS, and DESCRIBE TABLE) are all allowed within reader accounts and can be used to query metadata and data stored in Snowflake.
A is correct (not allowed)
A is correct
Correct