SnowPro Advanced Data Engineer DEA-C02

SnowPro Advanced Data Engineer DEA-C02 practice questions, page 3 of 3, with answer review and explanations.

Question 11

A Data Engineer needs to create a stage that will be used to ingest files from a Customer Relationship Management (CRM) system. These are the requirements for the stage: 1. Use of an internal named stage with different folders that will be the repositories for the files 2. The files must be encrypted by the cloud service hosting the Snowflake account when they arrive on the stage 3. The files will be queried later using pre-signed URLs 4. Ability to query a metadata list of all the unstructured files on the stage Which statement will meet these requirements? A. B. C. D.

Question 12

Which command will load all data successfully into the table named finance_dept_location? A. B. C. D.

Question 13

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?

  1. Share data using a scoped URL and the SYSTEM$SEND_EMAIL function.
  2. Share data using pre-signed URL and the SYSTEM$SEND_EMAIL function.
  3. Share data using a stage file URL and the SYSTEM$SEND_EMAIL function.
  4. Share data using a scoped URL and write a custom Python script to send the email.