Answer-first summary for fast verification
Answer: The data latency can vary from 45 minutes to 3 hours., Records for dropped objects are included in each view.
Based on the community discussion and Snowflake documentation references provided, the correct answers are B and E. Option B is correct because ACCOUNT_USAGE views have data latency that can vary from 45 minutes to 3 hours, as documented in Snowflake's official documentation. Option E is correct because ACCOUNT_USAGE views include records for dropped objects, unlike INFORMATION_SCHEMA views. Option A is incorrect because there is data latency. Option C is incorrect because historical data is retained. Option D is incorrect because the retention period is actually up to 1 year, not just 7 days to 6 months.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
What are the key characteristics of ACCOUNT_USAGE views? (Choose two.)
A
There is no data latency.
B
The data latency can vary from 45 minutes to 3 hours.
C
The historical data is not retained.
D
The historical data can be retained from 7 days to 6 months.
E
Records for dropped objects are included in each view.