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: Feb 20, 2026

Add To Cart

Question 1

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

A : TRUE

B : FALSE

Answer: A

Question 2

You can execute zero, one, or more transactions inside a stored procedure?

A : TRUE

B : FALSE

Answer: A

Question 3

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 4

Which of the following objects are automatically created by the KAFKA connector?

A : One internal stage to temporarily store data files for each topic.

B : One pipe to ingest the data files for each topic partition.

C : One table for each topic

D : One external stage to temporarily store data files for each topic.

Answer: A,B,C

Question 5

David, a Lead Data engineer with XYZ company looking out to improve query performance & oth-er benefitswhile working with Tables, Regular Views, MVs and Cached Results.Which one of the following does not shows key similarities and differences between tables, regular views,cached query results, and materialized views while choosing any of them by David?

A : Regular views do not cache data, and therefore cannot improve performance by cach-ing.

B : As with non-materialized views, a materialized view automatically inherits the privileges of its base table.

C : Cached Query Results: Used only if data has not changed and if query only uses de-terministic functions (e.g. not CURRENT_DATE).

D : Materialized views are faster than tables because of their “cache” (i.e. the query results for the view); in addition, if data has changed, they can use their “cache” for data that hasn’t changed and use the base table for any data that has changed.

E : Both materialized views and regular views enhance data security by allowing data to be exposed or hidden at the row level or column level.

Answer: B

Page: 1 / 48

Total 240 Questions | Updated On: Feb 20, 2026

Add To Cart