11.11 Special Sale Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: scxmas70

DSA-C02 Exam Dumps - SnowPro Advanced: Data Scientist Certification Exam

Question # 4

You are training a binary classification model to support admission approval decisions for a college degree program.

How can you evaluate if the model is fair, and doesn’t discriminate based on ethnicity?

A.

Evaluate each trained model with a validation datasetand use the model with the highest accuracy score.

B.

Remove the ethnicity feature from the training dataset.

C.

Compare disparity between selection rates and performance metrics across ethnicities.

D.

None of the above.

Full Access
Question # 5

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

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.

Full Access
Question # 6

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?

A.

MPP Python UDFs

B.

Scaler Python UDFs

C.

Vectorized Python UDFs

D.

Hybrid Python UDFs

Full Access
Question # 7

Which of the following is a useful tool for gaining insights into the relationship between features and predictions?

A.

numpy plots

B.

sklearn plots

C.

Partial dependence plots(PDP)

D.

FULL dependence plots (FDP)

Full Access
Question # 8

How do you handle missing or corrupted data in a dataset?

A.

Drop missing rows or columns

B.

Replace missing values with mean/median/mode

C.

Assign a unique category to missing values

D.

All of the above

Full Access
Question # 9

All aggregate functions except _____ ignore null values in their input collection

A.

Count(attribute)

B.

Count(*)

C.

Avg

D.

Sum

Full Access
Question # 10

Select the Data Science Tools which are known to provide native connectivity to Snowflake?

A.

Denodo

B.

DvSUM

C.

DiYotta

D.

HEX

Full Access
Question # 11

In a simple linear regression model (One independent variable), If we change the input variable by 1 unit. How much output variable will change?

A.

by 1

B.

no change

C.

by intercept

D.

by its slope

Full Access
Question # 12

Which of the following Functions do Support Windowing?

A.

HASH_AGG

B.

ENCRYPT

C.

EXTRACT

D.

LISTAGG

Full Access
Question # 13

Secure Data Sharing do not let you share which of the following selected objects in a database in your account with other Snowflake accounts?

A.

Sequences

B.

Tables

C.

External tables

D.

Secure UDFs

Full Access
Question # 14

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

A.

R² (R-Squared)

B.

Root Mean Squared Error (RMSE)

C.

AU-ROC

D.

AUM

Full Access
Question # 15

Data providers add Snowflake objects (databases, schemas, tables, secure views, etc.) to a share us-ing Which of the following options?

A.

Grant privileges on objects to a share via Account role.

B.

Grant privileges on objects directly to a share.

C.

Grant privileges on objects to a share via a database role.

D.

Grant privileges on objects to a share via a third-party role.

Full Access
Question # 16

Which object records data manipulation language (DML) changes made to tables, including inserts, updates, and deletes, as well as metadata about each change, so that actions can be taken using the changed data of Data Science Pipelines?

A.

Task

B.

Dynamic tables

C.

Stream

D.

Tags

E.

Delta

F.

OFFSET

Full Access
Question # 17

Which ones are the key actions in the data collection phase of Machine learning included?

A.

Label

B.

Ingest and Aggregate

C.

Probability

D.

Measure

Full Access
Question # 18

Data Scientist can query, process, and transform data in a which of the following ways using Snowpark Python. [Select 2]

A.

Query and process data with a DataFrame object.

B.

Write a user-defined tabular function (UDTF) that processes data and returns data in a set of rows with one or more columns.

C.

SnowPark currently do not support writing UDTF.

D.

Transform Data using DataIKY tool with SnowPark API.

Full Access