Question 300
An event application sends low-latency rows and wants to avoid writing intermediate files to object storage. The proposed response is: Use Snowpipe Streaming through a supported streaming client or integration. Which limitation or trade-off should the team acknowledge?
Explanation
Correct Answer
Streaming ingestion still needs error handling, schema evolution planning and cost monitoring. It qualifies the proposed action: use Snowpipe Streaming through a supported streaming client or integration.
Incorrect Answers
Putting files in a stage does not by itself populate the target table. This is a trade-off for the separate proposal: upload the files to a suitable internal stage and issue COPY INTO the target table. The proposed choice instead requires acknowledging this risk: Streaming ingestion still needs error handling, schema evolution planning and cost monitoring.
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: Streaming ingestion still needs error handling, schema evolution planning and cost monitoring.
A Python driver is not the same as Snowpark DataFrame execution inside Snowflake. This is a trade-off for the separate proposal: use the Snowflake Connector for Python with secure connection settings. The proposed choice instead requires acknowledging this risk: Streaming ingestion still needs error handling, schema evolution planning and cost monitoring.





SnowPro Core COF-C03 Practice Tests