You have a Snowpark DataFrame called 'employee_data' with columns 'employee_id', 'department' , 'salary' , and 'hire date'. You need to perform the following transformations: 1. Calculate the average salary for each department. 2. For each employee, determine their salary relative to the average salary of their department (salary - average department salary). 3. Filter out employees whose salary is below the average salary for their department. 4. Display the 'employee_id', 'department' , 'salary' , and the salary difference from the average department salary. Which of the following represents a correct and efficient Snowpark implementation?

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

You are tasked with processing a Snowpark DataFrame named 'orders df that contains order information. The DataFrame includes the following columns: 'order _ id' (INTEGER), 'customer_id' (INTEGER), 'order_date' (DATE), 'order_total' (STRING), and 'discount_code' (STRING). The 'order_total' column contains values with leading dollar signs and commas (e.g., '$1 ,234.56'). The column can contain codes like 'SAVEIO', 'SAVE20', or be NULL. Your goal is to create a new DataFrame 'transformed_df that includes the following transformations: 1 . Convert the 'order_total' column to a numeric value (DOUBLE) after removing the dollar signs and commas. 2. Apply a discount based on the 'discount_code'. If the 'discount_code' is 'SAVEIO', apply a 10% discount; if it's 'SAVE20', apply a 20% discount. If the 'discount_code' is NULL or any other value, apply no discount (0%). 3. Calculate the 'final_total' after applying the discount. Which of the following code snippets correctly and efficiently implements these transformations using Snowpark?

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

You have a Snowpark DataFrame with columns 'product_id', 'customer_id', and 'sale_amount'. Some values are negative, indicating returns, and others are null. You need to replace negative values with 0 and fill null values with the average 'sale_amount' for each 'product_id'. Which of the following approaches is the MOST efficient and correct way to achieve this using Snowpark?

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

You are tasked with processing a large number of PDF files stored in an external stage named Each PDF contains scanned receipts, and you need to extract the total amount from each receipt. You plan to use Snowpark Python, SnowflakeFile object, and an OCR (Optical Character Recognition) library for text extraction. Assuming you have already set up the connection and session, what is the most efficient and secure way to read and process these PDF files using Snowpark and SnowflakeFile, minimizing data transfer and maximizing parallelism?

• A. Use 'session.read.option('PATTERN', ' to load the PDF files as binary data into a Snowpark DataFrame. Then, define a UDF that takes the binary data as input, converts it to a 'SnowflakeFile' object within the UDF, performs OCR, and extracts the amount.
• B. List all files in the stage using 'session.sql('LlST iterate through the results, create a 'SnowflakeFile' object for each file path, download each file using 'SnowflakeFile.get' into the client machine, perform OCR, extract the amount, and create a Snowpark DataFrame with the extracted amounts.
• C. Create a UDF that accepts a 'SnowflakeFile' object as input, performs OCR and amount extraction inside the UDF, and then call this UDF on a Snowpark DataFrame representing the files in the stage. Use 'session.read.option('PATTERN', ' to generate the initial DataFrame.
• D. Read all PDF files into a Pandas DataFrame, then iterate through the DataFrame, downloading each file using 'SnowflakeFile.gef , perform OCR, extract the amount, and finally create a Snowpark DataFrame with the extracted amounts.
• E. Define an external function that takes the path to a file on the stage as input, performs OCR using a cloud-based OCR service and stores the result in an intermediate database table, then create a Snowpark DataFrame to query extracted amounts. Use 'session-read-option('PATTERN', ' to generate the initial DataFrame.

Consider the following scenario: You need to implement a UDF in Snowpark Python to calculate the distance between two geographical coordinates (latitude and longitude). The UDF should handle potential null values gracefully and return null if either input coordinate is null. Which code snippet demonstrates the MOST efficient and correct implementation, leveraging Snowpark's capabilities?

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