Free Snowflake DEA-C02 Exam Questions

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

Page: 1 / 48

Total 240 Questions | Updated On: Apr 03, 2026

Add To Cart

Question 1

What can you infer from the below query profile?

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 2

You have just created a table in snowflake. There are now rows in the table. What will be the clustering depth of the table?

A : 0

B : 1

C : 2

Answer: A

Question 3

Snowflake does not provide which of following set of SQL functions to support retrieving infor-mation about tasks?

A : SYSTEM$CURRENT_USER_TASK_NAME

B : TASK_HISTORY

C : TASK_DEPENDENTS

D : TASK_QUERY_HISTORY

E : SYSTEM$TASK_DEPENDENTS_ENABLE

Answer: C

Question 4

If using a JavaScript UDF in a masking policy, Data Engineer needs to ensure the data type of the column, UDF, and masking policy match irrespective of case-sensitivity?

A : TRUE

B : FALSE

Answer: B

Question 5

Snowflake does not treat the inner transaction as nested; instead, the inner transaction is a separate transaction. What is term used to call these Transaction?

A : Scoped transactions

B : Inner Transaction

C : Nested Scope Transaction

D : Atomic Transaction

E : Enclosed Transaction

Answer: A

Page: 1 / 48

Total 240 Questions | Updated On: Apr 03, 2026

Add To Cart