Exam DEA-C02 Topic 1 Question 35 Discussion

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

You are tasked with building a data pipeline that incrementally loads data from an external cloud storage location (AWS S3) into a Snowflake table named 'SALES DATA'. You want to optimize the pipeline for cost and performance. Which combination of Snowflake features and configurations would be MOST efficient and cost-effective for this scenario, assuming the data volume is substantial and constantly growing?

A. Use a Snowflake Task scheduled every 5 minutes to execute a COPY INTO command from S3, with no file format specified, assuming the data is CSV and auto-detection will work. B. Create an external stage pointing to the S3 bucket. Create a Snowpipe with auto-ingest enabled, using an AWS SNS topic and SQS queue for event notifications. Configure the pipe with an error notification integration to monitor ingestion failures. C. Develop a custom Python script that uses the Snowflake Connector for Python to connect to Snowflake and execute a COPY INTO command. Schedule the script to run on an EC2 instance using cron. D. Employ a third-party ETL tool to extract data from S3, transform it, and load it into Snowflake using JDBC. Schedule the ETL process using the tool's built-in scheduler. E. Use a Snowflake Task to regularly truncate and reload 'SALES DATA" from S3 using COPY INTO. This ensures data consistency.

Suggested Answer: B Vote an answer

Snowpipe with auto-ingest is the most efficient and cost-effective solution for continuously loading data into Snowflake from cloud storage. It leverages event notifications to trigger data loading as soon as new files are available, minimizing latency and compute costs. Option A lacks error handling and proper file format specification. Option C involves custom coding and infrastructure management. Option D introduces overhead and costs associated with a third-party ETL tool. Option E is inefficient as it truncates and reloads the entire table, losing any incremental loading benefits.

by Dominic at Jul 01, 2026, 03:59 AM

Limited Time Offer

15%

Off

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

Comments

0 Happy Clients

0 Shares

0 Demo Downloads

10 Years in Business