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
Which one is incorrect understanding about Providers of Direct share?
Options
A A data provider is any Snowflake account that creates shares and makes them available to other Snowflake accounts to consume.
B You can create as many shares as you want, and add as many accounts to a share as you want.
C As a data provider, you share a database with one or more Snowflake accounts.
D If you want to provide a share to many accounts, you can do the same via Direct Share.
Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

2
Question
What is the formula for measuring skewness in a dataset?
Options
A MEAN - MEDIAN
B (3(MEAN - MEDIAN))/ STANDARD DEVIATION
C MODE - MEDIAN
D (MEAN - MODE)/ STANDARD DEVIATION
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 columns ['A', 'B', 'C', 'D'] and rows ['r1', 'r2', 'r3']. What does the ex- pression df[lambda x : x.index.str.endswith('3')] do?
Options
A Returns the third column
B Returns the row name r3
C Results in Error
D Filters the row labelled r3
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
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!

Finish Practice?

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