Exam DEA-C02 Topic 1 Question 114 Discussion

Actual exam question for Snowflake's DEA-C02 exam
Question #: 114
Topic #: 1

You have created an external table in Snowflake that points to a large dataset stored in Azure Blob Storage. The data consists of JSON files, and you've noticed that query performance is slow. Analyzing the query profile, you see that Snowflake is scanning a large number of unnecessary files. Which of the following strategies could you implement to significantly improve query performance against this external table?

A. Increase the size of the Snowflake virtual warehouse to provide more processing power. B. Partition the data in Azure Blob Storage based on a relevant column (e.g., date) and define partitioning metadata in the external table definition using PARTITION BY. C. Convert the JSON files to Parquet format and recreate the external table to point to the Parquet files. D. Create a materialized view on top of the external table to pre-aggregate the data. E. Create an internal stage, copy all JSON Files, create and load the target table, and drop external table

Suggested Answer: B,C Vote an answer

Partitioning the data (B) allows Snowflake to prune unnecessary files during query execution, significantly improving performance. Converting to Parquet (C) provides a columnar storage format that is more efficient for analytical queries compared to JSON, reducing 1/0 and processing time. Increasing warehouse size (A) might help but is not the most effective strategy. Materialized views (D) are not directly applicable to external tables. Copying all files and creating internal tables is not using the external table functionality (E).

by Myron at Jul 31, 2026, 10:00 AM

Limited Time Offer

15%

Off

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

Comments

Here are all the actual test exam dumps for IT exams. Most people prepare for the actual exams with our test dumps to pass their exams. So it's critical to choose and actual test pdf to succeed.

RECENT DISCUSSIONS

Useful Links

Contact Us

Our Working Time: ( GMT 0:00-15:00 )
From Monday to Saturday

Support: Contact now

If you have any question please leave me your email address, we will reply and send email to you in 12 hours.

Disclaimer:
Actual4test doesn't offer Real SANS and GIAC Exam Questions.
Oracle and Java are registered trademarks of Oracle and/or its affiliates
Actual4test material do not contain actual actual Oracle Exam Questions or material.
Actual4test doesn't offer Real Microsoft Exam Questions.
Microsoft®, Azure®, Windows®, Windows Vista®, and the Windows logo are registered trademarks of Microsoft Corporation
Actual4test Materials do not contain actual questions and answers from Cisco's Certification Exams. The brand Cisco is a registered trademark of CISCO, Inc
CFA Institute does not endorse, promote or warrant the accuracy or quality of these questions. CFA® and Chartered Financial Analyst® are registered trademarks owned by CFA Institute.
Actual4test does not offer exam dumps or questions from actual exams. We offer learning material and practice tests created by subject matter experts to assist and help learners prepare for those exams. All certification brands used on the website are owned by the respective brand owners. Actual4test does not own or claim any ownership on any of the brands.