COF-C02 · Question #27
Where would a Snowflake user find information about query activity from 90 days ago?
The correct answer is B. account__usage.query__history__archive View. NOTE: This question appears to contain an error due to formatting and a nonexistent view name. Option B references 'account_usage.query_history_archive', which does not exist in Snowflake. The actual correct view for querying historical query activity beyond 7 days (up to 365…
Question
Where would a Snowflake user find information about query activity from 90 days ago?
Options
- Aaccount__usage . query history view
- Baccount__usage.query__history__archive View
- Cinformation__schema . cruery_history view
- Dinformation__schema - query history_by_ses s i on view
How the community answered
(35 responses)- A3% (1)
- B94% (33)
- C3% (1)
Explanation
NOTE: This question appears to contain an error due to formatting and a nonexistent view name. Option B references 'account_usage.query_history_archive', which does not exist in Snowflake. The actual correct view for querying historical query activity beyond 7 days (up to 365 days / ~1 year) is SNOWFLAKE.ACCOUNT_USAGE.QUERY_HISTORY (option A). The INFORMATION_SCHEMA.QUERY_HISTORY view (option C) only retains data for approximately 7 days and thus cannot answer queries about activity 90 days ago. For the SnowPro exam, the correct answer for finding query activity from 90 days ago is ACCOUNT_USAGE.QUERY_HISTORY.
Topics
Community Discussion
No community discussion yet for this question.