Question 1

Which of the below standard API objects are supported by the Snowflake connector for Python

Options :

A : Connection

B : Cursor

C : SnowflakeConnection

D : SnowflakeCursor

Answer: A,B

Question 2

What can you infer from the below query profile?

Options :

A : Less number of bytes of data are read from the cloud storage

B : More bytes are read from the cloud storage

C : The query did a good partition pruning

Answer: A

Question 3

Mark the Incorrect Statements with respect to types of streams supported by Snowflake?

Options :

A : Standard streams cannot retrieve update data for geospatial data.

B : An append-only stream returns the appended rows only and therefore can be much more performant than a standard stream for extract, load, transform (ELT).

C : Insert-only Stream supported on external tables only.

D : An insert-only stream tracks row inserts & Delete ops only

Answer: D

Question 4

Snowflake charges a per-byte fee when users transfer data from your snowflake account into cloud storages in another region on the same cloud platform or into cloud storage in another cloud platform

Options :

A : TRUE

B : FALSE

Answer: A

Question 5

While using kafka connector, what charges are applied to your account?

Options :

A : Snowpipe processing time

B : Data storage

C : Kafka connector usage

Answer: A,B

Smartly Prepare Exam with Free Online DEA-C02 Practice Test

Buying Options: