Snowflake SnowPro Core Certification Practice Exam

Snowflake SnowPro Core Practice Exam with Solutions Part 1

Gonzalo Fernandez Plaza
14 min readApr 5, 2022

--

Snowflake SnowPro Core Practice Exam.
Snowflake SnowPro Core Practice Exam.

During these last months, we have studied how Snowflake works in detail, along with some questions to prepare for the Snowflake SnowPro Core Certification. Apart from that, after each chapter, we solved exercises to see if we understood everything.
We will take random questions from each chapter to practice for the official exam in this chapter. Remember, we need 80 points to pass it! If we don’t reach this number, I recommend you reread the chapters in which we missed some questions and try the test again. Good luck, and go for it!

Remember that you can find all the chapters from the course at the following link:

QUESTIONS WITH SOLUTIONS

1: What types of views are available in Snowflake?

  1. Regular
  2. Secure View
  3. Table View
  4. Materialized View
  5. External View

Solution: 1, 2, 4. You can see the differences between them in the following image:

Difference between Snowflake views.
Difference between Snowflake views.

2: Which character identifies a table stage?

  1. “@”
  2. “%”
  3. “/@”
  4. “@%”

Solution: 4. The following example shows how we can upload files from our local disk to a Table stage. As you can see, you need to specify the previous character while indicating the table:

PUT file://c:/myData/myCSV.csv @%myTable

3: Select two limitations with materialized views:

  1. Time Travel is not supported.
  2. We cannot define Cluster Keys.
  3. Streams cannot track changes.

--

--

Gonzalo Fernandez Plaza

Computer Science Engineer & Tech Lead 🖥️. Publishing AWS & Snowflake ❄️ courses & exams. https://www.fullcertified.com