Exam DEA-C02 Topic 1 Question 279 Discussion

Actual exam question for Snowflake's DEA-C02 exam
Question #: 279
Topic #: 1
You have data residing in AWS S3 in Parquet format, which is updated daily with new columns being added occasionally. The data is rarely accessed, but when it is, it needs to be queried using SQL within Snowflake. You want to minimize storage costs within Snowflake while ensuring the data can be queried without requiring manual table schema updates every time a new column is added to the S3 data'. Which approach is MOST suitable?

Suggested Answer: B Vote an answer

Option B is the most suitable because external tables with AUTO REFRESH enabled and properly configured file format (Parquet in this case) support schema evolution automatically. When new columns are added to the S3 data, Snowflake will detect these changes and update the external table's metadata accordingly. This eliminates the need for manual schema updates and minimizes storage costs because the data remains in S3. AUTO_REFRESH needs a configured notification integration. Option A will require manual ALTER TABLE ADD COLUMN commands which are not scalable, option C introduces unnecessary complexity with Spark. Option D using COPY INTO does not support external storage locations. Option E requires manual refresh.

by Janet at Jul 03, 2026, 11:52 PM

Limited Time Offer

15%

Off

Get Premium DEA-C02 Questions as Interactive Self Test Engine or PDF

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
Nick name: Submit Cancel
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
0
0
0
10