COPY_HISTORY returns load activity for which loading methods?

Unlock all questions

This demo includes only 20 questions. Upgrade to access hundreds of questions, flashcards, exam simulations, and disable ads.

Full question bankExam simulationsFlashcards
From $25.99Unlock all

Master Snowflake Data Engineer Exam. Study with flashcards and multiple choice questions, each question includes hints and explanations. Prepare for your success!

Multiple Choice

COPY_HISTORY returns load activity for which loading methods?

Explanation:
COPY_HISTORY is about data loads into a table from any ingestion path, not just one method. It returns load activity for both manual COPY INTO operations and Snowpipe, giving you a unified view of ingestion events. The data exposed typically includes when the load started and ended, how many rows were loaded, and a load_type field that distinguishes between COPY INTO and Snowpipe. This means you can audit and monitor all ingestion activity from either path in one place. Since it covers both methods, the best answer is that COPY_HISTORY returns load activity for both COPY INTO and Snowpipe.

COPY_HISTORY is about data loads into a table from any ingestion path, not just one method. It returns load activity for both manual COPY INTO operations and Snowpipe, giving you a unified view of ingestion events. The data exposed typically includes when the load started and ended, how many rows were loaded, and a load_type field that distinguishes between COPY INTO and Snowpipe. This means you can audit and monitor all ingestion activity from either path in one place. Since it covers both methods, the best answer is that COPY_HISTORY returns load activity for both COPY INTO and Snowpipe.

More Multiple Choice Questions
Subscribe

Get the latest from Passetra

You can unsubscribe at any time. Read our privacy policy