Exam (elaborations)
SnowPro Core Practice Exam -2 Questions with 100% Correct Answers
- Course
- Institution
SnowPro Core Practice Exam -2 Questions with 100% Correct Answers
[Show more]
Content preview
1 of 57Term
Which statements are correct about micro-partitions in SnowFlake?
Give this one a try later!
Tables
SnowFlake users can have one or
External tables
more roles
Secure views
Only a role can be active for a
Secure materialized views
particular session
Secure UDFs
, Contiguous units of storage Data Stored in permanent tables.
50 and 500MB of Data Stored in temporal tables.
uncompressed data Data retained for Fail-Safe & Time-
Organized in a columnar way Travel
Don't know?
2 of 57
Term
After how many days does the load history of the COPY command
expire?
Give this one a try later!
Enterprise False
GET, PUT 64 days
Don't know?
3 of 57
Term
If you want a dedicated virtual warehouse, which is the lowest
SnowFlake edition you should opt for?
,Give this one a try later!
64 days Standard
4 hours False
Don't know?
4 of 57
Term
What types of tables are available in SnowFlake?
Give this one a try later!
Permanent
Temporary We have a small volume of frequent
Transient data
External
User
METADATA$FILENAME Table
METADATA$FILE_ROW_NUMBER Named internal
Named external
Don't know?
5 of 57
Term
, Cached results do not incur Storage costs.
Give this one a try later!
True False
Don't know?
6 of 57
Term
If the data in the Storage Layer changes, the caches are
automatically invalidated.
Give this one a try later!
True False
Don't know?
7 of 57
Term
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)
75619 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now