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: Dec 18, 2025

Add To Cart

Question 1

Which of the below stored procedure will convert null to string?

A : CREATE OR REPLACE PROCEDURE stored_proc_example(TEST_VALUE STRING) RETURNS string LANGUAGE JAVASCRIPT AS $$ if (TEST_VALUE == null) { var str = "String is null"; return str; } else { return TEST_VALUE; } $$ ;

B : CREATE OR REPLACE PROCEDURE stored_proc_example(TEST_VALUE STRING) RETURNS string LANGUAGE JAVASCRIPT AS $$ if (TEST_VALUE === null) { var str = "String is null"; return str; } else { return TEST_VALUE; } $$ ;

C : CREATE OR REPLACE PROCEDURE stored_proc_example(TEST_VALUE STRING) RETURNS string LANGUAGE JAVASCRIPT AS $$ if (TEST_VALUE === 'null') { var str = "String is null"; return str; } else { return TEST_VALUE; } $$ ;

D : CREATE OR REPLACE PROCEDURE stored_proc_example(TEST_VALUE STRING) RETURNS string LANGUAGE JAVASCRIPT AS $$ if (TEST_VALUE == 'null') { var str = "String is null"; return str; } else { return TEST_VALUE; } $$ ;

Answer: A

Question 2

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 3

Which of the below statements are true about search optimization?

A : The search optimization service does not directly improve the performance of joins.

B : It can improve the performance of filtering rows from either table prior to the join, if the table has search optimization enabled and the predicate is selective

C : Search optimization supports external tables

D : Search optimization can improve range searches

Answer: A,B

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

Which of the following System keeps the following characteristics? a. It will keep in it all the raw data.b. Generally, the users of it is data scientists and data developers.c. Flat architectured. Highly agile

A : Data Warehouse

B : Data Mart

C : Data Lake

D : Data Hub

Answer: C

Page: 1 / 48

Total 240 Questions | Updated On: Dec 18, 2025

Add To Cart