Question 390
A Python ETL utility needs supported SQL sessions and parameter binding from its runtime. The proposed response is: Use the Snowflake Connector for Python with secure connection settings. Which limitation or trade-off should the team acknowledge?
Explanation
Correct Answer
A Python driver is not the same as Snowpark DataFrame execution inside Snowflake. It qualifies the proposed action: use the Snowflake Connector for Python with secure connection settings.
Incorrect Answers
Target lag is an objective, not an absolute guarantee under every workload or source failure. This is a trade-off for the separate proposal: use a dynamic table with an appropriate TARGET_LAG and supported query definition. The proposed choice instead requires acknowledging this risk: a Python driver is not the same as Snowpark DataFrame execution inside Snowflake.
Creating a task without resuming and monitoring it does not guarantee it will execute. This is a trade-off for the separate proposal: create a Snowflake task with the appropriate schedule or dependency and SQL operation. The proposed choice instead requires acknowledging this risk: a Python driver is not the same as Snowpark DataFrame execution inside Snowflake.
Snowpipe consumes credits and requires monitoring for delivery or file-load failures. This is a trade-off for the separate proposal: use Snowpipe with an appropriate pipe definition and supported file-arrival notification flow. The proposed choice instead requires acknowledging this risk: a Python driver is not the same as Snowpark DataFrame execution inside Snowflake.





SnowPro Core COF-C03 Practice Tests