Level Up Snowflake Key Concepts Flashcards

1
Q

What attributes make Snowflake a true SaaS solution?

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Which instalment option versions of Snowflake are available?

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

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

A

Shared Data

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

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

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

Which statements are true about storage relationships?

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

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

A

Only subsequent queries

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

What are data storage cost calculations based on in Snowflake?

A

Compressed Size
Amount Stored - Daily Average

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

Snowflake data storage costs include which types of data?

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

Snowflake compute costs depend on which of the following?

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

How often does Snowflake release new features?

A

Weekly

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

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

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly