Snowflake SnowPro Advanced: Data Scientist Certification - DSA-C03 certification

You are performing exploratory data analysis on a dataset containing customer transaction data in Snowflake. The dataset has a column named 'transaction_amount' and a column named 'customer_segment'. You want to analyze the distribution of transaction amounts for each customer segment using Snowflake's statistical functions. Which of the following approaches would BEST achieve this, providing insights into the central tendency and spread of the data?

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

You are building a predictive model for customer churn using linear regression in Snowflake. You have identified several features, including 'CUSTOMER AGE', 'MONTHLY SPEND', and 'NUM CALLS'. After performing an initial linear regression, you suspect that the relationship between 'CUSTOMER AGE and churn is not linear and that older customers might churn at a different rate than younger customers. You want to introduce a polynomial feature of "CUSTOMER AGE (specifically, 'CUSTOMER AGE SQUARED') to your regression model within Snowflake SQL before further analysis with python and Snowpark. How can you BEST create this new feature in a robust and maintainable way directly within Snowflake?

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

You are working with a Snowflake table 'CUSTOMER DATA containing customer information for a marketing campaign. The table includes columns like 'CUSTOMER ID', 'FIRST NAME', 'LAST NAME, 'EMAIL', 'PHONE NUMBER, 'ADDRESS, 'CITY, 'STATE, ZIP CODE, 'COUNTRY, 'PURCHASE HISTORY, 'CLICKSTREAM DATA, and 'OBSOLETE COLUMN'. You need to prepare this data for a machine learning model focused on predicting customer churn. Which of the following strategies and Snowpark Python code snippets would be MOST efficient and appropriate for removing irrelevant fields and handling potentially sensitive personal information while adhering to data governance policies? Assume data governance requires removing personally identifiable information (PII) that isn't strictly necessary for the churn model.

• A. Keeping all columns as is and providing access to Data Scientists without any changes, relying on role based security access controls only.
• B. Dropping 'FIRST NAME, UST NAME, 'EMAIL', 'PHONE NUMBER, 'ADDRESS', 'CITY, 'STATE', ZIP CODE, 'COUNTRY and 'OBSOLETE_COLUMN' columns directly using 'LAST_NAME', 'EMAIL', 'PHONE_NUMBER', 'ADDRESS', 'CITY', 'STATE', 'ZIP_CODE', 'COUNTRY', without any further consideration.
• C. Dropping columns 'OBSOLETE_COLUMN' directly. Then, for PII columns ('FIRST_NAME, 'LAST_NAME, 'EMAIL', 'PHONE_NUMBER, 'ADDRESS', 'CITY', 'STATE' , , 'COUNTRY), create a separate table with anonymized or aggregated data for analysis unrelated to the churn model. Use Keep all PII columns but encrypt them using Snowflake's built-in encryption features to comply with data governance before building the model. Drop 'OBSOLETE COLUMN'.
• D. Drop 'OBSOLETE_COLUMN'. For columns like and 'LAST_NAME' , consider aggregating into a single 'FULL_NAME feature if needed for some downstream task. Apply hashing or tokenization techniques to sensitive PII columns like and 'PHONE NUMBER using Snowpark UDFs, depending on the model's requirements. Drop columns like 'ADDRESS, 'CITY, 'STATE, ZIP_CODE, 'COUNTRY as they likely do not contribute to churn prediction. Example hashing function:
  

You are using Snowpark to build a collaborative filtering model for product recommendations. You have a table 'USER_ITEM INTERACTIONS with columns 'USER ID', 'ITEM ID', and 'INTERACTION TYPE'. You want to create a sparse matrix representation of this data using Snowpark, suitable for input into a matrix factorization algorithm. Which of the following code snippets best achieves this while efficiently handling large datasets within Snowflake?

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

You are building a fraud detection model in Snowflake using Snowpark Python. You want to evaluate the model's performance, particularly focusing on identifying instances of fraud (minority class). Which combination of metrics provides the most comprehensive assessment for this imbalanced classification problem within the Snowflake environment, considering the need to minimize both false positives (legitimate transactions flagged as fraudulent) and false negatives (fraudulent transactions missed)?

• A. Precision, Recall, and Fl-score.
• B. Accuracy and ROC AUC.
• C. Accuracy and Recall.
• D. Precision and Fl-score.
• E. ROC AUC and Recall.