Answer-first summary for fast verification
Answer: The SHOW MANAGED ACCOUNTS command will view all the reader accounts that have been created for an account.
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.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
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.
No comments yet.