Answer-first summary for fast verification
Answer: account_usage.query_history view
The correct answer is A (account_usage.query_history view) because it stores query history data for up to 365 days, making it suitable for retrieving information from 90 days ago. The community discussion shows unanimous consensus with 100% of users selecting A and multiple comments referencing the official Snowflake documentation. Option B (query_history_archive) is for data older than 365 days, which is not needed here. Options C and D are from the information_schema, which only provides data for the current session or a limited time window (typically 7 days), making them unsuitable for retrieving 90-day-old query history.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
Which view in Snowflake's Information Schema or Account Usage schema would provide details about query history from 90 days ago?
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