SnowPro Advanced: Architect — Question 92

An Architect needs to meet a company requirement to ingest files from the company’s AWS storage accounts into the company's Snowflake Google Cloud Platform (GCP) account.

How can the ingestion of these files into the company's Snowflake account be initiated? (Choose two.)

Answer options

• A. Configure the client application to call the Snowpipe REST endpoint when new files have arrived in Amazon S3 storage.
• B. Configure the client application to call the Snowpipe REST endpoint when new files have arrived in Amazon S3 Glacier storage.
• C. Create an AWS Lambda function to call the Snowpipe REST endpoint when new files have arrived in Amazon S3 storage.
• D. Configure AWS Simple Notification Service (SNS) to notify Snowpipe when new files have arrived in Amazon S3 storage.
• E. Configure the client application to issue a COPY INTOcommand to Snowflake when new files have arrived in Amazon S3 Glacier storage.

Correct answer: A, C

Explanation

Option A is correct because the Snowpipe REST endpoint can be triggered when new files arrive in Amazon S3, allowing for automatic data ingestion. Option C is also valid as an AWS Lambda function can be created to automate the invocation of the Snowpipe REST endpoint. Options B, D, and E are incorrect; B and E involve Amazon S3 Glacier, which is not directly supported for Snowpipe ingestion, while D does not initiate ingestion directly into Snowflake.