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

Where would a Snowflake user find information about query activity from 90 days ago?
A . account__usage . query history view
B . account__usage.query__history__archive View
C . information__schema . cruery_history view
D . information__schema – query history_by_ses s i on view

View Answer

Answer: B

Explanation:

To find information about query activity from 90 days ago, a Snowflake user should use the account_usage.query_history_archive view. This view is designed to provide access to historical query data beyond the default 14-day retention period found in the standard query_history view. It allows users to analyze and audit past query activities for up to 365 days after the date of execution, which includes the 90-day period mentioned.

Reference: [COF-C02] SnowPro Core Certification Exam Study Guide

Snowflake Documentation on Account Usage Schema1