A stream object will advance its offset when it is used in which statement?

• A.SELECT
• B.COPY INTO <location>
• C.CREATE
• D.INSERT

Comment: *

Name: *

Email: *

Verification: *

A single user of a virtual warehouse has set the warehouse to auto-resume and auto-suspend after 10 minutes.
The warehouse is currently suspended and the user performs the following actions:
1. Runs a query that takes 3 minutes to complete
2. Leaves for 15 minutes
3. Returns and runs a query that takes 10 seconds to complete
4. Manually suspends the warehouse as soon as the last query was completed When the user returns, how much billable compute time will have been consumed?

• A.10 minutes
• B.4 minutes
• C.14 minutes
• D.24 minutes

Comment: *

Name: *

Email: *

Verification: *

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.

Comment: *

Name: *

Email: *

Verification: *

What transformations are supported in a CREATE PIPE ... AS COPY ... FROM (....) statement? (Select TWO.)

• A.Data can be filtered by an optional where clause
• B.Incoming data can be joined with other tables
• C.Columns can be reordered
• D.Columns can be omitted
• E.Row level access can be defined

Comment: *

Name: *

Email: *

Verification: *

When an object is created in Snowflake. who owns the object?

• A.The public role
• B.The user's default role
• C.The current active primary role
• D.The owner of the parent schema

Comment: *

Name: *

Email: *

Verification: *