
Explanation:
The question asks which statement describes how Snowflake supports reader accounts. Option D is definitively correct based on Snowflake documentation and community consensus - the SHOW MANAGED ACCOUNTS command allows providers to view all reader accounts created for their account. Option A is debated in the community but ultimately incorrect because reader accounts are read-only and cannot combine shared data with their own data within Snowflake; while they could theoretically download and combine data externally, this is not how Snowflake 'supports' reader accounts. Option B is incorrect because reader accounts don't require consumers to become licensed Snowflake customers. Option C is incorrect because users in reader accounts cannot perform DML tasks - they have read-only access. The community discussion shows strong support for D (11 upvotes for the definitive answer citing documentation), while A receives mixed opinions but is ultimately not the correct description of how Snowflake supports reader accounts.
Ultimate access to all questions.
No comments yet.
How are reader accounts supported in Snowflake?
A
A reader account can consume data from the provider account that created it and combine it with its own data.
B
A consumer needs to become a licensed Snowflake customer as data sharing is only supported between Snowflake accounts.
C
The users in a reader account can query data that has been shared with the reader account and can perform DML tasks.
D
The SHOW MANAGED ACCOUNTS command will view all the reader accounts that have been created for an account.