Answer: ACCESS_HISTORY

The ACCESS_HISTORY view (Option B) is specifically designed to track both read and write operations on Snowflake tables and other objects. It captures comprehensive access details including direct_objects_accessed and base_objects_accessed for reads, and objects_modified for write operations like INSERT, UPDATE, DELETE, and COPY. This view retains up to 365 days of history in the ACCOUNT_USAGE schema (Enterprise Edition or higher), making it ideal for auditing and compliance reporting. The community discussion shows 100% consensus on Option B, with detailed confirmation that ACCESS_HISTORY covers both read and write operations, unlike other options: COPY_HISTORY (A) only tracks COPY operations, QUERY_HISTORY (C) focuses on query execution details rather than comprehensive object access tracking, and TASK_HISTORY (D) monitors task executions, not table read/write operations.

Author: LeetQuiz Editorial Team