Question 190
A daily data feed lands encrypted objects in a company-managed cloud bucket that Snowflake must read. After implementing the approach, which observation best demonstrates the required outcome?
Explanation
Correct Answer
An authorized stage listing and COPY operation can read the bucket's intended files. This demonstrates the outcome for the stated requirement rather than just a saved configuration.
Incorrect Answers
Refresh history and table contents show the curated results approaching the requested freshness. That measures a different outcome: a curated table should update automatically as its source queries change, subject to a target freshness lag. In this case, verify that an authorized stage listing and COPY operation can read the bucket's intended files.
Task history records completed executions and the target table reflects expected changes. That measures a different outcome: a scheduled SQL transformation must run after fresh landing data is available with operational visibility. In this case, verify that an authorized stage listing and COPY operation can read the bucket's intended files.
A permitted test request reaches only the approved external endpoint. That measures a different outcome: a Snowflake stored procedure must contact an approved external HTTPS service via a managed integration. In this case, verify that an authorized stage listing and COPY operation can read the bucket's intended files.





SnowPro Core COF-C03 Practice Tests