SnowPro Advanced: Data Engineer — Question 115

A Data Engineer is designing a solution that will send report files generated and stored in a Snowflake stage to a customer, using email. The files can only be available for download for 60 minutes as new files will be generated and the old ones become obsolete.

What is the recommended way to meet these requirements?

Answer options

• A. Share data using a scoped URL and the SYSTEM$SEND_EMAIL function.
• B. Share data using pre-signed URL and the SYSTEM$SEND_EMAIL function.
• C. Share data using a stage file URL and the SYSTEM$SEND_EMAIL function.
• D. Share data using a scoped URL and write a custom Python script to send the email.

Correct answer: B

Explanation

The correct answer is B because a pre-signed URL allows temporary access to the file for a specific time, fitting the 60-minute requirement. Option A is incorrect as scoped URLs do not provide the necessary time-limited access. Option C does not offer a pre-signed URL, which is essential for secure temporary access, and option D relies on a custom script, which is unnecessary when a built-in function is available.