Weekend Sale 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: exams65

ExamsBrite Dumps

SnowPro Advanced: Data Scientist Certification Exam Question and Answers

SnowPro Advanced: Data Scientist Certification Exam

Last Update Sep 14, 2025
Total Questions : 65

We are offering FREE DSA-C02 Snowflake exam questions. All you do is to just go and sign up. Give your details, prepare DSA-C02 free exam questions and then go for complete pool of SnowPro Advanced: Data Scientist Certification Exam test questions that will help you more.

DSA-C02 pdf

DSA-C02 PDF

$36.75  $104.99
 Add to Cart
DSA-C02 Engine

DSA-C02 Testing Engine

$43.75  $124.99
 Add to Cart
DSA-C02 PDF + Engine

DSA-C02 PDF + Testing Engine

$57.75  $164.99
 Add to Cart
Questions 1

Which one is not the types of Feature Engineering Transformation?

Options:

A.  

Scaling

B.  

Encoding

C.  

Aggregation

D.  

Normalization

Discussion 0
Questions 2

Which method is used for detecting data outliers in Machine learning?

Options:

A.  

Scaler

B.  

Z-Score

C.  

BOXI

D.  

CMIYC

Discussion 0
Questions 3

What Can Snowflake Data Scientist do in the Snowflake Marketplace as Consumer?

Options:

A.  

Discover and test third-party data sources.

B.  

Receive frictionless access to raw data products from vendors.

C.  

Combine new datasets with your existing data in Snowflake to derive new business in-sights.

D.  

Use the business intelligence (BI)/ML/Deep learning tools of her choice.

Discussion 0
Questions 4

Which one of the following is not the key component while designing External functions within Snowflake?

Options:

A.  

Remote Service

B.  

API Integration

C.  

UDF Service

D.  

Proxy Service

Discussion 0
Questions 5

Performance metrics are a part of every machine learning pipeline, Which ones are not the performance metrics used in the Machine learning?

Options:

A.  

R² (R-Squared)

B.  

Root Mean Squared Error (RMSE)

C.  

AU-ROC

D.  

AUM

Discussion 0
Questions 6

Mark the correct steps for saving the contents of a DataFrame to aSnowflake table as part of Moving Data from Spark to Snowflake?

Options:

A.  

Step 1.Use the PUT() method of the DataFrame to construct a DataFrameWriter.

Step 2.Specify SNOWFLAKE_SOURCE_NAME using the NAME() method.

Step 3.Use the dbtable option to specify the table to which data is written.

Step 4.Specify the connector options using either the option() or options() method.

Step 5.Use the save() method to specify the save mode for the content.

B.  

Step 1.Use the PUT() method of the DataFrame to construct a DataFrameWriter.

Step 2.Specify SNOWFLAKE_SOURCE_NAME using the format() method.

Step 3.Specify the connector options using either the option() or options() method.

Step 4.Use the dbtable option to specify the table to which data is written.

Step 5.Use the save() method to specify the save mode for the content.

C.  

Step 1.Use the write() method of the DataFrame to construct a DataFrameWriter.

Step 2.Specify SNOWFLAKE_SOURCE_NAME using the format() method.

Step 3.Specify the connector options using either the option() or options() method.

Step 4.Use the dbtable option to specify the table to which data is written.

Step 5.Use the mode() method to specify the save mode for the content.

(Correct)

D.  

Step 1.Use the writer() method of the DataFrame to construct a DataFrameWriter.

Step 2.Specify SNOWFLAKE_SOURCE_NAME using the format() method.

Step 3.Use the dbtable option to specify the table to which data is written.

Step 4.Specify the connector options using either the option() or options() method.

Step 5.Use the save() method to specify the save mode for the content.

Discussion 0
Questions 7

Mark the Incorrect understanding of Data Scientist about Streams?

Options:

A.  

Streams on views support both local views and views shared using Snowflake Secure Data Sharing, including secure views.

B.  

Streams can track changes in materialized views.

C.  

Streams itself does not contain any table data.

D.  

Streams do not support repeatable read isolation.

Discussion 0
Questions 8

To return the contents of a DataFrame as a Pandas DataFrame, Which of the following method can be used in SnowPark API?

Options:

A.  

REPLACE_TO_PANDAS

B.  

SNOWPARK_TO_PANDAS

C.  

CONVERT_TO_PANDAS

D.  

TO_PANDAS

Discussion 0
Questions 9

