A. Snowflake automatically manages the compute required to execute the Pipe's COPY INTO commands

B. You can only use it on Internal Stages

C. Snowpipe keeps track of which files it has loaded

D. All COPY INTO options are available during pipe creation

A. include the SQL statements in the body of the task create task mytask.. as insert into target1 select., from stream_s1 where ..
INSERT INTO target2 SELECT .. FROM stream .s1 where ..

B. Create a task for each SQL statement (e.g. resulting in task1. task2, etc) and string the series of SQL statements by having a control task calling task 1, task 2 sequentially.

C. A stored procedure can have only one DML statement per stored procedure invocation and therefore you should sequence stored procedures calls in the task definition CREATE TASK mytask.... AS call stored_prc1(); call stored_proc2t);

D. A stored procedure executing multiple SQL statements and invoke the stored procedure from the task. CREATE TASK mytask.... AS call stored_proc_multiple_statements_inside():

A. Temporary Tables

B. Permanent Tables

C. Translent Tables

D. Provisional Tables

A. COPY WAREHOUSE FROM <<config file>>;

B. SET WAREHOUSE = <<warehouse name>>;

C. USE WAREHOUSE <<warehouse name>>;

D. USE VIRTUAL_WAREHOUSE <<warehouse name>>;

A. Premier

B. Enterprise

C. Standard

D. Business Critical Edition