Free Access to Snowflake.COF-C02.v2026-01-13.q618 with Valid Practice Test (Page 86)

When using SnowSQL, which configuration options are required when unloading data from a SQL query run on a local machine? {Select TWO).

How would a user execute a series of SQL statements using a task?

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

Which Snowflake feature records changes mace to a table so actions can be taken using that change data capture?

Which authentication method requires access to a secure file that is only stored on the user's local device?

How are serverless features billed?

A.Per second multiplied by an automatic sizing for the job
B.Per minute multiplied by an automatic sizing for the job, with a minimum of one minute
C.Per second multiplied by the size, as determined by the SERVERLESS_FEATURES_SIZE account parameter
D.Serverless features are not billed, unless the total cost for the month exceeds 10% of the warehouse credits, on the account

Download PDF File