What is the SNOWFLAKE.ACCOUNT_USAGE view that contains information about which objects were read by queries within the last 365 days (1 year)?
What is the SNOWFLAKE.ACCOUNT_USAGE view that contains information about which objects were read by queries within the last 365 days (1 year)?
The SNOWFLAKE.ACCOUNT_USAGE view that contains information about which objects were read by queries within the last 365 days is named ACCESS_HISTORY. This view includes details about the objects accessed, user who accessed them, the time of access, and the type of access, making it the most appropriate choice for tracking read queries over the past year.
Querying the ACCESS_HISTORY View This Account Usage view can be used to query the access history of Snowflake objects (e.g. table, view, column) within the last 365 days (1 year).
ACCESS_HISTORY
C. ACCESS_HISTORY
The ANSWER is C. ACCESS_HISTORY. The ACCESS_HISTORY view contains information about which objects were accessed (read, written, or updated) by queries within the last 365 days (1 year). This includes information about the user who performed the access, the time of the access, and the object that was accessed.
ideally Two options are correct Access_History and LOGIN_HISTORY. As it has been asked to select any one so going with C https://docs.snowflake.com/en/sql-reference/account-usage.html#account-usage-views
Since asked ”which objects were read by queries ”, so the C must the only one answer.
C is correct answer, there are no views with name views_history and object_history