Brainscape's Knowledge GenomeTM


Top Flashcards (Certified)
All Flashcards

SnowPro Certification > Performance Concepts: Virtual Warehouses > Flashcards

Performance Concepts: Virtual Warehouses Flashcards

(48 cards)

Start Studying
1
Q

Virtual Warehouse

A

A virtual warehouse is a named abstraction for a Massively Parallel Processing (MPP) compute cluster.

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

Virtual Warehouses execute what operations?

A
  • DQL operations (SELECT)
  • DML operations (UPDATE)
  • Data Loading Operations (COPY INTO)
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

As a user you only interact with the _________ warehouse object not the underlying compute resources.

A

named

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

Spin up and shut-down a virtually __ number of warehouses without resource contention.

A

unlimited

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

Virtual Warehouse configuration can be changed ___________.

A

on-the-fly

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

Virtual Warehouses contain local ____ storage used to sore ______ data retrieved from the ________ layer.

A

SSD; raw; storage

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

Virtual Warehouses are created via the _____________ or through _______ commands.

A

Snowflake UI; SQL

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

DROP WAREHOUSE statement

A

DROP WAREHOUSE MY_WAREHOUSE;

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

CREATE WAREHOUSE statement

A

CREATE WAREHOUSE MY_MED_WH
WAREHOUSE_SIZE=’MEDIUM’;

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

ALTER WAREHOUSE SUSPEND statement

A

ALTER WAREHOUSE MY_WH SUSPEND;

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

ALTER WAREHOUSE resize statement

A

ALTER WAREHOUSE MY_WH_2 SET
WAREHOUSE_SIZE=MEDIUM;

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

CREATE HOUSE with minimum and maximum cluster statement

A

CREATE WAREHOUSE MY_WH_3
MIN_CLUSTER_COUNT=1
MAX_CLUSTER_COUNT=3
SCALING_POLICY=STANDARD;

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

Virtual Warehouse States

A
  • Started
  • Suspended
  • Resizing
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

By default when a Virtual Warehouse is created it is in the ________________ state.

A

STARTED

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

Suspending a Virtual Warehouse puts it in the ________________ state, removing the compute nodes from a warehouse.

A

SUSPENDED

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

Resuming a Virtual Warehouse puts in back into the STARTED state and can execute queries.

A

STARTED

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

AUTO SUSPEND definition

A

Specifies the number of seconds of inactivity after which a warehouse is automatically suspended.

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

AUTO SUSPEND statement

A

CREATE WAREHOUSE MY_MED_WH
AUTO_SUSPEND=300;

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

AUTO RESUME definition

A

Specifies whether to automatically resume a warehouse when a SQL statement is submitted to it.

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

AUTO RESUME statement

Study These Flashcards
A

CREATE WAREHOUSE MY_WED_WH
AUTO_RESUME=TRUE;

21
Q

INITIALLY SUSPENDED definition

Study These Flashcards
A

Specifies whether the warehouse is created initially in the ‘Suspended’ state.

22
Q

INITIALLY SUSPENDED statement

Study These Flashcards
A

CREATE WAREHOUSE MY_MED_WH
INITIALLY_SUSPENDED=TRUE;

23
Q

Virtual Warehouses can be created in what 10 t-shirt sizes?

Study These Flashcards
A

x-Small, Small, Medium, Large, x-Large, 2x-Large, 3x-Large, 4x-Large, 5x-Large, 6x-Large

24
Q

Underlying compute power approximately ______ with each virtual warehouse size increase.

25
Virtual Warehouse Billing per Warehouse Size
26
Resource Monitors
-Resource monitors are objects allowing users to set credit limits on user managed warehouses
27
Resource Monitors can be set on either the ________ or __________ warehouse level.
account; individual
28
Resource Monitors limits can be set for a ________ __________ or ______ _______.
specified interval; date range
29
When Resource Monitors limits are reached an __________ can be triggered, such as notify user or suspend warehouse.
action
30
Resource Monitors can only be created by _______________ _______________.
account administrators
31
Create a resource statement with credit quota of 100 and a monthly frequency and notify trigger on 50%, notify trigger on 75%, suspend on 95%, suspend immediately at 100%, and a time stamp of 1/4/23
CREATE RESOURCE MONITOR ANALYSIS_RM WITH CREDIT QUOTA=100 FREQUENCY=MONTHLY START_TIMESTAMP='2021-01-04 00:00 GMT' TRIGGERS ON 50 PERCENT DO NOTIFY ON 75 PERCENT DO NOTIFY ON 95 PERCENT DO SUSPEND ON 100 PERCENT DO SUSPEND_IMMEDIATE;
32
Scaling up a Virtual Warehouse is intended to __________ query performance.
improve
33
Virtual Warehouses can be manually resized via the __________ _____ or _____ __________.
Snowflake UI, SQL commands
34
Resizing a running warehouse does not impact running queries. The additional compute resources are used for __________ and ________ queries.
queued, new
35
Decreasing the size of a running warehouse ____________ compute resources from the warehouse and ___________ the warehouse cache.
removes, clears
36
Alter warehouse statement for MY_WH with a large warehouse size
ALTER WAREHOUSE MY_WH SET WAREHOUSE_SIZE=LARGE;
37
Multi-cluster warehouse definition
a named group of virtual warehouses which can automatically scale in and out based on the number of concurrent users/queries.
38
MIN_CLUSTER_COUNT definition
specifies the minimum number of warehouses for a multi-cluster warehouse
39
MAX_CLUSTER_COUNT definition
specifies the maximum number of warehouses for a multi-cluster warehosue
40
Setting MIN_CLUSTER_COUNT and MAX_CLUSTER_COUNT to the same value will put the multi-cluster warehouse in ____________________ mode.
MAXIMIZED
41
Setting MIN_CLUSTER_COUNT and MAX_CLUSTER_COUNT to different values will put the multi-cluster warehouse in __________________ mode.
AUTO-SCALE
42
Describe the Standard Scaling Policy
43
Describe the Economy Scaling Policy
44
The total credit cost of a multi-cluster warehouse is the ______ of all the ____________ running warehouses that make up that cluster.
sum, individual
45
The maximum number of credits a multi-cluster can consume is the _______ of warehouses __________ by the ________ credit rate of the size of the warehousees.
number, multiplied, hourly
46
MAX_CONCURRENCY_LEVEL definition
Specifies the number of concurrent SQL statements that can be executed against a warehouse before either it is queued or additional compute power is provided.
47
STATEMENT_QUEUED_TIMEOUT_IN_SECONDS definition
Specifies the time in seconds a SQL statement can be queued on a warehouse before its aborted.
48
STATEMENT_TIMEOUT_IN_SECONDS definition
It specifies the time, in seconds, after which any running SQL statement on a warehouse is aborted.

SnowPro Certification (14 decks)

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