A.OLTP (Transactional) workloads

B.OLAP (Analytics) workloads

C.On-premise workloads

D.Concurrent workloads

A.True

B.False

A.False

B.True

A.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);

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

A.All COPY INTO options are available during pipe creation

B.Snowpipe keeps track of which files it has loaded

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

D.You can only use it on Internal Stages