SnowPro Core Certification — Question 504

What are the main differences between the account usage views and the information schema views? (Choose two.)

Answer options

• 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.

Correct answer: C, D

Explanation

The correct answers are C and D because account usage views track dropped objects, which is not available in information schema views, and they have a longer data retention period of one year compared to the shorter retention period of 7 days to 6 months for information schema views. Options A, B, and E are incorrect as they do not accurately reflect the characteristics of these views.