nerdexam
SnowflakeSnowflake

DEA-C02 · Question #77

DEA-C02 Question #77: Real Exam Question with Answer & Explanation

Sign in or unlock DEA-C02 to reveal the answer and full explanation for question #77. The question stem and answer options stay visible for context.

Data Movement

Question

A Data Engineer is developing a data pipeline to ingest data from an Amazon S3 bucket into a Snowflake table. Files will be loaded into the S3 bucket randomly, with most files loaded during working hours. The files are in a compressed CSV format (*.csv.gz) and average 100 MB per file. The data ingestion requirements are listed in order of priority: 1. MOST cost-effective method 2. LEAST amount of operational overhead 3. New data MUST be available within 10 minutes of the creation of a file Which ingestion method will meet these requirements?

Options

  • ASnowpipe
  • BSnowpipe Streaming
  • CSnowflake Kafka Connector
  • DThe COPY INTO <location> command

Unlock DEA-C02 to see the answer

You've previewed enough free DEA-C02 questions. Unlock DEA-C02 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.

Topics

#Snowpipe#Data Ingestion#Cost Optimization#S3 Integration
Full DEA-C02 PracticeBrowse All DEA-C02 Questions