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, 2026

Add To Cart

Question 1

You have just created a table in snowflake. There are now rows in the table. What will be the clustering depth of the table?

A : 0

B : 1

C : 2

Answer: A

Question 2

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

Question 3

The smaller the average depth, the better clustered the table is with regards to the specified column?

A : TRUE

B : FALSE

Answer: A

Question 4

It is a best practice to avoid binding data using Python's formatting function due to the risk of SQL injection.

A : TRUE

B : FALSE

Answer: A

Question 5

Which system table will you use to get the total credit consumption over a specific time period?

A : WAREHOUSE_METERING_HISTORY

B : WAREHOUSE_CREDIT_USAGE_HISTORY

C : WAREHOUSE_USAGE_HISTORY

Answer: A

Page: 1 / 48

Total 240 Questions | Updated On: Oct 27, 2026

Add To Cart