nerdexam
SnowflakeSnowflake

ARA-C01 · Question #153

ARA-C01 Question #153: Real Exam Question with Answer & Explanation

Sign in or unlock ARA-C01 to reveal the answer and full explanation for question #153. The question stem and answer options stay visible for context.

Data Integration and Pipelines

Question

A media company needs a data pipeline that will ingest customer review data into a Snowflake table, and apply some transformations. The company also needs to use Amazon Comprehend to do sentiment analysis and make the de-identified final data set available publicly for advertising companies who use different cloud providers in different regions. The data pipeline needs to run continuously and efficiently as new records arrive in the object storage leveraging event notifications. Also, the operational complexity, maintenance of the infrastructure, including platform upgrades and security, and the development effort should be minimal. Which design will meet these requirements?

Options

  • AIngest the data using copy into and use streams and tasks to orchestrate transformations. Export
  • BIngest the data using Snowpipe and use streams and tasks to orchestrate transformations. Create
  • CIngest the data into Snowflake using Amazon EMR and PySpark using the Snowflake Spark
  • DIngest the data using Snowpipe and use streams and tasks to orchestrate transformations. Export

Unlock ARA-C01 to see the answer

You've previewed enough free ARA-C01 questions. Unlock ARA-C01 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#Streams and Tasks#Serverless ELT#Event-driven Data Pipelines
Full ARA-C01 PracticeBrowse All ARA-C01 Questions