
Answer-first summary for fast verification
Answer: SHOW ORGANIZATION ACCOUNTS HISTORY;
The question asks for a command to list all dropped accounts in an organization that have not been permanently deleted. Based on the community discussion and Snowflake documentation, SHOW ORGANIZATION ACCOUNTS HISTORY (option C) is the correct command. As explained in the discussion, this command specifically includes dropped accounts that are still within their grace period before permanent deletion. Option B (SHOW ORGANIZATION ACCOUNTS) shows an error when executed and redirects to SHOW ACCOUNTS, which may not reliably show dropped accounts. Option A (SHOW MANAGED ACCOUNTS) only shows managed accounts, not all organization accounts. Option D is not a valid Snowflake command. The community discussion shows equal support for B and C, but the detailed reasoning and Snowflake documentation support C as the correct choice for specifically listing dropped accounts.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.