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

Question

Options

• ANo active warehouse to needed to query account usage views but one is needed to query
• BAccount usage views do not contain data about tables but information schema views do.
• CAccount issue views contain dropped objects but information schema views do not.
• DData retention for account usage views is 1 year but is 7 days to 6 months for information schema
• EInformation schema views are read-only but account usage views are not.

• B
  3% (1)
• C
  92% (34)
• E
  5% (2)

Explanation

The account usage views in Snowflake provide historical usage data about the Snowflake account, and they retain this data for a period of up to 1 year. These views include information about dropped objects, enabling audit and tracking activities. On the other hand, information schema views provide metadata about database objects currently in use, such as tables and views, but do not include dropped objects. The retention of data in information schema views varies, but it is generally shorter than the retention for account usage views, ranging from 7 days to a maximum of 6 months, depending on the specific view.

No community discussion yet for this question.