DSA-C02 by Snowflake Actual Free Exam Questions And Answers

Question 1

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

A. HEX

B. DvSUM

C. DiYotta

D. Denodo

Discussion 0

Correct Answer: A Vote an answer

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

Question 2

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

A. Avg

B. Count(attribute)

C. Count(*)

D. Sum

Discussion 0

Correct Answer: C Vote an answer

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

Question 3

Which of the following Functions do Support Windowing?

A. LISTAGG

B. HASH_AGG

C. ENCRYPT

D. EXTRACT

Discussion 0

Correct Answer: A Vote an answer

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

Question 4

Which one is the incorrect option to share data in Snowflake?

A. a Data Exchange, in which you set up and manage a group of accounts and offer a share to that group.

B. a Direct Marketplace, in which you directly share specific database objects (a share) to another account in your region using Snowflake Marketplace.

C. a Listing, in which you offer a share and additional metadata as a data product to one or more accounts.

D. a Direct Share, in which you directly share specific database objects (a share) to anoth-er account in your region.

Discussion 0

Correct Answer: B Vote an answer

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

Question 5

Which of the Following is not type of Windows function in Snowflake?

A. Window frame functions.

B. Association functions.

C. Aggregation window functions.

D. Rank-related functions.

Discussion 0

Correct Answer: B,C Vote an answer

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

Question 6

What is the formula for measuring skewness in a dataset?

A. (3(MEAN - MEDIAN))/ STANDARD DEVIATION

B. (MEAN - MODE)/ STANDARD DEVIATION

C. MEAN - MEDIAN

D. MODE - MEDIAN

Discussion 0

Correct Answer: A Vote an answer

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

Question 7

Which one is incorrect understanding about Providers of Direct share?

A. You can create as many shares as you want, and add as many accounts to a share as you want.

B. As a data provider, you share a database with one or more Snowflake accounts.

C. If you want to provide a share to many accounts, you can do the same via Direct Share.

D. A data provider is any Snowflake account that creates shares and makes them available to other Snowflake accounts to consume.

Discussion 0

Correct Answer: C Vote an answer

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

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

Contact Us

Useful Links

Latest Updated