Snowflake Features & Architecture - Quiz Flashcards
What is a disadvantage of the shared disk architecture?
The storage is potentially a single point of failure.
What is one disadvantage of the shared nothing architecture?
Storage and compute is tightly coupled.
What makes Snowflake a “cloud native” product?
Snowflake was designed to make use of the unique capabilities of the cloud.
Snowflake is a ANSI compliant SQL database. True or false?
True
Which type of cloud computing service is Snowflake?
SaaS
Users can SSH into the compute instances which make up a virtual warehouse. True or false?
False
What type of data storage format does Snowflake store table data in?
Columnar
Standard edition accounts have the Time Travel feature. True or false?
True
Enterprise edition encompasses all the features of standard edition. True or false?
True
Business critical edition accounts have additional support for regulation compliance around data protection. True or false?
True
Virtual private Snowflake allows the user to host a deployment of Snowflake on their on-premise infrastructure. True or false?
False
The object container hierarchy exists in what order?
Organization>Account>Database>Schema
All objects are individually securable. True or false?
True
