SnowPro Advanced Data Scientist DSA-C03 v1.0

Which statement will add a column based on the following condition:
A Data Scientist wants to change Product 1 to P1, Product 1A to P1A, and Product 1B to P1B. If none of those are met, the record should be Not P1.

For which Snowflake Cortex LLM functions would both input and output tokens be counted? (Choose three.)

A company’s platform team wants to integrate their existing data lake with Snowflake. The data lake is hundreds of TBs in size and the team does not want to duplicate most of the data into Snowflake. A Data Scientist at the company wants to be able to query and access the data lake’s metadata. There is already an external stage in Snowflake referencing the data lake’s location.
What is the MOST efficient way to integrate the existing data lake into the Snowflake environment?

This chart in Snowsight for a New York City ride-share bike service shows the number of trips taken to the destination borough:

A Data Scientist wants to build a classifier that predicts which borough will be the most likely destination when a trip is initiated.
Which techniques should be used to handle the class imbalance depicted in the Snowsight chart? (Choose two.)

A remote weather sensor malfunctions and produces temperature readings higher than the normal range which was around 69.8°F (21°C).
Ignoring units, what is the correct order of the magnitude of these key measures?

Which step of the machine learning lifecycle does hyperparameter tuning fall under?

A Data Scientist wants to train a supervised machine learning model on a data set containing multiple numeric continuous features. During the exploration phase, the Data Scientist observed that the features are roughly normally distributed with mean and variance being different between features. The Data Scientist built the pipeline leveraging Snowpark ML.
Which class from snowflake.ml.modeling.preprocessing should the Data Scientist use to obtain features with mean zero and unit variance?

A binary JAR file is outputted to score data within Snowflake.
What steps are necessary to get the scoring code functioning in Snowflake? (Choose two.)

A Data Scientist needs to build a data set using columns in multiple tables and keep it automatically updated in an incremental fashion.
How can this be done without the need for writing an INSERT or checks for changes in the required tables?

A Data Scientist is developing a real-time detection model for a call center. The data is the audio transcript of the live calls between customers and agents.
The model needs to identify if a call is abnormal so the system can send the supervisor an alert immediately. There was a negligible percentage of calls that were reviewed and flagged.
Which method should be used FIRST to separate abnormal calls?

A Data Scientist is using the snowflake.cortex.complete function to generate a response for a company’s knowledge base model.
What parameters are required? (Choose two.)

A Data Scientist executes a SQL NULL argument to a Python User-Defined Function (UDF) in a Snowflake string data type.
What will be returned as a translated Python value?

A Data Scientist is building a data pipeline for a customer churn model. To enable efficient processing of the model, they add a stream to the customer table.
Which function should be used to check if the stream has new or updated data?

This correlation matrix was created when performing feature engineering:

Which combination of variables is the MOST correlated and could possibly help with feature reduction?