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: Jun 17, 2026

Add To Cart

Question 1

When using the CURRENT_ROLE and CURRENT_USER functions with secure UDFs that will be shared with Snowflake accounts, Snowflake returns a NULL value for these functions?

A : TRUE

B : FALSE

Answer: A

Question 2

If a user is granted ROLE-A, what roles he can switch from the Snowflake UI?

A : SYSADMIN, ROLE-A, ROLE-B,ROLE-C,ROLE-D,ROLE-E

B : ROLE-A,ROLE-B,ROLE-C

C : ROLE-A, ROLE-B,ROLE-C,ROLE-D,ROLE-E

D : ROLE-A

Answer: C

Question 3

For a business group, you need to create a table with customer demography data in snowflake. Business users will need to do both range and equality searches on the table. Which of the below techniques will you use to speed up the queries.

A : Create a materialized view on the table and create the required clustering key

B : Turn on search optimization for the table

C : Create a secure view for each of the search access patterns

Answer: A

Question 4

Streams cannot be created to query change data on which of the following objects? [Select All that Apply]

A : Standard tables, including shared tables.

B : Views, including secure views

C : Directory tables

D : Query Log Tables

E : External tables

Answer: D

Question 5

If dataframes are used, the snowflake spark connector does not support the following operations

A : SELECT

B : SHOW

C : DESC

D : INSERT

Answer: B,C,D

Page: 1 / 48

Total 240 Questions | Updated On: Jun 17, 2026

Add To Cart