Which of the following Snowflake parameter can be used to Automatically Suspend Tasks which are running Data science pipelines after specified Failed Runs?

Options:

A.  

SUSPEND_TASK

B.  

SUSPEND_TASK_AUTO_NUM_FAILURES

C.  

SUSPEND_TASK_AFTER_NUM_FAILURES

D.  

There is none as such available.

Discussion 0
Questions 10

You previously trained a model using a training dataset. You want to detect any data drift in the new data collected since the model was trained.

What should you do?

Options:

A.  

Create a new dataset using the new data and a timestamp column and create a data drift monitor that uses the training dataset as a baseline and the new dataset as a target.

B.  

Create a new version of the dataset using only the new data and retrain the model.

C.  

Add the new data to the existing dataset and enable Application Insights for the service where the model is deployed.

D.  

Retrained your training dataset after correcting data outliers & no need to introduce new data.

Discussion 0
Questions 11

Mark the incorrect statement regarding usage of Snowflake Stream & Tasks?

Options:

A.  

Snowflake automatically resizes and scales the compute resources for serverless tasks.

B.  

Snowflake ensures only one instance of a task with a schedule (i.e. a standalone task or the root task in a DAG) is executed at a given time. If a task is still running when the next scheduled execution time occurs, then that scheduled time is skipped.

C.  

Streams support repeatable read isolation.

D.  

An standard-only stream tracks row inserts only.

Discussion 0
Questions 12

Which ones are the type of visualization used for Data exploration in Data Science?

Options:

A.  

Heat Maps

B.  

Newton AI

C.  

Feature Distribution by Class

D.  

2D-Density Plots

E.  

Sand Visualization

Discussion 0
Questions 13

Which of the following cross validation versions may not be suitable for very large datasets with hundreds of thousands of samples?

Options:

A.  

k-fold cross-validation

B.  

Leave-one-out cross-validation

C.  

Holdout method

D.  

All of the above

Discussion 0
Questions 14

Which metric is not used for evaluating classification models?

Options:

A.  

Recall

B.  

Accuracy

C.  

Mean absolute error

D.  

Precision

Discussion 0
Questions 15

Which one is the incorrect option to share data in Snowflake?

Options:

A.  

a Listing, in which you offer a share and additional metadata as a data product to one or more accounts.

B.  

a Direct Marketplace, in which you directly share specific database objects (a share) to another account in your region using Snowflake Marketplace.

C.  

a Direct Share, in which you directly share specific database objects (a share) to anoth-er account in your region.

D.  

a Data Exchange, in which you set up and manage a group of accounts and offer a share to that group.

Discussion 0
Questions 16

A Data Scientist as data providers require to allow consumers to access all databases and database objects in a share by granting a single privilege on shared databases. Which one is incorrect SnowSQL command used by her while doing this task?

Assuming:

A database named product_db exists with a schema named product_agg and a table named Item_agg.

The database, schema, and table will be shared with two accounts named xy12345 and yz23456.

1.USE ROLE accountadmin;

2.CREATE DIRECT SHARE product_s;

3.GRANT USAGE ON DATABASE product_db TO SHARE product_s;

4.GRANT USAGE ON SCHEMA product_db. product_agg TO SHARE product_s;

5.GRANT SELECT ON TABLE sales_db. product_agg.Item_agg TO SHARE product_s;

6.SHOW GRANTS TO SHARE product_s;

7.ALTER SHARE product_s ADD ACCOUNTS=xy12345, yz23456;

8.SHOW GRANTS OF SHARE product_s;

Options:

A.  

GRANT USAGE ON DATABASE product_db TO SHARE product_s;

B.  

CREATE DIRECT SHARE product_s;

C.  

GRANT SELECT ON TABLE sales_db. product_agg.Item_agg TO SHARE product_s;

D.  

ALTER SHARE product_s ADD ACCOUNTS=xy12345, yz23456;

Discussion 0
Questions 17

Which of the Following is not type of Windows function in Snowflake?

Options:

A.  

Rank-related functions.

B.  

Window frame functions.

C.  

Aggregation window functions.

D.  

Association functions.

Discussion 0
Questions 18

Which type of Python UDFs let you define Python functions that receive batches of input rows as Pandas DataFrames and return batches of results as Pandas arrays or Series?

Options:

A.  

MPP Python UDFs

B.  

Scaler Python UDFs

C.  

Vectorized Python UDFs

D.  

Hybrid Python UDFs

Discussion 0