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
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!

2
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!

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
Data Scientist used streams in ELT (extract, load, transform) processes where new data inserted in-to a staging table is tracked by a stream. A set of SQL statements transform and insert the stream contents into a set of production tables. Raw data is coming in the JSON format, but for analysis he needs to transform it into relational columns in the production tables. which of the following Data transformation SQL function he can used to achieve the same?
Options
A METADATA$ACTION ()
B He could not apply Transformation on Stream table data.
C lateral flatten()
D Transpose()
Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

5
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!

Finish Practice?

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