Online Access Free COF-C02 Practice Test

What type of function returns one value for each Invocation?

• A.Table
• B.Window
• C.Scalar
• D.Aggregate

Which statement will execute a stored procedure?

• A.CALL proc1(1) + proc1(2);
• B.CALL proc1(proc2(1));
• C.CALL proc1(1) + IF
• D.CALL proc1(SELECT COUNT(*) FROM < table > );

What occurs when a pipe is recreated using the CREATE OR REPLACE PIPE command?

• A.The REFRESH command is executed.
• B.The Pipe load history is reset to empty.
• C.The stage will be purged.
• D.The destination table is truncated.

Taking which step will minimize the number of queries waiting to run on a virtual warehouse?

• A.Increase the WAREHOUSE_SIZE.
• B.Increase the value of the AUTO_SUSPEND parameter.
• C.Increase the value of the MAX_CLUSTER_COUNT.
• D.Set the WAIT_FOR_COMPLETION parameter to FALSE.

How can a user optimize the performance of a COPY INTO < table > query that is being run on a very large file?

• A.Split the file into smaller files.
• B.Increase the virtual warehouse size.
• C.Set the COMPRESSION = AUTO option in the file format.
• D.Set the SIZE_LIMIT option to be larger than the file size.