Free Snowflake DEA-C02 Practice Exam Questions and Answers 2026

Start Learning with the Newest and 100% Free DEA-C02 Exam Dumps Questions

Page: 1 / 48

Total 240 Questions | Updated On: Apr 03, 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

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

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

Question 4

Mark the Incorrect Statements with respect to types of streams supported by Snowflake?

A : Standard streams cannot retrieve update data for geospatial data.

B : An append-only stream returns the appended rows only and therefore can be much more performant than a standard stream for extract, load, transform (ELT).

C : Insert-only Stream supported on external tables only.

D : An insert-only stream tracks row inserts & Delete ops only

Answer: D

Question 5

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

Page: 1 / 48

Total 240 Questions | Updated On: Apr 03, 2026

Add To Cart