SnowPro Core Certification — Question 712

What are benefits of using Snowpark with Snowflake? (Choose two.)

Answer options

• A. Snowpark uses a Spark engine to generate optimized SQL query plans.
• B. Snowpark automatically sets up Spark within Snowflake virtual warehouses.
• C. Snowpark does not require that a separate cluster be running outside of Snowflake.
• D. Snowpark allows users to run existing Spark code on virtual warehouses without the need to reconfigure the code.
• E. Snowpark executes as much work as possible in the source databases for all operations including User-Defined Functions (UDFs).

Correct answer: C, E

Explanation

The correct answers are C and E because Snowpark allows operations to be performed without needing a separate cluster, thus simplifying the architecture. Additionally, it optimizes performance by executing as much work as possible in the source databases. Options A, B, and D are incorrect because they misrepresent how Snowpark functions in relation to Spark and Snowflake's architecture.