SnowPro Core Exam Practice Questions Part 2 Questions with 100% Correct Answers

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?