A. Multi-Gigabyte (GB) Range
B. Multi-Terabyte (TB) Range
C. Multi-Megabyte (MB) Range
D. Multi-Kilobyte (KB) Range
A. True
B. False
A. SET warehouse = <<warehouse name>>;
B. COPT WAREHOUSE FROM <<Config file> ;
C. USE WAREHOUSE <<warehouse name>>;
D. USE VIRTUAL_WAREHOUSE <<warehouse name>>;
A. Since task infrastructure is based on running the task body on schedule, it's recommended to configure the virtual warehouse for automatic concurrency handling using Multi-cluster warehouse (MCW) to match the task schedule
B. If using the stored procedure to execute multiple SQL statements, it's best to test run the stored procedure separately to size the compute resource first
C. Querying (select) the size of the stream content would help determine the warehouse size. For example, if querying large stream content, use a larger warehouse size
D. Root task may be executed concurrently (i.e. multiple instances), it is recommended to leave some margins in the execution window to avoid missing instances of execution
A. It is recommended to do frequent, single row DMLS
B. It is recommended to use staging tables to manage MERGE statements
C. VARIANT "nut" values are not the same as SQL Null values
D. It is recommended to validate the data before loading into the Snowflake target table
A. Via Virtual Warehouses
B. Via the Snowflake Web Interface (Ul)
C. Via the data_share=true parameter
D. Via SQL commands
A. Each Schema is contained within a Warehouse
B. A Schema may contain one or more Databases
C. A Database may contain one or more Schemas
D. A Schema is a logical grouping of Database Objects
A. JDBC
B. Snowflake Web Interface (UI)
C. Python
D. ODBC
E. SnowSQL
A. Per-second/per-core granularity
B. Total storage bucket size
C. Per-second/per Warehouse size
D. Number of Pipes in account
