Free Snowflake DSA-C02 Exam Questions

Become Snowflake Certified with updated DSA-C02 exam questions and correct answers

Page: 1 / 13

Total 65 Questions | Updated On: Sep 22, 2023

Add To Cart

Question 1

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

A : Denodo

B : DvSUM

C : DiYotta

D : HEX

Answer: D

Question 2

The most widely used metrics and tools to assess a classification model are:

A : Confusion matrix

B : Cost-sensitive accuracy

C : Area under the ROC curve

D : All of the above

Answer: D

Question 3

Which of the following cross validation versions may not be suitable for very large datasets with hundreds of thousands of samples?

A : k-fold cross-validation

B : Leave-one-out cross-validation

C : Holdout method

D : All of the above

Answer: B

Question 4

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 Account role.

B : Grant privileges on objects directly to a share.

C : Grant privileges on objects to a share via a database role.

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

Answer: B,C

Question 5

Which ones are the known limitations of using External function?

A : Currently, external functions cannot be shared with data consumers via Secure Data Sharing.

B : Currently, external functions must be scalar functions. A scalar external function re-turns a single value for each input row.

C : External functions have more overhead than internal functions (both built-in functions and internal UDFs) and usually execute more slowly

D : An external function accessed through an AWS API Gateway private endpoint can be accessed only from a Snowflake VPC (Virtual Private Cloud) on AWS and in the same AWS region.

Answer: A,B,C,D

Page: 1 / 13

Total 65 Questions | Updated On: Sep 22, 2023

Add To Cart