You are developing a machine learning model within a Snowflake UDF (User-Defined Function) written in Python. This UDF needs to access external Python libraries not included in the default Snowflake Anaconda channel. You've created a stage and uploaded the necessary file. You've successfully used 'conda create' and 'conda install --file requirements.txt' to create your environment locally, and subsequently zipped the environment. Now, what steps are essential to configure the Snowflake UDF to correctly use these external libraries from the stage? Select all that apply.

• A. Install the packages directly into the Snowflake environment using 'CREATE OR REPLACE FUNCTION RETURNS VARCHAR ..: and a pip install command within the function.
• B. Specify the stage path containing the zipped environment in the 'imports' clause of the 'CREATE OR REPLACE FUNCTION' statement using the symbol and specifying the zip file e.g., '@snowflake_packages/myenv.zip'.
• C. Set the 'PYTHON_VERSION' parameter of the 'CREATE OR REPLACE FUNCTION' statement to match the Python version used in your environment using e.g. 'PYTHON_VERSION = '3.8".
• D. Include the line 'import sys; sys._xoptions['snowflake_home'] = at the top of your UDF to point to the environment stage location.
• E. Create a ZIP file containing the Python environment and upload it to a Snowflake stage.

A pharmaceutical company is testing a new drug to lower blood pressure. They conduct a clinical trial with 200 patients. After treatment, the sample mean reduction in systolic blood pressure is 10 mmHg, with a sample standard deviation of 15 mmHg. You want to construct a 99% confidence interval for the true mean reduction in systolic blood pressure. Which of the following statements is most accurate concerning the appropriate distribution and critical value to use?

• A. Use a t-distribution with 199 degrees of freedom, and the critical value is slightly larger than 2.576.
• B. Use a z-distribution because we are estimating mean, and use a critical value of 1.96.
• C. Use a t-distribution with 200 degrees of freedom, and the critical value is close to 2.576.
• D. Use a z-distribution because the sample size is large (n > 30), and the critical value is approximately 2.576.
• E. Use a chi-squared distribution with 199 degrees of freedom.

You have trained a fraud detection model using scikit-learn and want to deploy it in Snowflake using the Snowflake Model Registry. You've registered the model as 'fraud _ model' in the registry. You need to create a Snowflake user-defined function (UDF) that loads and executes the model. Which of the following code snippets correctly creates the UDF, assuming the model is a serialized pickle file stored in a stage named 'model_stage'?

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

You are tasked with deploying a pre-trained sentiment analysis model hosted externally using AWS SageMaker. The model endpoint requires an API key for authentication, and you want to score customer reviews stored in a Snowflake table named 'CUSTOMER REVIEWS. Which of the following steps are necessary to securely and efficiently integrate this external model with Snowflake, assuming you have already created a Snowflake stage to store secrets?

• A. Use Snowflake's external functions to directly call the SageMaker endpoint from a SQL query, passing the customer review text as input. No separate secure external stage configuration is needed as long as Snowflake has internet access.
• B. Create an external function in Snowflake that invokes the SageMaker endpoint, hardcoding the API key directly into the function definition for simplicity.
• C. Store the API key in an environment variable within the AWS Lambda function (if using API Gateway) that serves as an intermediary between Snowflake and SageMaker. Snowflake calls the API Gateway endpoint which relays the request to the SageMaker endpoint, and no specific configuration is needed on snowflake.
• D. Create a secret object in Snowflake to store the API key. Grant appropriate privileges on the secret to the role that will execute the external function. Modify external function that references secure external stage.
• E. Create an external function in Snowflake that retrieves the API key from a secure Snowflake secret object. Grant USAGE privilege on the secret to the service account associated with the external function.

You are tasked with developing a multi-class image classification model to categorize product images stored in Snowflake external stage. The categories are 'Electronics', 'Clothing', 'Furniture', 'Books', and 'Food'. You plan to use a pre-trained Convolutional Neural Network (CNN) model and fine-tune it using your dataset. However, you're facing challenges in efficiently loading and preprocessing the image data within the Snowflake environment before feeding it to your model. Which of the following approaches would be MOST efficient for image data loading and preprocessing in Snowflake, minimizing data movement and leveraging Snowflake's scalability, for a large dataset exceeding 1 TB of images?

• A. Create a Snowflake Stream to continuously ingest new images into a Snowflake table. Use a task to periodically trigger a Python UDF that preprocesses the newly ingested images and stores them in another table for model training.
• B. Download all the images from the external stage to a local machine, preprocess them using a standard Python library like OpenCV, and then upload the processed data back into Snowflake as a table for model training.
• C. Write a Python User-Defined Function (UDF) that loads each image from the external stage directly into memory, performs preprocessing (resizing, normalization), and returns the processed image data. The UDF is then called in a SQL query to process the image data.
• D. Utilize Snowflake's external function integration with AWS Lambda to preprocess images as they are uploaded to S3, storing the preprocessed data back in S3 and creating an external table pointing to the preprocessed data.
• E. Use Snowflake's Snowpark to read images from the external stage into a Snowpark DataFrame. Then, implement image preprocessing using Snowpark DataFrame operations, such as resizing and normalization, within the DataFrame transformations before sending the data to the model.