Exam SnowPro Advanced Architect All QuestionsBrowse all questions from this exam
Question 76

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.)

    Correct Answer: A, C

    To initiate the ingestion of files into the company's Snowflake account from AWS S3 storage, the process typically involves detecting new files in S3 and triggering Snowpipe for data loading. Configuring a client application to call the Snowpipe REST endpoint when new files arrive in Amazon S3 storage (Option A) provides a direct and flexible method for initiating ingestion. Additionally, creating an AWS Lambda function to call the Snowpipe REST endpoint when new files arrive in Amazon S3 storage (Option C) is another efficient approach leveraging Amazon's serverless computing to handle the event-driven architecture for automatically triggering Snowpipe ingestion.

Discussion
MSIDDIQUI18Options: AC

A: This approach involves configuring a client application to detect new files in Amazon S3 and call the Snowpipe REST API to trigger the data loading process into Snowflake. This method provides flexibility and control over the ingestion process. C: Using AWS Lambda to automate the process of detecting new files in Amazon S3 and calling the Snowpipe REST API is an efficient and serverless solution. This approach leverages AWS Lambda's event-driven architecture to trigger Snowpipe ingestion automatically.