What feature can be used to reorganize a very large table on one or more columns?

• A.Micro-partitions
• B.Clustering keys
• C.Key partitions
• D.Clustered partitions

Comment: *

Name: *

Email: *

Verification: *

To run a Multi-Cluster Warehouse in auto-scale mode, a user would:

• A.Set the Minimum Clusters and Maximum Clusters settings to the same value
• B.Set the Warehouse type to "Auto"
• C.Set the Minimum Clusters and Maximum Clusters settings to the different values
• D.Configure the Maximum Clusters setting to "Auto-Scale"

Comment: *

Name: *

Email: *

Verification: *

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

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

Comment: *

Name: *

Email: *

Verification: *

True or False: Reader Accounts incur no additional Compute costs to the Data Provider since they are simply reading the shared data without making changes.

• A.False
• B.True

Comment: *

Name: *

Email: *

Verification: *

If auto-suspend is enable for a Virtual Warehouse, he Warehouse is automatically suspended when:

• A.There are no users loaned into Snowflake.
• B.The Warehouse is inactive for a specified period of time.
• C.All Snowflake sessions using the warehouse are terminated.
• D.The last query using the warehouse completes.

Comment: *

Name: *

Email: *

Verification: *