A.Scaling up a warehouse

B.Updating data

C.AUTOMATIC__CLUSTERING

D.Execute a COPY command

E.Snowpipe

A.Modify listings properties.

B.Submit listings for approval/publishing.

C.Delete provider profiles.

D.Modify incoming listing access requests.

E.Rename listings.

A.The warehouse size does not change until all queries currently in the warehouse queue have completed.

B.The warehouse size does not change until all queries currently running in the warehouse have completed.

C.The warehouse size does not change until the warehouse is suspended and restarted.

D.It does not return from the command until the warehouse has finished changing its size.

A.User-Defined Table Functions (UDTF)

B.Materialized Views

C.External Tables

D.External Tokenization

A.A stored procedure can have only one DML statement per stored procedure invocation and therefore the user should sequence stored procedure calls in the task definition CREATE TASK mytask .... AS call stored_proc1(); call stored_proc2();

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 task1, task2, etc. sequentially.

C.Use 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();

D.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 ..