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…

Question

Options

• AConfigure the client application to call the Snowpipe REST endpoint when new files have arrived in
• BConfigure the client application to call the Snowpipe REST endpoint when new files have arrived in
• CCreate an AWS Lambda function to call the Snowpipe REST endpoint when new files have arrived
• DConfigure AWS Simple Notification Service (SNS) to notify Snowpipe when new files have arrived
• EConfigure the client application to issue a COPY INTO <TABLE> command to Snowflake when

• A
  77% (30)
• B
  15% (6)
• D
  3% (1)
• E
  5% (2)

Explanation

Snowpipe is a feature that enables continuous, near-real-time data ingestion from external sources into Snowflake tables. Snowpipe can ingest files from Amazon S3, Google Cloud Storage, or Azure Blob Storage into Snowflake tables on any cloud platform. Snowpipe can be triggered in two ways: by using the Snowpipe REST API or by using cloud notifications. To ingest files from the company's AWS storage accounts into the company's Snowflake GCP account, the Architect can use either of these methods: Configure the client application to call the Snowpipe REST endpoint when new files have arrived in Amazon S3 storage. This method requires the client application to monitor the S3 buckets for new files and send a request to the Snowpipe REST API with the list of files to ingest. The client application must also handle authentication, error handling, and retry logic Create an AWS Lambda function to call the Snowpipe REST endpoint when new files have arrived in Amazon S3 storage. This method leverages the AWS Lambda service to execute a function that calls the Snowpipe REST API whenever an S3 event notification is received. The AWS Lambda function must be configured with the appropriate permissions, triggers, and code to invoke the Snowpipe

No community discussion yet for this question.