Answer: Access_History

The ACCESS_HISTORY view in the Snowflake account usage schema provides detailed information about data access patterns, including which queries accessed specific tables and columns. This makes it the optimal choice for identifying frequently accessed tables by analyzing historical access patterns, query details, and access frequency. The community discussion shows 100% consensus on option A with multiple upvoted comments confirming this is the correct view for this purpose. Other options are less suitable: OBJECT_DEPENDENCIES shows relationships between objects but not access frequency, TABLE_STORAGE_METRICS provides storage information rather than access patterns, and TABLES simply lists table metadata without access history.

Author: LeetQuiz Editorial Team