You have a Snowflake Model Registry set up and are managing multiple versions of a machine learning model. You want to programmatically retrieve a specific version of the model and load it for inference within a Snowflake Snowpark Python UDE Assume your registry name is 'my_registry', the model name is 'credit risk_model', and you want to retrieve version 'v2'. How would you achieve this using Snowpark Python?

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

You are tasked with fine-tuning a Snowflake Cortex LLM model using your own labeled dataset to improve its performance on a specific sentiment analysis task related to customer reviews. You have already created a Snowflake stage 'my_stage' and uploaded your labeled data in CSV format to this stage. The labeled data contains two columns: 'review_text' and 'sentiment' (values: 'positive', 'negative', 'neutral'). Which of the following SQL commands, or sequences of commands, is MOST appropriate to initiate the fine-tuning process using the 'SNOWFLAKE.ML.FINETUNE LLM' function? Assume you have already set the necessary permissions for your role to access the model and stage.

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

A retail company, 'GlobalMart,' wants to optimize its product placement strategy in its physical stores. They have transactional data stored in Snowflake, capturing which items are purchased together in the same transaction. They aim to use association rule mining to identify frequently co-occurring items. Given the following simplified transactional data in a Snowflake table named 'SALES TRANSACTIONS:

Which of the following SQL-based approaches, combined with Snowpark Python for association rule generation (using a library like 'mlxtend'), would be the MOST efficient and scalable way to prepare this data for association rule mining, specifically focusing on converting it into a transaction-item matrix suitable for algorithms like Apriori? Assume 'spark' is a 'snowpark.Session' object connected to your Snowflake environment.

• A. Employing a custom UDF (User-Defined Function) written in Java or Scala that directly processes the transactional data within Snowflake and outputs the transaction-item matrix in a format suitable for Snowpark. This offloads processing to compiled code within Snowflake, maximizing performance.
• B. Utilizing Snowflake's SQL function within a stored procedure to concatenate items purchased in each transaction into a string, then processing the string using Python in Snowpark to create the transaction-item matrix. This approach minimizes data transfer but introduces string parsing overhead in Python.
• C. First extracting all the data from snowflake into pandas dataframe and then use pivoting and other pandas operations to convert to the needed format.
• D. Creating a temporary table in Snowflake using a SQL query that aggregates items by transaction and represents them in a format suitable for Snowpark's 'mlxtend' library. Then load this temporary table into a Snowpark DataFrame and use it as input to the Apriori algorithm.
• E. Using Snowpark's 'DataFrame.groupBy(V and functions to aggregate items by transaction ID, then pivoting the data using to create the transaction-item matrix. This approach requires loading all data into the Snowpark DataFrame before pivoting.

You are a data scientist working with a Snowflake table named 'CUSTOMER TRANSACTIONS' that contains sensitive PII data, including customer names and email addresses. You need to create a representative sample of 1% of the data for model development, ensuring that the sample is anonymized and protects customer privacy. The sample must be reproducible for future model iterations.
Which of the following steps are most appropriate using Snowpark for Python and SQL?

• A. Use the 'QUALIFY OVER (ORDER BY RANDOM()) (SELECT COUNT( ) 0.01 FROM CUSTOMER_TRANSACTIONS)' clause with SHA256 on sensitive columns directly within a CREATE TABLE AS statement to generate an anonymized sample. The function should return only 1 percentage of row.
• B. Employ stratified sampling based on a customer segment column, then anonymize data. Use the TABLESAMPLE BERNOULLI function in SQL with a 1 percent sample rate. Apply SHA256 hashing to the 'customer_name' and 'email_addresS columns using SQL functions.
• C. Use Snowpark DataFrame's 'sample' function with a fraction of 0.01 and a fixed random seed. Before sampling, create a view that masks 'customer_name' and 'email_address' columns, and then sample from the view.
• D. Use the 'SAMPLE clause in a SQL query to extract 1% of the rows, then apply SHA256 hashing to the 'customer_name' and 'email_addresS columns within Snowpark using a UDF. Seed the sampling for reproducibility.
• E. Create a new table using 'CREATE TABLE AS SELECT statement combined with 'SAMPLE clause and SHA256 hashing functions in SQL to create the sample and anonymize data. Manually seed the random number generator in Python before executing the SQL statement via Snowpark.

You have deployed a machine learning model in Snowflake to predict customer churn. The model was trained on data from the past year. After six months of deployment, you notice the model's recall for identifying churned customers has dropped significantly. You suspect model decay. Which of the following Snowflake tasks and monitoring strategies would be MOST appropriate to diagnose and address this model decay?

• A. Establish a Snowflake pipe to continuously ingest feedback data (actual churn status) into a feedback table. Write a stored procedure to calculate performance metrics (e.g., recall, precision) on a sliding window of recent data. Create a Snowflake Alert that triggers when recall falls below a defined threshold.
• B. Implement a Shadow Deployment strategy in Snowflake. Route a small percentage of incoming data to both the existing model and a newly trained model. Compare the predictions from both models using a UDF that calculates the difference in predicted probabilities. Trigger an alert if the differences exceed a certain threshold.
• C. Use Snowflake's data sharing feature to share the model's predictions with a separate analytics team. Let them monitor the overall customer churn rate and notify you if it changes significantly.
• D. Create a Snowflake Task that automatically retrains the model weekly with the most recent six months of data. Monitor the model's performance metrics using Snowflake's query history to track the accuracy of the predictions.
• E. Back up the original training data to secure storage. Ingest all new data as it comes in. Retrain a new model and compare its performance with the backed-up training data.