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: Oct 27, 2025

Add To Cart

Question 1

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 2

If an external function is secure, the URL, the HTTP headers, and the context headers are hidden from all users who are not owners of the function.

A : TRUE

B : FALSE

Answer: A

Question 3

Lets say you created a schema and a table as below CREATE OR REPLACE SCHEMA TIME_TRAVEL_SCHEMA DATA_RETENTION_TIME_IN_DAYS =10; CREATE OR REPLACE TABLE TIME_TRAVEL_SCHEMA.TIME_TRAVEL_TABLE (ID NUMBER) DATA_RETENTION_TIME_IN_DAYS =20;Later you dropped the schema. In this scenario what data retention value will be honored for the table, if we need to retrieve the table data

A : 10

B : 20

C : 30

Answer: A

Question 4

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 5

Which of the following statements is/are incorrect regarding Fail-safe data recovery?

A : Data stored in temporary tables is not recoverable after the table is dropped as they do not have fail-safe.

B : Historical data in transient tables can be recovered by Snowflake due to Operation fail-ure after the Time Travel retention period ends using Fail-safe.

C : Long-lived tables, such as fact tables, should always be defined as permanent to ensure they are fully protected by Fail-safe.

D : Short-lived tables (i.e.

E : If downtime and the time required to reload lost data are factors, permanent tables, even with their added Fail-safe costs, may offer a better overall solution than transient tables.

Answer: B

Page: 1 / 48

Total 240 Questions | Updated On: Oct 27, 2025

Add To Cart