Level Up Snowflake Key Concepts Flashcards
What attributes make Snowflake a true SaaS solution?
No hardware to purchase or configure.
No maintenance upgrades or patches to install.
Transparent releases don’t require user intervention.
Which instalment option versions of Snowflake are available?
Snowflake-Hosted Accounts (on Amazon cloud infrastructure)
Snowflake-Hosted Accounts (on Google Cloud Platform infrastructure)
Snowflake-Hosted Accounts (on Azure cloud infrastructure)
Which ONE of the following terms BEST describes Snowflake’s Architecture?
Shared Data
Which of the following terms or phrases can also be used to describe Snowflake?
Native SQL
Hybrid Columnar
Built from the ground up for the cloud
Multi-cluster
Which statements are true about storage relationships?
Snowflake Tables are stored within Schemas
Snowflake Schemas are stored within Databases
When a warehouse is resized, which queries make use of the new size?
Only subsequent queries
What are data storage cost calculations based on in Snowflake?
Compressed Size
Amount Stored - Daily Average
Snowflake data storage costs include which types of data?
Persistent data stored in permanent tables
Data retained to enable data recovery (time travel and fail-safe)
Snowflake compute costs depend on which of the following?
The amount of time warehouses have run.
The sizes of running warehouses.
How often does Snowflake release new features?
Weekly
What common tasks for traditional on-premises database and IT staff are not required with Snowflake?
Maintaining metadata
Maintaining statistics
Maintaining the physical security of a server room (key cards, door locks, etc.)