SOL-C01 Question #268: Real Exam Question with Answer & Explanation

Question

A data engineer needs to load data from an Amazon S3 bucket into Snowflake. The data is in CSV format, compressed with GZIP, and contains a header row. They want to use Snowpipe for continuous data loading. The S3 bucket is properly configured with an SNS topic and SQS queue. Given the following Snowflake objects: CREATE OR REPLACE FILE FORMAT TYPE = CSV COMPRESSION = GZIP FIELD DELIMITER = ',' SKIP_HEADER = 1; CREATE OR REPLACE STAGE URL = 's3://my- bucket/data/' CREDENTIALS = CAWS_KEY ID = AWS SECRET KEY = CREATE OR REPLACE PIPE my_snowpipe AS COPY INTO my_table FROM FILE FORMAT = (FORMAT = After creating the pipe, no data is loaded automatically. What is the MOST likely reason for this?

Options

• AThe SNS topic in S3 is not correctly configured to send notifications to the SQS queue.
• BThe "SKIP_HEADER = 1' parameter in the file format is preventing Snowpipe from recognizing the
• CThe user executing the 'CREATE PIPE statement lacks the necessary privileges to access the S3
• DThe pipe needs to be explicitly refreshed using 'ALTER PIPE my_snowpipe REFRESH;' before it
• EThe SQS queue policy doesn't grant Snowflake the necessary permissions to receive messages.

Explanation

The most likely reason is that either the SNS topic is not correctly sending messages to the SQS queue, or the SQS queue policy is not granting Snowflake the necessary permissions. Snowpipe relies on this notification mechanism. While 'SKIP HEADER = 1' is valid, it won't prevent automatic data loading. Pipes are auto-ingesting, so Refresh is not part of correct answer here. Credentials are also required to be correct for data loading.

No community discussion yet for this question.