SnowPro Advanced: Data Scientist Certification Exam

Question 1

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

A. Avg

B. Count(*)

C. Count(attribute)

D. Sum

Correct Answer: B

Explanation: Only visible for Actualtests4sure members. You can sign-up / login (it's free).

Question 2

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. External tables

C. Tables

D. Secure UDFs

Correct Answer: A

Explanation: Only visible for Actualtests4sure members. You can sign-up / login (it's free).

Question 3

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. Vectorized Python UDFs

B. MPP Python UDFs

C. Hybrid Python UDFs

D. Scaler Python UDFs

Correct Answer: A

Explanation: Only visible for Actualtests4sure members. You can sign-up / login (it's free).

Question 4

Which of the following is a Python-based web application framework for visualizing data and analyzing results in a more efficient and flexible way?

A. Streamsets

B. Rapter

C. StreamBI

D. Streamlit

Correct Answer: D

Explanation: Only visible for Actualtests4sure members. You can sign-up / login (it's free).

Question 5

Which are the following additional Metadata columns Stream contains that could be used for creating Efficient Data science Pipelines & helps in transforming only the New/Modified data only?

A. METADATA$ISUPDATE

B. METADATA$FILE_ID

C. METADATA$ACTION

D. METADATA$DELETE

E. METADATA$ROW_ID

Correct Answer: A,C,E

Explanation: Only visible for Actualtests4sure members. You can sign-up / login (it's free).

Question 6

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 a database role.

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

C. Grant privileges on objects to a share via Account role.

D. Grant privileges on objects directly to a share.

Correct Answer: A,D

Explanation: Only visible for Actualtests4sure members. You can sign-up / login (it's free).

Question 7

Skewness of Normal distribution is ___________

A. 0

B. Positive

C. Negative

D. Undefined

Correct Answer: A

Explanation: Only visible for Actualtests4sure members. You can sign-up / login (it's free).

Snowflake SnowPro Advanced: Data Scientist Certification - DSA-C02 Exam Practice Test

Latest Update

Useful Links

Contact Us