Snowflake SnowPro Core Certification
Questions and Answers 100% Accurate
True or False? Metadata is created when you load data from a file in an internal stage to a
Snowflake table. - ANSWER - True
True or False? Are Snowpipe charges calculated per second and per core? - ANSWER - True
What types of views are available in Snowflake? - ANSWER - Regular, secure and materialized
What character identifies a table stage? - ANSWER - @%
What are the types of internal stages? - ANSWER - User, table, internal named
What character identifies a user stage? - ANSWER - @~
What is the difference between an internal stage and an external stage? - ANSWER - Internal
stages store the data directly within Snowflake. External stages store files in an external o
What do you use to share data with another Snowflake customer? - ANSWER - Direct share
What type of account do you use to share with others who are not Snowflake customers? -
ANSWER - Reader account
True or False? If a warehouse is on but not being used, you are still charged for that hour. -
ANSWER - True
True or False? If you resize a warehouse while a query is running, the query will finish with the
original Warehouse size. - ANSWER - True
Sizing a Warehouse up an down allows for
, A) More complex queries
B) More queries - ANSWER - More ecomplex queries
Does Snowflake automatically store data in encrypted form in all editions? - ANSWER - True
What types of streams exist in Snowflake? - ANSWER - 1. Standard
2. Append-only
3. Insert-only
Is Snowpipe serverless? - ANSWER - True
Does data stored in a temporary table not contribute to storage cost? - ANSWER - False
What is the default auto suspend time for a warehouse? - ANSWER - 10 Minutes
How many days of time travel come with the standard edition? - ANSWER - 1 day
How many days of time travel come with the enterprise edition? - ANSWER - 90 days
What features are only available with the business critical edition? - ANSWER - HIPPA support,
PCI compliance,
Database failover and failback
What features are available in the enterprise edition that are not available in the standard
edition? - ANSWER - Multi-cluster warehouse,
Annual rekeying of encrypted data,
Dynamic data masking
External data tokenization
How much does on demand storage cost per TB and month? - ANSWER - $40
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 NursingTutor1. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $11.99. You're not tied to anything after your purchase.
