Instantly download DSA-C03 updated real questions

Snowflake DSA-C03 Exam Overview:

Snowflake DSA-C03 Exam Syllabus Topics:

Snowflake SnowPro Advanced: Data Scientist Certification Sample Questions:

1. You have a Snowflake table 'PRODUCT_PRICES' with columns 'PRODUCT_ID' (INTEGER) and 'PRICE' (VARCHAR). The 'PRICE' column sometimes contains values like '10.50 USD', '20.00 EUR', or 'Invalid Price'. You need to convert the 'PRICE column to a NUMERIC(10,2) data type, removing currency symbols and handling invalid price strings by replacing them with NULL. Considering both data preparation and feature engineering, which combination of Snowpark SQL and Python code snippets achieves this accurately and efficiently, preparing the data for further analysis?

A) Option A
B) Option E
C) Option B
D) Option D
E) Option C

2. You are using Snowflake Cortex to analyze customer reviews. You have created a vector embedding for each review using a UDF that calls a remote LLM inference endpoint. Now you need to perform a similarity search to identify reviews that are similar to a given query review. Which of the following SQL queries leveraging vector functions in Snowflake is the MOST efficient and appropriate way to achieve this, assuming the 'REVIEW EMBEDDINGS' table has columns 'review_id' and 'embedding' (a VECTOR column) and query_embedding' is a pre-computed vector embedding?

A) Option A
B) Option E
C) Option B
D) Option D
E) Option C

3. You are working with a dataset in Snowflake containing customer reviews stored in a 'REVIEWS' table. The 'SENTIMENT SCORE column contains continuous values ranging from -1 (negative) to 1 (positive). You need to create a new column, 'SENTIMENT CATEGORY, based on the following rules: 'Negative': 'SENTIMENT SCORE < -0.5 'Neutral': -0.5 'SENTIMENT SCORE 0.5 'Positive': 'SENTIMENT SCORE > 0.5 You also want to binarize this 'SENTIMENT CATEGORY column into three separate columns: 'IS NEGATIVE, 'IS NEUTRAL', and 'IS POSITIVE. Which of the following SQL statements correctly implements both the categorization and subsequent binarization?

A) Option A
B) Option E
C) Option B
D) Option D
E) Option C

4. You are tasked with training a model within Snowflake to predict customer churn for a telecommunications company. The dataset is stored in a Snowflake table named 'CUSTOMER DATA. The features include 'age', and 'data_usage'. The target variable is 'churned' (boolean). You want to use the SNOWFLAKE.ML.ANACONDA INTEGRATION to leverage Scikit-learn for model training. Which of the following code snippets correctly performs model training with Snowflake ML, addressing potential issues like feature scaling and data type handling within the stored procedure?

A)

B)

C)

D)

5. You are using a Snowflake Notebook to analyze customer churn for a telecommunications company. You have a dataset with millions of rows and want to perform feature engineering using a combination of SQL transformations and Python code. Your goal is to create a new feature called 'average_monthly call_duration' which calculates the average call duration for each customer over the last 3 months. You are using the Snowpark DataFrame API within your notebook. Given the following code snippet to start with:

A) Option A
B) Option E
C) Option B
D) Option D
E) Option C

Solutions: