Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

SnowPro Core > Chapter 2: Snowflake Architecture > Flashcards

Chapter 2: Snowflake Architecture Flashcards

1
Q

Which of the following terms best describes the architecture of Snowflake?

Shared-nothing architecture
Shared-disk architecture
Hybrid architecture
Three-tier architecture

A

Hybrid architecture

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

Which of the following is true regarding Snowflake data storage?

A Snowflake-based data warehouse can store only up to 100 TB of data.

The capacity of a Snowflake-based data warehouse is nearly unlimited because it is backed by cloud-based storage, which itself is nearly unlimited in nature.

Snowflake running on an on-premises server can store only 50 TB of data.

A Snowflake-based data warehouse can store only up to 1 PB of data.

A

The capacity of a Snowflake-based data warehouse is nearly unlimited because it is backed by cloud-based storage, which itself is nearly unlimited in nature.

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

Which of the following statements are true regarding virtual warehouses in Snowflake? (Select all that apply.)

The term virtual warehouse refers to compute clusters in Snowflake.

Only one virtual warehouse can be started at a time.

Virtual warehouses can be suspended, resumed, and deleted altogether as per the workload requirement.

Virtual warehouses can be resized to a smaller or larger size, whether in a running state or a suspended state.

A

The term virtual warehouse refers to compute clusters in Snowflake.

Virtual warehouses can be suspended, resumed, and deleted altogether as per the workload requirement.

Virtual warehouses can be resized to a smaller or larger size, whether in a running state or a suspended state.

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

A virtual warehouse is resumed from a suspended state and then suspended again within 30 seconds. What is the minimum amount of credits that a virtual warehouse will consume?

No Snowflake credits will be consumed.
One minute’s worth of Snowflake credits.
30 seconds’ worth of Snowflake credits.
One hour’s worth of Snowflake credits.

A

One minute’s worth of Snowflake credits.

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

Which of the following best describes the Snowflake architecture?

Multi-cluster distributed data
Single-cluster distributed data
Multi-cluster, shared-data
Multi-cluster, replicated data

A

Multi-cluster, shared-data

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

True or False: As the size of a virtual warehouse increases, the amount of Snowflake credit used increases proportionately.

True
False

A

True

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

True or False: A large table in Snowflake may contain millions or hundreds of millions of micro-partitions.

True
False

A

True

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

True or False: If you create multiple virtual warehouses in a Snowflake-based solution, the virtual warehouses share the memory and CPU resources.

True
False

A

False

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

Snowflake stores which of the following metadata about rows in a micro-partition? (Select all that apply.)

The range of values for each of the columns in the micro-partition
The count of distinct values
Additional properties for optimization and efficient processing
List of users who have access to each row

A

The range of values for each of the columns in the micro-partition
The count of distinct values
Additional properties for optimization and efficient processing

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

True or False: Snowflake automatically determines the most efficient technique for compressing columns in micro-partitions.

True
False

A

True

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

Which of the following statements correctly describes a virtual warehouse in Snowflake?

The virtual warehouse is a concept through which two or more physical tables are linked together.

Reporting views are called virtual warehouses.

Virtual warehouses are the compute cluster(s) that Snowflake uses to execute queries and data load/unload jobs.

Virtual warehouse provide virtualization capabilities.

A

Virtual warehouses are the compute cluster(s) that Snowflake uses to execute queries and data load/unload jobs.

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

True or False: At any point in time, a virtual warehouse can be suspended or resumed as needed.

True
False

A

True

(When not being used, a suspend will take effect after any current processing completes)

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

True or False: When a virtual warehouse is provisioned, terminating it inside the first 60 seconds has no significance because that period has already been billed.

True
False

A

True

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

When a virtual warehouse cluster is resized to a smaller size or scaled down, extra nodes are removed from the virtual warehouse cluster. Which of the following correctly describes when the extra nodes are removed?

Immediately, whether or not a query is using those extra nodes
Immediately, but only if no query is running on the extra nodes
After a delay of one minute
When the cluster is suspended or stopped

A

Immediately, but only if no query is running on the extra nodes

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

True or False: A virtual warehouse may be resized at any moment, whether it’s in a suspended state or running queries.
True
False

A

True

However existing queries will not be impacted. Furthermore, the removal of nodes doesn’t take effect until all currently executed queries complete.

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

True or False: When a request is made for a virtual warehouse to suspend, it enters the suspended state once all active queries on the virtual warehouse have completed execution.

True
False

A

True

17
Q

Data in Snowflake tables is divided into micro-partitions and stored in a compressed format. What is the size of uncompressed data stored in each micro-partition?

10 MB to 20 MB
20 MB to 50 MB
50 MB to 500 MB
1 GB to 2 GB

A

50 MB to 500 MB

18
Q

Data in Snowflake tables is divided into micro-partitions and stored in a compressed format. Which one of the following is a characteristic of micro-partitions?

Micro-partitions are immutable; once written, they cannot be changed.
A user can control how many micro-partitions are created for a table.
A user can specify the size of a micro-partition.
The storage format of a micro-partition can be controlled through configuration.

A

Micro-partitions are immutable; once written, they cannot be changed.

19
Q

Which one of the following statements correctly describes data clustering in Snowflake?

Snowflake does not cluster any data, and the data is stored in an unclustered form.
Snowflake automatically clusters the data as it is inserted into a table.
If a clustering key is not defined, Snowflake does not cluster the data.
Snowflake clusters the data only when the CLUSTER command is executed.

A

Snowflake automatically clusters the data as it is inserted into a table.

20
Q

Which of the following are layers of Snowflake architecture? (Select all that apply.)

Cloud services layer
Database storage layer
Data sharing layer
Query processing layer
AWS layer

A

Cloud services layer
Database storage layer
Query processing layer

21
Q

How are columns stored within a Snowflake micro-partition?

In a row format, with complete rows stored in each micro-partition
In a columnar format, with each column compressed and stored individually
In a CSV format, in a comma-separated manner
In Parquet format

A

In a columnar format, with each column compressed and stored individually

22
Q

At a minimum, which Snowflake edition is required to create multi-cluster data virtual warehouses?

Standard
Enterprise
Business Critical
Virtual Private Snowflake

A

Enterprise

SnowPro Core (10 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions