Which of the following commands cannot be used within a reader account?

The correct answer is A. CREATE SHARE. A Snowflake reader account is a limited-privilege account provisioned by a data provider to allow data consumers who do not have their own Snowflake accounts to query shared data. Reader accounts are strictly consumers-they can query data shared with them but cannot create or…

Data Protection and Data Sharing

Question

Options

ACREATE SHARE
BALTER WAREHOUSE
CDROP ROLE
DSHOW SCHEMAS
EDESCRBE TABLE

How the community answered

(27 responses)

A
93% (25)
B
4% (1)
E
4% (1)

Explanation

A Snowflake reader account is a limited-privilege account provisioned by a data provider to allow data consumers who do not have their own Snowflake accounts to query shared data. Reader accounts are strictly consumers-they can query data shared with them but cannot create or manage data-sharing objects themselves. CREATE SHARE (A) is the command used to create a new data share object, which is a provider-side action. Reader accounts are explicitly prohibited from creating shares because they are consumers, not providers. Commands like ALTER WAREHOUSE (B), DROP ROLE (C), SHOW SCHEMAS (D), and DESCRIBE TABLE (E) may have varying levels of restriction, but CREATE SHARE is the operation that is categorically disallowed in a reader account by design.

Topics

#Reader Accounts#Data Sharing#SQL Commands#Account Capabilities

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice