What are the 3 Cloud Providers available for Snowflake
1) AWS - a provider since inception
2) Azure Cloud Platforms - generally available as of Sept. 2018
3) Google Cloud Platform - trialed late 2019
Snowflake is cur
...
What are the 3 Cloud Providers available for Snowflake
1) AWS - a provider since inception
2) Azure Cloud Platforms - generally available as of Sept. 2018
3) Google Cloud Platform - trialed late 2019
Snowflake is currently the only DW built for the cloud (T/F)
True
How does Snowflake describe their architecture?
A) Multi-Cluster, Shared Data
B) Single-Cluster, Shared Data
A) Multi-Cluster, Shared Data
What are the 3 components of Snowflake's architecture (both the name and descriptor)
1) Storage - Databases
2) Compute - Virtual Warehouses
3) Cloud Services - Front End
What are the Cloud Object Storage options?
1) AWS S3
2) Azure Blobs
3) GCP
How are storage costs calculated?
A daily average of all compressed data storage, including data stored according to Time Travel retention policy and failsafe procedures
Which Microsoft and Amazon systems does Compute leverage?
1) AWS EC2
2) Azure Compute
Compute can't scale out as queries are running (T/F)
False
Which services does Cloud Services provide?
1) Security Management
2) Infrastructure Management
3) Metadata Management
4) Query Optimization
Are Snowflake's Storage (DB) and Compute (WH) layers
A) Separate and Independent
B) Together and Dependent
A) Separate and Independent
In addition to multiple Virtual Warehouses, Multi-Cluster means individual Virtual Warehouses can...
Scale up or down automatically
Multi-Cluster turn off clusters when activity slows down (T/F)
True
Snowflake uses ANSI-SQL (T/F)
True
What is Snowflake's semi-structured data type called?
VARIANT
What are the three types of caching in Snowflake?
1) Warehouse
2) Metadata
3) Results
All cache data are cleared if the underlying data changes (T/F)
True
What does Warehouse Caching do? When is the data invalidated? Where does it live?
Stores data that's been loaded into Virtual Warehouses during querying. The data is invalidated if it's suspended. Lives in Compute.
What does Metadata Caching do? Where does it live?
It stores various info about tables. It lives in the Cloud Services layer.
What does Results Caching do? Where does it live?
It stores results of queries that have been executed within the past 24 hours (assuming underlying data hasn't changed). It lives in the Cloud Services Layer.
A customer needs to have a preexisting account with AWS or Azure in order to have a Snowflake account (T/F)
False
What are Availability Zones?
Data centers in certain regions
How many availability zones is your data replicated in?
3 data zones in a region
What does it mean by "automatic" micro-partitions
A partition scheme doesn't need to be defined up front. Snowflake determines and creates it.
Data partitioning is automatically completed in the natural ingestion order (T/F)
True
New Partitions are based on physical properties (T/F)
True
How does Snowflake optimize storage of semi-structured data?
Repeated elements within the strings
How far back does the Time Travel protection go?
90 days
Zero-Copy Cloning operates on more than just the metadata (T/F)
False - It's a metadata-only operation
There's a difference in storage cost allocation between structured and semi-structured data (T/F)
False - There's no difference
A user can't be assigned multiple roles (T/F)
False - A user can be assigned multiple roles
If a user creates an object, what permissions do others have?
All users with the role that created the object will have access to it, as well as the users and roles that the role that created the object role up to.
Which encryption method is used?
AES 256 Strong Encryption
What are the three "higher editions" (stronger security) of Snowflake?
1) Enterprise
2) Enterprise for Sensitive Data
3) Virtual Private Snowflake
What security protections does Snowflake provide
- Single Sign On through federated authentication
- Periodic Rekeying of encrypted data
- HIPPA Compliance
- PCI DSS Compliance
What cost does the Provider incur in the Data Sharing process?
Data Storage costs, there's no upcharge for shared data
What cost does the Consumer incur in the Data Sharing process?
Compute costs
Data Sharing Consumers must use the ACCOUNTADMIN role to create a database based on the share (T/F)
True
Data Sharing Consumers can consume data residing from any region (T/F)
False - Consumer accounts must reside in the same Cloud Provider Region as the Provider account
Providers can only share data with users who have accounts (T/F)
False - Providers can set up reader accounts for users who aren't snowflake customers
What are schemas? Is there a limit to the objects contained in a schema?
Logical groupings of database objects, such as tables and views by concept or purpose. There's no limit to objects contained in a schema.
You can have multiple databases in one schema (T/F)
False - Schemas exist within databases. You can have multiple schemas within one database though.
What are sequences?
Sequences are used to generate unique numbers across sessions and statements, including concurrent statements
Virtual Warehouses have to be manually turned off (T/F)
False - Auto-suspending can turn them off
Auto-Suspension limits has to be determined when the Virtual Warehouse is configured (T/F)
False - it can be changed after initial configuration
[Show More]
