Snowflake DSA-C03 Value Pack (Frequently Bought Together)

You are building a model to predict loan defaults using data stored in Snowflake. As part of your feature engineering process within a Snowflake Notebook, you need to handle missing values in several columns: 'annual _ income', and You want to use a combination of imputation strategies: replace missing values with the median, 'annual_income' with the mean, and with a constant value of 0.5. You are leveraging the Snowpark DataFrame API. Which of the following code snippets correctly implements this imputation strategy?

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

You are analyzing sales data in Snowflake using Snowpark to identify seasonality. You have a table named 'SALES DATA with columns 'SALE DATE (TIMESTAMP NTZ) and 'AMOUNT (NUMBER). You want to calculate the rolling average sales for each week over a period of 12 weeks using a Snowpark DataFrame. Which of the following Snowpark code snippets correctly implements this calculation?

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

You're developing a model to predict equipment failure using sensor data stored in Snowflake. The dataset is highly imbalanced, with failure events (positive class) being rare compared to normal operation (negative class). To improve model performance, you're considering both up-sampling the minority class and down-sampling the majority class. Which of the following statements regarding the potential benefits and drawbacks of combining up-sampling and down-sampling techniques in this scenario are TRUE? (Select TWO)

• A. The optimal sampling ratio for both up-sampling and down-sampling must always be 1:1, regardless of the initial class distribution.
• B. Combining up-sampling and down-sampling can lead to a more balanced dataset, potentially improving the model's ability to learn patterns from both classes without introducing excessive bias from solely up-sampling.
• C. Down-sampling, when combined with up-sampling, can exacerbate the risk of losing important information from the majority class, leading to underfitting, especially if the majority class is already relatively small.
• D. Using both up-sampling and down-sampling always guarantees improved model performance compared to using only one of these techniques, regardless of the dataset characteristics.
• E. Over-sampling, combined with downsampling, makes the model more prone to overfitting since this causes the model to train on a large dataset.

You are evaluating a binary classification model built in Snowflake for predicting customer churn. You have access to the model's predictions on a holdout dataset, and you want to use both the ROC curve and the confusion matrix to comprehensively assess its performance. Which of the following statements regarding the interpretation and use of ROC curves and confusion matrices are correct in this scenario?

• A. The ROC curve visualizes the trade-off between true positive rate (sensitivity) and false negative rate (1 - specificity) at various threshold settings.
• B. While the ROC curve is independent of the class distribution, the metrics derived from the confusion matrix (e.g., precision, recall) can be significantly affected by imbalanced datasets.
• C. The area under the ROC curve (AUC) provides a single scalar value representing the overall discriminatory power of the model, with a higher AUC indicating better performance. An AUC of 0.5 indicates that the model performs no better than random chance.
• D. In Snowflake, you can generate ROC curves and confusion matrices directly using the 'SYSTEM$PREDICT function with appropriate parameters and visualizing the results using a tool like Snowsight or Tableau.
• E. The confusion matrix allows you to calculate precision, recall, F I-score, and accuracy, which are all useful for understanding the model's performance in terms of correctly and incorrectly classified instances.

You are building a data science pipeline in Snowflake to predict customer churn. The pipeline involves extracting data, transforming it using Dynamic Tables, training a model using Snowpark ML, and deploying the model for inference. The raw data arrives in a Snowflake stage daily as Parquet files. You want to optimize the pipeline for cost and performance. Which of the following strategies are MOST effective, considering resource utilization and potential data staleness?

• A. Implement a series of smaller Dynamic Tables, each responsible for a specific transformation step, with well-defined refresh intervals tailored to the data's volatility and the downstream model's requirements.
• B. Use a combination of Dynamic Tables for feature engineering and Snowpark ML for model training and deployment, ensuring proper dependency management and refresh intervals for each Dynamic Table based on data freshness requirements.
• C. Load all data into traditional Snowflake tables and use scheduled tasks with stored procedures written in Python to perform the transformations and model training.
• D. Schedule all data transformations and model training as a single large Snowpark Python script executed by a Snowflake task, ignoring data freshness requirements.
• E. Use a single, large Dynamic Table to perform all transformations in one step, relying on Snowflake's optimization to handle dependencies and incremental updates.