1. Home
  2. Discussions
  3. Snowflake
  4. SnowPro Advanced Certification
  5. DEA-C01 Discussions
  6. DEA-C01 Exam Topic 1 Question 1 Discussion

Snowflake SnowPro Advanced: Data Engineer Certification Exam DEA-C01 Question # 1 Topic 1 Discussion

 Snowflake Discussions      Browse All Questions      Go to Exam Detail      Get Premium Access
Next  

Snowflake SnowPro Advanced: Data Engineer Certification Exam DEA-C01 Question # 1 Topic 1 Discussion

DEA-C01 Exam Topic 1 Question 1 Discussion:
Question #: 1
Topic #: 1

A large table with 200 columns contains two years of historical data. When queried. the table is filtered on a single day Below is the Query Profile:

DEA-C01 Question 1

Using a size 2XL virtual warehouse, this query look over an hour to complete

What will improve the query performance the MOST?
A.

increase the size of the virtual warehouse.

B.

Increase the number of clusters in the virtual warehouse

C.

Implement the search optimization service on the table

D.

Add a date column as a cluster key on the table

Get Premium DEA-C01 Questions
Actual exam question for Snowflake DEA-C01 exam by Cyra353 at Aug 4, 2025, 6:14:38 AM

Contribute your Thoughts:


Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.

Submit
Next