Logo ExamsQA
Exit
Official Bank 0/65

Snowflake SnowPro Advanced: Data Scientist Certification (DSA-C02) - Snowflake Exam Questions

Last updated on June 20, 2026

97% Exam Compliance
65 Total Questions
1
Question
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?
Options
A Evaluate each trained model with a validation dataset and use the model with the highest accuracy score.
B Compare disparity between selection rates and performance metrics across ethnicities.
C Remove the ethnicity feature from the training dataset.
D None of the above.
Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

2
Question
Which of the following method is used for multiclass classification?
Options
A all vs one
B one vs rest
C loocv
D one vs another
Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

3
Question
Consider a data frame df with 10 rows and index [ 'r1', 'r2', 'r3', 'row4', 'row5', 'row6', 'r7', 'r8', 'r9', 'row10']. What does the aggregate method shown in below code do?
g = df.groupby(df.index.str.len())
g.aggregate({'A':len, 'B':np.sum})
Options
A Computes length of column A and Sum of Column B values of each group
B Computes Sum of column A values
C Computes length of column A
D Computes length of column A and Sum of Column B values
Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

4
Question
Mark the Incorrect understanding of Data Scientist about Streams?
Select 2
Options
A Streams on views support both local views and views shared using Snowflake Secure Data Sharing,
including secure views.
B Streams itself does not contain any table data.
C Streams can track changes in materialized views.
D Streams do not support repeatable read isolation.
Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

5
Question
All aggregate functions except _____ ignore null values in their input collection
Options
A Avg
B Count(attribute)
C Count(*)
D Sum
Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

Finish Practice?

Are you sure you want to finish? This will end your practice session.