Answer: The COPY_HISTORY function

The COPY_HISTORY function is the correct answer because it specifically provides information about data loading operations, including their status (e.g., Loaded, Load Failed, Partially Loaded) and any associated errors. This is directly supported by the Snowflake documentation links and detailed comments in the community discussion, which highlight that COPY_HISTORY outputs statuses like 'Load in progress', 'Loaded', 'Load failed', 'Partially loaded', or 'Load skipped'. The QUERY_HISTORY function (B) tracks query execution, not data load status. The ACCESS_HISTORY view (C) monitors data access patterns, not load operations. The WAREHOUSE_LOAD_HISTORY function (D) focuses on warehouse performance metrics, not data load errors or partial loads. The community consensus, with 100% agreement and upvoted comments referencing official documentation, confirms that COPY_HISTORY is the optimal choice for monitoring data load status and errors.

Author: LeetQuiz Editorial Team