Question 10
A curated table should update automatically as its source queries change, subject to a target freshness lag. The proposed response is: Use a dynamic table with an appropriate TARGET_LAG and supported query definition. Which limitation or trade-off should the team acknowledge?
Explanation
Correct Answer
Target lag is an objective, not an absolute guarantee under every workload or source failure. It qualifies the proposed action: use a dynamic table with an appropriate TARGET_LAG and supported query definition.
Incorrect Answers
An integration must be matched to the API usage; a storage integration is not interchangeable. This is a trade-off for the separate proposal: configure an appropriate external access or API integration for the supported call path. The proposed choice instead requires acknowledging this risk: target lag is an objective, not an absolute guarantee under every workload or source failure.
Error inspection is not the same as automatically repairing the source data. This is a trade-off for the separate proposal: use a supported COPY validation approach to inspect load errors without accepting unchecked rows. The proposed choice instead requires acknowledging this risk: target lag is an objective, not an absolute guarantee under every workload or source failure.
A directory table catalogs files rather than extracting every PDF's text automatically. This is a trade-off for the separate proposal: use supported stages and directory-table metadata where the unstructured-file use case calls for it. The proposed choice instead requires acknowledging this risk: target lag is an objective, not an absolute guarantee under every workload or source failure.





SnowPro Core COF-C03 Practice Tests