A data engineer is tasked with removing duplicates from a table named 'USER ACTIVITY' in Snowflake, which contains user activity logs. The table has columns: 'ACTIVITY TIMESTAMP', 'ACTIVITY TYPE', and 'DEVICE_ID. The data engineer wants to remove duplicate rows, considering only 'USER ID', 'ACTIVITY TYPE, and 'DEVICE_ID' columns. What is the most efficient and correct SQL query to achieve this while retaining only the earliest 'ACTIVITY TIMESTAMP' for each unique combination of the specified columns?

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

You have built and deployed a model to predict the likelihood of loan default using Snowpark and deployed as a Snowflake UDF. You are using a separate Snowflake table 'LOAN APPLICATIONS' as input, which contains current applicant data'. After several weeks in production, you observe that the model's accuracy has significantly dropped. The original training data was collected during a period of low interest rates and stable economic conditions. Which of the following strategies are the MOST effective for identifying potential causes of this performance degradation and determining if a model retrain is necessary, in the context of Snowflake?

• A. Compare the distribution of input features in the 'LOAN_APPLICATIONS table to the distribution of the features in the original training dataset using Snowflake's statistical functions (e.g., APPROX_COUNT DISTINCT, &AVG', 'STDDEV'). Significant deviations indicate data drift.
• B. Re-run the original model training code with the 'LOAN_APPLICATIONS table as input and compare the resulting model coefficients to the coefficients of the deployed model. Significant differences indicate model decay.
• C. Regularly sample data from the ' LOAN_APPLICATIONS table and manually compare it to the original training data. This provides a qualitative assessment of potential changes.
• D. Monitor the model's precision and recall using a dedicated monitoring dashboard built on top of the model's predictions and actual loan outcomes (once available). Create a Snowflake alert that triggers when either metric falls below a predefined threshold.
• E. Assume the model is no longer valid due to changing economic conditions and immediately retrain the model with the latest available data without further investigation.

You are working with a large sales transaction dataset in Snowflake, stored in a table named 'SALES DATA'. This table contains columns such as 'TRANSACTION_ID (unique identifier), 'CUSTOMER_ID', 'PRODUCT_ID, 'TRANSACTION_DATE' , and 'AMOUNT'. Due to a system error, some transactions were duplicated in the table. Your goal is to remove these duplicates efficiently using Snowpark for Python. You want to use the 'window.partitionBy()' and functions. Which of the following code snippets correctly removes duplicates based on all columns, while also creating a new column 'ROW NUM' to indicate the row number within each partition?

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

You are developing a regression model in Snowflake using Snowpark to predict house prices based on features like square footage, number of bedrooms, and location. After training the model, you need to evaluate its performance. Which of the following Snowflake SQL queries, used in conjunction with the model's predictions stored in a table named 'PREDICTED PRICES, would be the most efficient way to calculate the Root Mean Squared Error (RMSE) using Snowflake's built-in functions, given that the actual prices are stored in the 'ACTUAL PRICES' table?

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

A data scientist is exploring customer purchase data in Snowflake to identify high-value customer segments. They have a table named 'CUSTOMER TRANSACTIONS with columns 'CUSTOMER ID', 'TRANSACTION_DATE', and 'PURCHASE_AMOUNT'. They want to calculate the interquartile range (IQR) of 'PURCHASE AMOUNT for each customer. Which SQL query using Snowsight is the most efficient and accurate way to calculate and display the IQR for each 'CUSTOMER ID?

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