최신Snowflake SnowPro Advanced: Data Scientist Certification - DSA-C03무료샘플문제
문제1
You're working with a large dataset containing customer purchase history. You want to identify customers whose purchase frequency deviates significantly from the average purchase frequency of all customers. The dataset is in a table named 'purchase history' with columns 'customer id' and 'purchase date'. What combination of Snowflake functionalities will allow you to achieve this task efficiently?
Choose all that apply.
You're working with a large dataset containing customer purchase history. You want to identify customers whose purchase frequency deviates significantly from the average purchase frequency of all customers. The dataset is in a table named 'purchase history' with columns 'customer id' and 'purchase date'. What combination of Snowflake functionalities will allow you to achieve this task efficiently?
Choose all that apply.
정답: C,D
설명: (ExamPassdump 회원만 볼 수 있음)
문제2
You are working on a fraud detection model and need to prepare transaction data'. You have two tables: 'transactions' (transaction_id, customer_id, transaction_date, amount, merchant_id) and (merchant_id, city, state). You need to perform the following data cleaning and feature engineering steps using Snowpark: 1. Remove duplicate transactions based on 'transaction_id'. 2.
Join the 'transactions' table with the 'merchant_locations table to add city and state information to each transaction. 3. Create a new feature called 'amount_category' based on the transaction amount, categorized as 'Low', 'Medium', or 'High'. 4. The categorization thresholds are defined as follows: 'LoW: amount < 50 'Medium': 50 amount < 200 'High': amount >= 200 Which of the following statements about performing these operations using Snowpark are accurate?
You are working on a fraud detection model and need to prepare transaction data'. You have two tables: 'transactions' (transaction_id, customer_id, transaction_date, amount, merchant_id) and (merchant_id, city, state). You need to perform the following data cleaning and feature engineering steps using Snowpark: 1. Remove duplicate transactions based on 'transaction_id'. 2.
Join the 'transactions' table with the 'merchant_locations table to add city and state information to each transaction. 3. Create a new feature called 'amount_category' based on the transaction amount, categorized as 'Low', 'Medium', or 'High'. 4. The categorization thresholds are defined as follows: 'LoW: amount < 50 'Medium': 50 amount < 200 'High': amount >= 200 Which of the following statements about performing these operations using Snowpark are accurate?
정답: B,D,E
설명: (ExamPassdump 회원만 볼 수 있음)
문제3
You've trained a machine learning model using Scikit-learn and saved it as 'model.joblib'. You need to deploy this model to Snowflake. Which sequence of commands will correctly stage the model and create a Snowflake external function to use it for inference, assuming you already have a Snowflake stage named 'model_stage'?
You've trained a machine learning model using Scikit-learn and saved it as 'model.joblib'. You need to deploy this model to Snowflake. Which sequence of commands will correctly stage the model and create a Snowflake external function to use it for inference, assuming you already have a Snowflake stage named 'model_stage'?
정답: B
설명: (ExamPassdump 회원만 볼 수 있음)
문제4
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?
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?
정답: C
설명: (ExamPassdump 회원만 볼 수 있음)
문제5
You have trained a classification model in Snowflake using Snowpark ML to predict customer churn. After deploying the model, you observe that the model performs well on the training data but poorly on new, unseen data'. You suspect overfitting. Which of the following strategies can be applied within Snowflake to detect and mitigate overfitting during model validation , considering the model is already deployed and receiving inference requests through a Snowflake UDF?
You have trained a classification model in Snowflake using Snowpark ML to predict customer churn. After deploying the model, you observe that the model performs well on the training data but poorly on new, unseen data'. You suspect overfitting. Which of the following strategies can be applied within Snowflake to detect and mitigate overfitting during model validation , considering the model is already deployed and receiving inference requests through a Snowflake UDF?
정답: A,C
설명: (ExamPassdump 회원만 볼 수 있음)
문제6
You are tasked with training a complex machine learning model using scikit-learn and need to leverage Snowflake's data for training outside of Snowflake using an external function. The training data resides in a Snowflake table named 'CUSTOMER DATA'. Due to data governance policies, you must ensure minimal data movement and secure communication. You choose to implement the external function using AWS Lambda'. Which of the following steps are crucial to achieve secure and efficient model training outside of Snowflake?
You are tasked with training a complex machine learning model using scikit-learn and need to leverage Snowflake's data for training outside of Snowflake using an external function. The training data resides in a Snowflake table named 'CUSTOMER DATA'. Due to data governance policies, you must ensure minimal data movement and secure communication. You choose to implement the external function using AWS Lambda'. Which of the following steps are crucial to achieve secure and efficient model training outside of Snowflake?
정답: A,B,D
설명: (ExamPassdump 회원만 볼 수 있음)
문제7
You are analyzing website clickstream data stored in Snowflake to identify user behavior patterns. The data includes user ID, timestamp, URL visited, and session ID. Which of the following unsupervised learning techniques, combined with appropriate data transformations in Snowflake SQL, would be most effective in discovering common navigation paths followed by users? (Choose two)
You are analyzing website clickstream data stored in Snowflake to identify user behavior patterns. The data includes user ID, timestamp, URL visited, and session ID. Which of the following unsupervised learning techniques, combined with appropriate data transformations in Snowflake SQL, would be most effective in discovering common navigation paths followed by users? (Choose two)
정답: A,D
설명: (ExamPassdump 회원만 볼 수 있음)
문제8
You are developing a Python stored procedure in Snowflake to predict sales for a retail company. You want to incorporate external data (e.g., weather forecasts) into your model. Which of the following methods are valid and efficient ways to access and use external data within your Snowflake Python stored procedure?
You are developing a Python stored procedure in Snowflake to predict sales for a retail company. You want to incorporate external data (e.g., weather forecasts) into your model. Which of the following methods are valid and efficient ways to access and use external data within your Snowflake Python stored procedure?
정답: B,C,D,E
설명: (ExamPassdump 회원만 볼 수 있음)
문제9
You are analyzing sensor data collected from industrial machines, which includes temperature readings. You need to identify machines with unusually high temperature variance compared to their peers. You have a table named 'sensor _ readings' with columns 'machine_id', 'timestamp', and 'temperature'. Which of the following SQL queries will help you identify machines with a temperature variance that is significantly higher than the average temperature variance across all machines? Assume 'significantly higher' means more than two standard deviations above the mean variance.
You are analyzing sensor data collected from industrial machines, which includes temperature readings. You need to identify machines with unusually high temperature variance compared to their peers. You have a table named 'sensor _ readings' with columns 'machine_id', 'timestamp', and 'temperature'. Which of the following SQL queries will help you identify machines with a temperature variance that is significantly higher than the average temperature variance across all machines? Assume 'significantly higher' means more than two standard deviations above the mean variance.
정답: D
설명: (ExamPassdump 회원만 볼 수 있음)
문제10
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?
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?
정답: D
설명: (ExamPassdump 회원만 볼 수 있음)
문제11
You are exploring a large dataset of website user behavior in Snowflake to identify patterns and potential features for a machine learning model predicting user engagement. You want to create a visualization showing the distribution of 'session_duration' for different 'user_segments'. The 'user_segmentS column contains categorical values like 'New', 'Returning', and 'Power User'. Which Snowflake SQL query and subsequent data visualization technique would be most effective for this task?
You are exploring a large dataset of website user behavior in Snowflake to identify patterns and potential features for a machine learning model predicting user engagement. You want to create a visualization showing the distribution of 'session_duration' for different 'user_segments'. The 'user_segmentS column contains categorical values like 'New', 'Returning', and 'Power User'. Which Snowflake SQL query and subsequent data visualization technique would be most effective for this task?
정답: C
설명: (ExamPassdump 회원만 볼 수 있음)