You are tasked with preparing customer data for a churn prediction model in Snowflake. You have two tables: 'customers' (customer_id, name, signup_date, plan_id) and 'usage' (customer_id, usage_date, data_used_gb). You need to create a Snowpark DataFrame that calculates the total data usage for each customer in the last 30 days and joins it with customer information. However, the 'usage' table contains potentially erroneous entries with negative values, which should be treated as zero. Also, some customers might not have any usage data in the last 30 days, and these customers should be included in the final result with a total data usage of 0. Which of the following Snowpark Python code snippets will correctly achieve this?

• A.
  
• B.
  
• C.
  
• D. None of the above
• E.
  

You are building an image classification model within Snowflake to categorize satellite imagery based on land use types (residential, commercial, industrial, agricultural). The images are stored as binary data in a Snowflake table 'SATELLITE IMAGES. You plan to use a pre-trained convolutional neural network (CNN) from a library like TensorFlow via Snowpark Python UDFs. The model requires images to be resized and normalized before prediction. You have a Python UDF named that takes the image data and model as input and returns the predicted class. What steps are crucial to ensure optimal performance and scalability of the image classification process within Snowflake, considering the volume and velocity of incoming satellite imagery?

• A. Load the entire 'SATELLITE IMAGES table into the UDF for processing, allowing the UDF to handle all image resizing, normalization, and classification tasks sequentially.
• B. Utilize Snowflake's external functions to call an image processing service hosted on AWS Lambda or Azure Functions for image resizing and normalization, then pass the processed images to the 'classify_image' UDF.
• C. Pre-process the images outside of Snowflake using a separate data pipeline and store the resized and normalized images in a new Snowflake table before running the 'classify_image' UDE
• D. Implement image resizing and normalization directly within the 'classify_image' Python UDF using libraries like OpenCV. Ensure the UDF is vectorized to process images in batches and leverage Snowpark's optimized data transfer capabilities.
• E. Use a combination of Snowpark Python UDFs for preprocessing tasks like resizing and normalization, and leverage Snowflake's GPU-accelerated warehouses (if available) to expedite the inference step within the 'classify_image' UDF. Ensure the model weights are efficiently cached.

You've trained a binary classification model in Snowflake to predict loan defaults. You need to understand which features are most influential in the model's predictions for individual loans. Which of the following methods provide insight into model explainability, AND how can they be leveraged within the Snowflake environment? (Select all that apply)

• A. Coefficient analysis: By inspecting the coefficients of a linear model, we can easily determine feature importances.
• B. Permutation Feature Importance: Directly supported within Snowflake ML's model evaluation functions, allowing you to rank features based on their impact on model performance when their values are randomly shuffled.
• C. LIME (Local Interpretable Model-agnostic Explanations): Can be implemented by creating a UDF (User-Defined Function) in Snowflake that takes a loan's feature values as input and returns the feature importance scores for that specific loan, based on the LIME algorithm applied to the model's predictions.
• D. SHAP (SHapley Additive explanations): Similar to LIME, SHAP values can be calculated using a Snowflake UDF, providing a more comprehensive and theoretically grounded explanation of each feature's contribution to the prediction, considering all possible feature combinations.
• E. Decision Tree visualization: Convert the model to decision trees and visualize it.

You are developing a Spark application that needs to read data from a Snowflake table and write the processed data back to a different Snowflake table. Which of the following configurations and code snippets, used in conjunction with the Spark Snowflake Connector, would ensure secure and efficient data transfer, taking into account potential network latency and authentication best practices? Select all that apply.

• A. Configure network timeout parameters in the Spark Snowflake Connector options to handle potential network latency, specifically 'networkTimeoutlnMilliSeconds'. Use 'PREACTIONS' and 'POSTACTIONS' to prepare and finalize data loading. Implement robust error handling to retry failed operations.
• B. Use Snowflake's Key Pair Authentication. Store the private key securely, and configure 'sflJRL', 'sflJser', 'private_key', 'sfDatabase', and 'sfSchema' properties in the Spark configuration. Ensure the user has appropriate Snowflake privileges. Configure 'numPartitions' parameter based on the scale of data to parallelize read and write operations.
• C. Employ Snowflake's OAuth authentication. Obtain an OAuth token and pass it as a parameter to the Spark Snowflake Connector. You need to also provide 'sfDatabase' and 'sfSchemas properties. Don't set the number of partitions, leaving it to Spark's default behavior.
• D. Set 'sfURL', 'sfUser', 'sfPassword', 'sfDatabase', and 'sfSchema' properties in the Spark configuration. Use to read data and to write data. Rely on Snowflake's default JDBC driver settings for network optimization.
• E.