Level 2: Snowflake Key concepts

Question 1

What attributes make Snowflake a true SaaS solution?

Answer 1

No hardware to purchase or configure.
No maintenance upgrades or patches to install.
Transparent releases don’t require user intervention.

Question 2

Which installment option versions of Snowflake are available?

Answer 2

Snowflake-Hosted Accounts (on Amazon cloud infrastructure)
Snowflake-Hosted Accounts (on Google Cloud Platform infrastructure)
Snowflake-Hosted Accounts (on Azure cloud infrastructure)

Question 3

Which ONE of the following terms BEST describes Snowflake’s Architecture?

Answer 3

Shared Data

Question 4

Which of the following terms or phrases can also be used to describe Snowflake?

Answer 4

Native SQL
Hybrid Columnar
Built from the ground up for the cloud
Multi-cluster

Question 5

Which statements are true about storage relationships?

Answer 5

Snowflake Tables are stored within Schemas
Snowflake Schemas are stored within Databases

Question 6

When a warehouse is resized, which queries make use of the new size?

Answer 6

Only subsequent queries

Question 7

What are data storage cost calculations based on in Snowflake?

Answer 7

Compressed Size
Amount Stored - Daily Average

Question 8

Snowflake data storage costs include which types of data?

Answer 8

Persistent data stored in permanent tables
Data retained to enable data recovery (time travel and fail-safe)

Question 9

Snowflake compute costs depend on which of the following?

Answer 9

The amount of time warehouses have run.
The sizes of running warehouses.

Question 10

How often does Snowflake release new features?

Answer 10

Weekly

Question 11

What common tasks for traditional on-premises database and IT staff are not required with Snowflake?

Answer 11

Maintaining metadata
Maintaining statistics
Maintaining the physical security of a server room (key cards, door locks, etc.)