SnowPro Advanced: Architect — Question 73

How can the Snowpipe REST API be used to keep a log of data load history?

Answer options

• A. Call insertReport every 20 minutes, fetching the last 10,000 entries.
• B. Call loadHistoryScan every minute for the maximum time range.
• C. Call insertReport every 8 minutes for a 10-minute time range.
• D. Call loadHistoryScan every 10 minutes for a 15-minute time range.

Correct answer: C

Explanation

The correct option, C, specifies calling insertReport every 8 minutes for a 10-minute time frame, which is an effective interval for tracking data loads. Options A and D suggest longer intervals that may miss important data loads, while B proposes a continuous scan that may not efficiently log data load history as needed.