Snowflake SnowPro Certification
Study Guide Exam Questions with
Correct Verified Solutions 100%
Guaranteed Pass
1. What are the three "higher editions" (stronger security) of
Snowflake? - ANS ✓1) Enterprise
2) Enterprise for Sensitive Data
3) Virtual Private Snowflake
2. What security protections does Snowflake provide - ANS ✓-
Single Sign On through federated authentication
- Periodic Rekeying of encrypted data
- HIPPA Compliance
- PCI DSS Compliance
3. What cost does the Provider incur in the Data Sharing process? -
ANS ✓Data Storage costs, there's no upcharge for shared data
4. What cost does the Consumer incur in the Data Sharing process?
- ANS ✓Compute costs
5. Data Sharing Consumers must use the ACCOUNTADMIN role to
create a database based on the share (T/F) - ANS ✓True
Snowflake SnowPro Certification Study Guide
, 2
Snowflake
6. Data Sharing Consumers can consume data residing from any
region (T/F) - ANS ✓False - Consumer accounts must reside in the
same Cloud Provider Region as the Provider account
7. Providers can only share data with users who have accounts
(T/F) - ANS ✓False - Providers can set up reader accounts for users
who aren't snowflake customers
8. What are schemas? Is there a limit to the objects contained in a
schema? - ANS ✓Logical groupings of database objects, such as
tables and views by concept or purpose. There's no limit to objects
contained in a schema.
9. You can have multiple databases in one schema (T/F) - ANS
✓False - Schemas exist within databases. You can have multiple
schemas within one database though.
10. What are sequences? - ANS ✓Sequences are used to generate
unique numbers across sessions and statements, including
concurrent statements
11. Virtual Warehouses have to be manually turned off (T/F) -
ANS ✓False - Auto-suspending can turn them off
12. Auto-Suspension limits has to be determined when the
Virtual Warehouse is configured (T/F) - ANS ✓False - it can be
changed after initial configuration
Snowflake SnowPro Certification Study Guide
, 3
Snowflake
13. How is compute billing charged (units of time) - ANS
✓Compute is charged for a base 1 minute of start up and then each
second following that
14. What is the max size of VARIANT data in a column? - ANS
✓16 MB compressed
15. What is the difference in query impact between regular
JSON types (strings and numbers) and non-native JSON types
(timestamps) - ANS ✓Regular JSON types are easier and quicker to
query than Non-Native types
16. What are the 4 mains sections of the Snowflake UI - ANS
✓1) Databases - Storage
2) Warehouses - Compute
3) Worksheets
4) History
(ACCOUNTADMIN sees the account area)
17. What are Snowflake connectivity options? - ANS ✓1)
SnowSQL
2) ODBC
3) JDBC
4) Python
5) Node.JS
18. What are the two commands for loading data? How do they
differ? - ANS ✓1) Copy - Bulk insert and more performant
2) Insert - Row-by-row insert and less performant
Snowflake SnowPro Certification Study Guide
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 DoctorKen. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $11.49. You're not tied to anything after your purchase.
