What parameter controls if the Virtual Warehouse starts immediately after the CREATE WAREHOUSE statement?
What parameter controls if the Virtual Warehouse starts immediately after the CREATE WAREHOUSE statement?
INITIALLY_SUSPENDED = TRUE/FALSE is the parameter used to control if the Virtual Warehouse starts immediately after the CREATE WAREHOUSE statement. If set to TRUE, the warehouse will not start automatically upon creation; if set to FALSE, the warehouse will start immediately.
Answer is correct: - Syntax CREATE [ OR REPLACE ] WAREHOUSE [ IF NOT EXISTS ] <name> [ [ WITH ] objectProperties ] [ objectParams ] Where: objectProperties ::= WAREHOUSE_SIZE = XSMALL | SMALL | MEDIUM | LARGE | XLARGE | XXLARGE | XXXLARGE | X4LARGE | X5LARGE | X6LARGE MAX_CLUSTER_COUNT = <num> MIN_CLUSTER_COUNT = <num> SCALING_POLICY = STANDARD | ECONOMY AUTO_SUSPEND = <num> | NULL AUTO_RESUME = TRUE | FALSE INITIALLY_SUSPENDED = TRUE | FALSE RESOURCE_MONITOR = <monitor_name> COMMENT = '<string_literal>' ENABLE_QUERY_ACCELERATION = TRUE | FALSE QUERY_ACCELERATION_MAX_SCALE_FACTOR = <num>
Correct
A. INITIALLY_SUSPENDED = TRUE/FALSE
Correct Answer: A
A. INITIALLY_SUSPENDED = TRUE/FALSE