Answer-first summary for fast verification
Answer: Account usage views contain dropped objects but information schema views do not., Data retention for account usage views is 1 year but is 7 days to 6 months for information schema views, depending on the view.
The correct answers are C and D based on Snowflake documentation and community consensus. Option C is correct because account usage views retain metadata about dropped objects for up to 1 year, while information schema views only show currently existing objects. Option D is correct because account usage views have a 1-year data retention period, whereas information schema views have shorter retention periods ranging from 7 days to 6 months depending on the specific view. Option A is incorrect because both account usage and information schema views can be queried without an active warehouse. Option B is incorrect because both types of views contain data about tables. Option E is incorrect because both types of views are read-only.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
What are the key distinctions between account usage views and information schema views? (Select two.)
A
No active warehouse is needed to query account usage views but one is needed to query information schema views.
B
Account usage views do not contain data about tables but information schema views do.
C
Account usage views contain dropped objects but information schema views do not.
D
Data retention for account usage views is 1 year but is 7 days to 6 months for information schema views, depending on the view.
E
Information schema views are read-only but account usage views are not.
No comments yet.