SnowPro Advanced: Data Engineer — Question 16

A company has an extensive script in Scala that transforms data by leveraging DataFrames. A Data Engineer needs to move these transformations to Snowpark.
What characteristics of data transformations in Snowpark should be considered to meet this requirement? (Choose two.)

Answer options

• A. It is possible to join multiple tables using DataFrames.
• B. Snowpark operations are executed lazily on the server.
• C. User-Defined Functions (UDFs) are not pushed down to Snowflake.
• D. Snowpark requires a separate cluster outside of Snowflake for computations.
• E. Columns in different DataFrames with the same name should be referred to with squared brackets.

Correct answer: A, B

Explanation

Options A and B are correct because Snowpark allows joining multiple tables using DataFrames and performs operations lazily, optimizing performance by only executing when necessary. Options C, D, and E are incorrect as UDFs can be pushed down to Snowflake, Snowpark does not require a separate cluster for computations, and columns with the same name can be accessed without squared brackets.