最新的Snowflake SnowPro Advanced: Data Scientist Certification - DSA-C03免費考試真題
You have a Snowflake Model Registry set up and are managing multiple versions of a machine learning model. You want to programmatically retrieve a specific version of the model and load it for inference within a Snowflake Snowpark Python UDE Assume your registry name is 'my_registry', the model name is 'credit risk_model', and you want to retrieve version 'v2'. How would you achieve this using Snowpark Python?
正確答案: E
說明：（僅 Fast2test 成員可見）
A retail company is using Snowflake to store transaction data'. They want to create a derived feature called 'customer _ recency' to represent the number of days since a customer's last purchase. The transactions table 'TRANSACTIONS has columns 'customer_id' (INT) and 'transaction_date' (DATE). Which of the following SQL queries is the MOST efficient and scalable way to derive this feature as a materialized view in Snowflake?
正確答案: C
說明：（僅 Fast2test 成員可見）
You have a structured dataset in Snowflake containing customer information and purchase history. You aim to build a multi-class classification model to predict customer churn, categorizing customers into 'Low Risk', 'Medium Risk', and 'High Risk' of churning. After training the model, you want to evaluate its performance. Which of the following metrics and evaluation techniques, when used together, provide the MOST comprehensive understanding of the model's performance across all churn risk categories, especially when dealing with potential class imbalance?
正確答案: E
說明：（僅 Fast2test 成員可見）
You are analyzing website traffic data stored in a Snowflake table named 'WEB EVENTS. This table contains a 'TIMESTAMP' column representing when the event occurred and a 'PAGE VIEWS column indicating the number of page views for that event. You need to identify the day with the highest number of page views and also the day with lowest number of page views along with average number of page views. How can you accomplish this using Snowflake SQL?
正確答案: A
說明：（僅 Fast2test 成員可見）
You've created a Python stored procedure in Snowflake to train a model. The procedure successfully trains the model, saves it using 'joblib.dump' , and then attempts to upload the model file to an internal stage. However, the upload fails intermittently with a FileNotFoundErroN. The stage is correctly configured, and the stored procedure has the necessary privileges. Which of the following actions are MOST likely to resolve this issue? (Select TWO)
正確答案: A,E
說明：（僅 Fast2test 成員可見）
You are tasked with optimizing the hyperparameter tuning process for a complex deep learning model within Snowflake using Snowpark Python. The model is trained on a large dataset stored in Snowflake, and you need to efficiently explore a wide range of hyperparameter values to achieve optimal performance. Which of the following approaches would provide the MOST scalable and performant solution for hyperparameter tuning in this scenario, considering the constraints and capabilities of Snowflake?
正確答案: E
說明：（僅 Fast2test 成員可見）
You've built a complex machine learning model using scikit-learn and deployed it as a Python UDF in Snowflake. The UDF takes a JSON string as input, containing several numerical features, and returns a predicted probability However, you observe significant performance issues, particularly when processing large batches of data'. Which of the following approaches would be MOST effective in optimizing the performance of this UDF in Snowflake?
正確答案: B,C
說明：（僅 Fast2test 成員可見）
You are building a churn prediction model for a telecommunications company using Snowflake and Snowpark ML. You have trained a Gradient Boosting Machine (GBM) model and want to understand the feature importance to identify key drivers of churn. You've used SHAP (SHapley Additive exPlanations) values to explain individual predictions. Given a customer with a high churn risk, you observe that the 'monthly_charges' feature has a significantly large negative SHAP value for that specific prediction. Which of the following statements best interprets this observation in the context of feature impact?
正確答案: B
說明：（僅 Fast2test 成員可見）
You are building a fraud detection model for an e-commerce platform. One of the features is 'purchase_amount', which ranges from $1 to $10,000. The data has a skewed distribution with many small purchases and a few very large ones. You need to normalize this feature for your model, which uses gradient descent. Which normalization technique(s) would be most suitable in Snowflake, considering the data characteristics and the need to handle potential future outliers?
正確答案: B,E
說明：（僅 Fast2test 成員可見）
You are working with a dataset containing timestamps representing website user activity. The timestamps are stored as strings in the format 'YYYY-MM-DD HH:MI:SS.SSSSSS' in a Snowflake table named 'website_activity'. You need to extract the hour of the day from these timestamps and encode it as a cyclical feature using sine and cosine transformations. This is to capture the cyclical nature of user activity throughout the day (e.g., 23:00 and 00:00 are close in time). Which of the following Snowflake SQL code snippets correctly implements this cyclical encoding and creates the 'hour_sin' and 'hour_cos' columns?
正確答案: A
說明：（僅 Fast2test 成員可見）
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?
正確答案: D
說明：（僅 Fast2test 成員可見）
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?
正確答案: B,D,E
說明：（僅 Fast2test 成員可見）
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,C
說明：（僅 Fast2test 成員可見）