Snowflake SnowPro Advanced Data Engineer Practice Exam

Snowflake SnowPro Advanced Data Engineer Exam Questions with Solutions

Gonzalo Fernandez Plaza
10 min readFeb 14


Attention Snowflake enthusiasts! For the last few months, we’ve taken exam questions from the Snowflake SnowPro Core and the Snowflake SnowPro Advanced Architect certifications. Are you ready to take your data engineering skills to the next level?

Practice Exam Questions for the Snowflake SnowPro Advanced Data Engineer Certification.

This post will look at some practice exam questions designed to help you ace the SnowPro Advanced Data Engineer exam. With hands-on questions and detailed answers, they’ll help you assess your knowledge and boost your confidence before the big day. So buckle up, sharpen your skills, and get ready to tackle the Snowflake SnowPro Advanced Data Engineer exam like a pro!

To take this exam, you must first pass the Snowflake SnowPro Core Certification. Remember that all the chapters from the course can be found at the following link:

Practice Exam Questions

1) What are the steps to load data from an archival cloud storage class (for example, Amazon S3 Glacier or Microsoft Azure Archive Storage) into Snowflake?

  1. Same steps as loading data from a non-archival cloud storage class.
  2. You should create an ARCHIVAL stage; then, you can perform the same steps as loading data from a non-archival cloud storage class.
  3. It’s not possible to do it directly on Snowflake.

Solution: 3. The Archival Cloud Storage Class is cheap to store data, but they have some limitations. For example, taking S3 Glacier as an example, you need to restore the data before accessing it, which requires time (that will depend on the storage class, but it might take up to 48 hours). Because of this, Snowflake cannot access data held in archival cloud storage classes that require restoration before it can be retrieved, so you should change the class in your Cloud Provider before moving it to Snowflake.



Gonzalo Fernandez Plaza

Computer Science Engineer & Tech Lead 🖥️. Publishing AWS & Snowflake ❄️ courses & exams.