Exam (elaborations)
Completely accurate answers for the Snowflake SnowPro Core Certification
- Course
- Institution
Completely accurate answers for the Snowflake SnowPro Core Certification
[Show more]
Content preview
1 of 28Term
Snowflake recommends to compress your data files when you are
loading large data sets. t or f
Give this one a try later!
True False
, Don't know?
2 of 28
Term
Choose which architecture is followed by Snowflake:
Give this one a try later!
Hybrid of traditional shared-
disk and shared-nothing Shared disk architecture
database architectures
Multi-Cluster Shared disk
Shared nothing architecture
architecture
Don't know?
3 of 28
Term
Scenario: You had a permanent table named EMPLOYEE but you
have dropped the table. Now, you have created another table with
the same name EMPLOYEE. What will happen If you execute the
UNDROP command?
Give this one a try later!
, HISTORY UNDROP will fil
WAREHOUSE SIZE 4 hours
Don't know?
4 of 28
Term
Which constrains can be enforced in snowflake?
Give this one a try later!
Referential integrity constraints NOT NULL constraint
UNIQUE Constraint
Don't know?
5 of 28
Term
Metadata columns for staged files can only be queried by name
t or f
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller codersimon. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $8.00. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
81531 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now