Free Access Snowflake.SPS-C01.v2026-07-23.q130 Practice Test (Page 23)

Question 106

You are building a Snowpark application to process sensitive data'. To enhance security, you want to leverage ephemeral sessions. Which configurations, passed to 'snowpark.Session.builder.configS , are required and sufficient to create an ephemeral session? Assume your Snowflake environment is properly configured to allow ephemeral sessions.

A.Only setting the 'role' parameter to a role with appropriate privileges.

B.Setting the 'role' parameter to a role with appropriate privileges and 'database' and 'schema'.

C.Setting the 'role' parameter to a role with appropriate privileges and 'warehouse'.

D.Setting the 'role' parameter to a role with appropriate privileges, 'database', 'schema', and 'warehouse'.

E.Ephemeral sessions do not have specific configurations; they are automatically created by Snowflake when the application connects.

Question 107

You are working with a Snowpark DataFrame 'products df' containing product information, including 'product_id', 'price', and 'discount'. You need to update the 'price' column in the 'products' table based on the following logic: If 'discount' is greater than 0.2, reduce the 'price' by 15%. If 'discount' is between 0.1 and 0.2 (inclusive), reduce the 'price' by 5%. Otherwise, keep the 'price' as is. Which of the following Snowpark code snippets efficiently implements this update? Assume 'products' table already exists and is correctly populated.

A.Option A

B.Option B

C.Option C

D.Option D

E.Option E

Question 108

You are developing a Snowpark application to perform complex data transformations on a large dataset stored in Snowflake. You need to optimize the application's performance. Which of the following strategies are MOST effective for improving performance within Snowpark?

A.Using user-defined functions (UDFs) written in Python for all transformations, regardless of complexity.

B.Leveraging Snowpark's optimized functions and operations whenever possible, even if it requires rewriting some Python code.

C.Materializing intermediate DataFrames aggressively to reduce memory usage.

D.Using the 'collect()' method frequently to retrieve small subsets of data to the client for processing.

E.Taking advantage of Snowpark's lazy evaluation by chaining transformations together before triggering execution with an action like 'collect()' or 'write()'.

Question 109

You have a Snowpark Python application that performs several data transformations on a DataFrame representing customer transactions. The application is experiencing performance issues, and you suspect that some transformations are unnecessarily expensive. Which of the following techniques can MOST effectively optimize the performance of your Snowpark application, specifically focusing on minimizing data movement and leveraging Snowflake's query optimization capabilities?

A.Explicitly call .cache()' on the DataFrame after each transformation to materialize intermediate results in memory.

B.Use User-Defined Functions (UDFs) written in Python for all transformations, regardless of their complexity.

C.Take the dataframe to Pandas dataframe as soon as possible in between transformations, since Pandas dataframes will be faster.

D.Leverage Snowpark's built-in DataFrame transformations (e.g., .groupBy()') to allow Snowflake to optimize the query execution plan. Avoid pulling large amounts of data into the client application for simple operations. Only call 'collect()' as the last and final option, as this is the most costly activity of all.

E.Always use the largest available Snowflake warehouse size to ensure sufficient compute resources.

Question 110

You're working with Snowpark and have a DataFrame 'df containing a column 'json_data' with JSON strings. Some of these JSON strings are invalid. You need to parse the valid JSON strings and extract a field named 'product_id' from them. Invalid JSON strings should result in a 'NULL' value for the extracted 'product_id'. Which of the following approaches is the MOST robust and efficient way to achieve this?