SnowPro Advanced: Data Engineer — Question 76

How should a Data Engineer build a pipeline that executes a stored procedure to parse and load unstructured data files as the files arrive in a stage?

Answer options

• A. Create a Snowpipe with the parameter AUTO_INGEST = TRUE.
• B. Create a Snowpipe that includes the INTEGRATION = ‘’ parameter.
• C. Create a stage with parameter ENCODING = ‘’ to call the procedure when flies land in the stage.
• D. Create a stage with a directory table, a stream on the directory table, and a task referencing the stream.

Correct answer: D

Explanation

The correct answer is D because it effectively uses a directory table and a stream to monitor the stage for new files and trigger the task to execute the stored procedure when files arrive. Options A and B do not directly relate to executing a stored procedure upon file arrival, and option C does not provide a mechanism for automatic execution when files land in the stage.