SnowPro Core Certification — Question 200

Where would a Snowflake user find information about query activity from 90 days ago?

Answer options

• A. account_usage.query_history view
• B. account_usage.query_history_archive view
• C. information_schema.query_history view
• D. information_schema.query_history_by_session view

Correct answer: A

Explanation

The correct answer is A, as the account_usage.query_history view provides data on query activity for the past 90 days. The other options either pertain to different data retention policies or focus on session-specific histories, which do not cover the full 90-day period.