DEA-C02: SnowPro Advanced — Data Engineer

By Snowflake · Question Mode

QuestionQ3

VerifiedOfficial exam objectives/topics

A Data Engineer is designing a solution to email a customer report files that are generated and stored in a Snowflake stage. The files must be available for download for only 60 minutes because new files will be produced and the older files will become obsolete.

What is the recommended way to satisfy these requirements?

Explanation

A pre-signed URL provides direct temporary access to a staged file without Snowflake authentication, and its expiration_time can be set to 3,600 seconds (60 minutes). SYSTEM$SEND_EMAIL can send the email containing that link. Scoped URLs instead follow the persisted query-results period, currently 24 hours, while stage file URLs require stage privileges and are not temporary.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!