COF-C02 · Question #604
What is the MINIMUM Snowflake edition that must be used in order to see the ACCESS_HISTORY view?
The correct answer is B. Enterprise. The ACCESS_HISTORY view in the ACCOUNT_USAGE schema is an Enterprise-edition (and above) feature. It records a detailed audit trail of which users accessed which database objects (tables, views, columns) and when, supporting compliance and data governance requirements. Standard…
Question
What is the MINIMUM Snowflake edition that must be used in order to see the ACCESS_HISTORY view?
Options
- AStandard
- BEnterprise
- CBusiness Critical
- DVirtual Private Snowflake (VPS)
How the community answered
(32 responses)- A6% (2)
- B91% (29)
- D3% (1)
Explanation
The ACCESS_HISTORY view in the ACCOUNT_USAGE schema is an Enterprise-edition (and above) feature. It records a detailed audit trail of which users accessed which database objects (tables, views, columns) and when, supporting compliance and data governance requirements. Standard edition (A) does not include ACCESS_HISTORY. Business Critical (C) and VPS (D) also include it, but they are not the minimum required edition - Enterprise is.
Topics
Community Discussion
No community discussion yet for this question.