Exam SnowPro Advanced Architect topic 1 question 75 discussion

Correct Answer: C "loadHistoryScan" Snowflake REST API endpoint is rate limited to avoid excessive calls. To help avoid exceeding the rate limit (error code 429), we recommend relying more heavily on insertReport than loadHistoryScan.

Correct answer is C Important This endpoint is rate limited to avoid excessive calls. To help avoid exceeding the rate limit (error code 429), we recommend relying more heavily on insertReport than loadHistoryScan. When calling loadHistoryScan, specify the most narrow time range that includes a set of data loads. For example, reading the last 10 minutes of history every 8 minutes would work well. Trying to read the last 24 hours of history every minute will result in 429 errors indicating a rate limit has been reached. The rate limits are designed to allow each history record to be read a handful of times.

By calling this command repeatedly, it is possible to see the full history of events on a pipe over time. Note that the command must be called often enough to not miss events. Events are retained for a maximum of 10 minutes. https://docs.snowflake.com/en/user-guide/data-load-snowpipe-rest-apis#endpoint-insertreport

Answer should be C. "..To help avoid exceeding the rate limit (error code 429), we recommend relying more heavily on insertReport than loadHistoryScan.." https://docs.snowflake.com/en/user-guide/data-load-snowpipe-rest-apis

C is correct - insertReport should be favored over loadHistory as excessive usage of the latter tends to lead to API throttling