SnowPro Advanced: Data Engineer — Practice Exam

A Data Engineer builds a Snowpark Python transformation that reads from a source table, joins it to a dimension table, and applies several filters. The script constructs the DataFrame but never calls .show(), .collect(), .save_as_table(), or any other action method. What is true about how Snowflake handles this code?

• A.The transformations execute eagerly on the compute layer and their results are cached on the client side.
• B.No SQL is sent to Snowflake — the DataFrame is a lazy plan that only compiles and executes when an action is invoked.
• C.Joins execute on the driver client while filters push down to Snowflake.
• D.Filters push down but joins wait for an explicit .execute() call.