1 of 71
Term
Which of the following are valid scaling types for a multi cluster
virtual warehouse? PERFORMANCE, SPEED, STANDARD,
ECONOMY
STANDARD, ECONOMY
, All Of The Running Clusters & Any Clusters That Are Started After The Multi
Cluster Virtual Warehouse Is Resized - Resize Will Apply To All Existing Clusters
In A Running State And Any Future Clusters Which May Be Added Due To
Autoscaling
list
Schema, Database, Table
Scaling_policy=economy
Don't know?
2 of 71
Term
T/F - Each SF account is limited to a maximum number of 10 shares
True False
Don't know?
3 of 71
Term
, What is the correct command to see all pipes which have the text
TXN in their name?
list
Standard, economy Enterprise & Higher accounts
SHOW PIPES LIKE '%TXN%'; Clustering keys
Don't know?
4 of 71
Term
T/F - A new custom role will automatically be assigned to all existing
users
True False
Don't know?
5 of 71
Term
, You want to create a new virtual warehouse and auto suspend after
5 minutes, auto resume if a query is ran on that virtual warehouse
and you want the virtual warehouse to be created in a suspended
list state. Assume the name of the virtual warehouse is warehouse and
the size of the warehouse is large.
CREATE OR REPLACE
WAREHOUSE warehouse Create Or Replace Warehouse
WAREHOUSE_SIZE=large warehouse Warehouse_size=large
AUTO_SUSPEND=300 Auto_suspend=301
AUTO_RESUME=TRUE Auto_resume=true
INITIALLY_SUSPENDED=TRUE Initially_suspended=true;
;
Create Or Replace Warehouse Create Or Replace Warehouse
warehouse Warehouse_size=large warehouse Warehouse_size=large
Auto_suspend=1500 Auto_suspend=290
Auto_resume=true Auto_resume=true
Initially_suspended=true; Initially_suspended=true;
Don't know?
6 of 71
Term
Which scaling type would result in SF preferring performance over
preserving credits?
Term
Which of the following are valid scaling types for a multi cluster
virtual warehouse? PERFORMANCE, SPEED, STANDARD,
ECONOMY
STANDARD, ECONOMY
, All Of The Running Clusters & Any Clusters That Are Started After The Multi
Cluster Virtual Warehouse Is Resized - Resize Will Apply To All Existing Clusters
In A Running State And Any Future Clusters Which May Be Added Due To
Autoscaling
list
Schema, Database, Table
Scaling_policy=economy
Don't know?
2 of 71
Term
T/F - Each SF account is limited to a maximum number of 10 shares
True False
Don't know?
3 of 71
Term
, What is the correct command to see all pipes which have the text
TXN in their name?
list
Standard, economy Enterprise & Higher accounts
SHOW PIPES LIKE '%TXN%'; Clustering keys
Don't know?
4 of 71
Term
T/F - A new custom role will automatically be assigned to all existing
users
True False
Don't know?
5 of 71
Term
, You want to create a new virtual warehouse and auto suspend after
5 minutes, auto resume if a query is ran on that virtual warehouse
and you want the virtual warehouse to be created in a suspended
list state. Assume the name of the virtual warehouse is warehouse and
the size of the warehouse is large.
CREATE OR REPLACE
WAREHOUSE warehouse Create Or Replace Warehouse
WAREHOUSE_SIZE=large warehouse Warehouse_size=large
AUTO_SUSPEND=300 Auto_suspend=301
AUTO_RESUME=TRUE Auto_resume=true
INITIALLY_SUSPENDED=TRUE Initially_suspended=true;
;
Create Or Replace Warehouse Create Or Replace Warehouse
warehouse Warehouse_size=large warehouse Warehouse_size=large
Auto_suspend=1500 Auto_suspend=290
Auto_resume=true Auto_resume=true
Initially_suspended=true; Initially_suspended=true;
Don't know?
6 of 71
Term
Which scaling type would result in SF preferring performance over
preserving credits?
