Snowflake SnowPro Core Certification Practice Exam
Snowflake SnowPro Core Practice Exam with Solutions Part 1
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:
Road to SnowFlake SnowPro Core Certification: Complete Course
An overview for the SnowFlake SnowPro Core Certification preparation course, the data-warehousing platform built for…
QUESTIONS WITH SOLUTIONS
1: What types of views are available in Snowflake?
- Secure View
- Table View
- Materialized View
- External View
Solution: 1, 2, 4. You can see the differences between them in the following image:
2: Which character identifies a table stage?
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:
- Time Travel is not supported.
- We cannot define Cluster Keys.
- Streams cannot track changes.