SnowPro Core Certification — Question 1006

What should be used to show the status of partial data loads and loading errors?

Answer options

• A. The COPY_HISTORY function
• B. The QUERY_HISTORY function
• C. The ACCESS_HISTORY view
• D. The WAREHOUSE_LOAD_HISTORY function

Correct answer: A

Explanation

The COPY_HISTORY function is designed specifically to track and report on the status of data loads, including any errors that may have occurred during the process. The other options, such as QUERY_HISTORY and ACCESS_HISTORY, focus on different aspects of database activity and do not provide details on loading errors or partial data loads.