You have a Snowpark DataFrame named 'products' with columns 'product_id' (INT), 'product_name' (STRING), and 'price' (DOUBLE). You want to apply a transformation to calculate a 'discounted_price' column, which is the 'price' reduced by 10% if the price is greater than $100.00. Which of the following code snippets is the most efficient way to achieve this using Snowpark Python?

• A.
  
• B.
  
• C.
  
• D.
  
• E.
  

A data engineering team is developing a Snowpark application that processes large volumes of JSON data'. They have created a UDF using Python that parses JSON strings and extracts specific fields. They need to deploy this UDF and ensure it can handle malformed JSON without causing the entire Snowpark job to fail. Which of the following strategies BEST addresses both the deployment and error handling requirements?

• A. Create a Python UDF using the 'snowflake-snowpark-python' library and register it in Snowflake. Implement error handling using 'try-except block within the UDF to catch 'json.JSONDecodeError' exceptions and return NULL. Package the Python code as a ZIP file containing any necessary dependencies and upload it to a stage, using the 'imports' clause in the UDF definition.
• B. Create a Python UDF using the 'snowflake-snowpark-python' library and register it in Snowflake. Implement error handling using Snowflake's built-in 'ERROR HANDLING' clause in the 'CREATE FUNCTION' statement. Package the Python code as a ZIP file and upload it to a stage, using the 'imports' clause in the UDF definition.
• C. Create a Python UDF and register it in Snowflake, using 'try-except' block within the UDF to catch 'json.JSONDecodeError' exceptions. Package the Python code with the 'snowflake-snowpark-python' library.
• D. Create a Java UDF instead of Python. Java has better JSON parsing libraries. Upload the JAR file to a stage and register the UDF with 'imports' clause referencing the JAR file. Use try-catch for error handling.
• E. Create an external function pointing to an AWS Lambda function that handles the JSON parsing. Configure the Lambda function to retry on failure, using SNS for notifications. No need to use ZIP file or any 'imports' clause.

A data engineer is developing a Snowpark application using Python and needs to connect to Snowflake. They want to avoid hardcoding credentials directly in the script and utilize environment variables for authentication. Which of the following approaches is the MOST secure and RECOMMENDED way to retrieve Snowflake connection parameters (account, user, password, database, schema, warehouse, role) from environment variables and establish a Snowpark session?

• A. Use the SnowCLl to configure a connection profile, and then reference this profile name when creating the Snowpark session. Ensure each environment variable is also separately available, but are not explicitly called in the code to establish connection but only to set up SnowCLl.
• B. Leverage the 'snowflake.connector.connect()' function with 'os.environ.get()' for credentials and then create a Snowpark session from the connection using Session. builder. from_connection(connectiony.
• C. Utilize the 'Session.builder.getorcreate()' method, assuming that Snowflake connection information (user, password, account, warehouse, etc.) are already set as environment variables with standard names, and let Snowpark automatically infer the parameters.
• D. Manually retrieve each parameter using 'os.environ.get()' and pass them directly into the 'Session.builder.configs()' method.
• E. Store all connection parameters as a JSON string in a single environment variable and parse it within the Snowpark application.

You are tasked with creating a UDTF using Snowpark Python that splits a comma-separated string of customer IDs into individual rows. The input is a string (VARCHAR) and the output should be a table with a single column named 'customer_id' of type INTEGER. Which of the following code snippets CORRECTLY defines and registers the UDTF, ensuring proper data type handling? Assume is a valid Snowpark Session object.

• A.
  
• B.
  
• C.
  
• D.
  
• E.