Practice DSA-C02 Exam Online

Question 1

Which one is not the types of Feature Engineering Transformation?

A : Scaling

B : Encoding

C : Aggregation

D : D. Normalization

Answer: C

Question 2

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 3

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 4

As Data Scientist looking out to use Reader account, Which ones are the correct considerations about Reader Accounts for Third-Party Access?

A :

Reader accounts (formerly known as read-only accounts) provide a quick, easy, and cost-effective way to share data without requiring the consumer to become a Snowflake customer.

B : Each reader account belongs to the provider account that created it.

C :

Users in a reader account can query data that has been shared with the reader account, but cannot perform any of the DML tasks that are allowed in a full account, such as data loading, insert, update, and similar data manipulation operations.

D : Data sharing is only possible between Snowflake accounts.

Answer: D

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

Name:	SnowPro Advanced Data Scientist Certification
Exam Code:	DSA-C02
Certification:	SnowPro Certification
Vendor:	Snowflake
Total Questions:	65
Last Updated:	Apr 25, 2024

Snowflake DSA-C02