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: Aug 18, 2026

Add To Cart

Question 1

Which is the non-supportable JavaScript UDF data types?

A : Integers

B : Integers

C : Binary

D : Double

Answer: A

Question 2

What will happen if you try to create a materialized view as below create or replace materialized view employee_view as select id, role, name from employee where role = current_role();

A : Only users with the desired role will be able to retrieve results from the view

B : Only users with the correct role assigned and SYSADMIN will be able to retrieve the results from the view

C : The operation will error out since the function used is a non-deterministic one.

Answer: C

Question 3

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 4

An existing clustering key is copied in which of the below scenarios

A : CREATE TABLE...CLONE

B : CREATE TABLE...LIKE

C : CREATE TABLE...AS SELECT

Answer: A

Question 5

Let us say you have List of 50 Source files, which needs to be loaded into Snowflake internal stage. All these Source system files are already Brotli-compressed files. Which statement is correct with respect to Compression of Staged Files?

A : Even though Source files are already compressed, Snowflake do apply default gzip2 Compression to optimize the storage cost.

B : Snowflake automatically detect Brotli Compression, will skip further compression of all 50 files.

C : Auto-detection is not yet supported for Brotli-compressed files; when staging or loading Brotli-compressed files, you must explicitly specify the compression method that was used

D : When staging 50 compressed files in a Snowflake stage, the files are automatically com-pressed using gzip.

Answer: C

Page: 1 / 48

Total 240 Questions | Updated On: Aug 18, 2026

Add To Cart