Snowflake SnowPro Advanced: Data Scientist Certification - DSA-C03 Exam Practice Test

A marketing team at 'RetailSphere' wants to segment their customer base using unstructured textual data (customer reviews) stored in a Snowflake VARIANT column named 'REVIEW TEXT within the table 'CUSTOMER REVIEWS'. They aim to identify distinct customer segments based on sentiment and topics discussed in their reviews. They want to use a Supervised Learning approach for this task. Which of the following strategies best describes the appropriate approach within Snowflake, considering performance and scalability? Assume you have pre-trained sentiment and topic models deployed as Snowflake external functions.

You are tasked with building a predictive model in Snowflake to identify high-value customers based on their transaction history. The 'CUSTOMER_TRANSACTIONS table contains a 'TRANSACTION_AMOUNT column. You need to binarize this column, categorizing transactions as 'High Value' if the amount is above a dynamically calculated threshold (the 90th percentile of transaction amounts) and 'Low Value' otherwise. Which of the following Snowflake SQL queries correctly achieves this binarization, leveraging window functions for threshold calculation and resulting in a 'CUSTOMER SEGMENT column?

You are working on a customer churn prediction project. One of the features you want to normalize is 'customer_age'. However, a Snowflake table constraint ensures that all 'customer_age' values are between 0 and 120 (inclusive). Furthermore, you want to avoid using any stored procedures and prefer a pure SQL approach for data transformation. Considering these constraints, which normalization technique and associated SQL query is the most appropriate in Snowflake for this scenario, guaranteeing that the scaled values remain within a predictable range?

A data scientist is analyzing sales data in Snowflake to identify seasonal trends. The 'SALES TABLE' contains columns 'SALE DATE' (DATE) and 'SALE _ AMOUNT' (NUMBER). They want to calculate the average daily sales amount for each month and year in the dataset. Which of the following SQL queries will correctly achieve this, while also handling potential NULL values in 'SALE AMOUNT?

You've built a machine learning model in scikit-learn and want to deploy it to Snowflake for real-time inference. You have the following options for deploying the model. Select all that apply and are considered a best practice for cost and time optimization:

You are working with a large dataset of sensor readings stored in a Snowflake table. You need to perform several complex feature engineering steps, including calculating rolling statistics (e.g., moving average) over a time window for each sensor. You want to use Snowpark Pandas for this task. However, the dataset is too large to fit into the memory of a single Snowpark Pandas worker. How can you efficiently perform the rolling statistics calculation without exceeding memory limits? Select all options that apply.

A telecom company, 'ConnectPlus', observes that the individual call durations of its customers are heavily skewed towards shorter calls, following an exponential distribution. A data science team aims to analyze call patterns and requires to perform hypothesis testing on the average call duration. Which of the following statements regarding the applicability of the Central Limit Theorem (CLT) in this scenario are correct if the sample size is sufficiently large?

You are training a Gradient Boosting model within Snowflake using Snowpark Python to predict customer churn. You are using the Hyperopt library for hyperparameter tuning. You want to use the function to find the best hyperparameters. You have defined your objective function, , and the search space, Which of the following is the MOST efficient and correct way to call the function within a Snowpark Python UDF to ensure the Hyperopt trials data is effectively managed and accessible for further analysis within Snowflake?

You are managing a machine learning model lifecycle in Snowflake using the Model Registry. Which of the following statements are true regarding model lineage and governance when utilizing the Model Registry for model versioning and deployment?

You are tasked with training a logistic regression model in Snowflake using Snowpark Python to predict customer churn. Your data is stored in a table named 'CUSTOMER DATA' with columns like 'CUSTOMER D', 'FEATURE 1', 'FEATURE 2', 'FEATURE 3', and 'CHURN FLAG' (boolean representing churn). You plan to use stratified k-fold cross-validation to ensure each fold has a representative proportion of churned and non-churned customers. Which of the following code snippets demonstrates the correct way to perform stratified k-fold cross-validation with Snowpark ML? (Assume 'snowpark_session' is a valid Snowpark session object).