User1, who has the SYSADMIN role, executed a query on Snowsight. User2, who is in the same Snowflake account, wants to view the result set of the query executed by User1 using the Snowsight query history.
What will happen if User2 tries to access the query history?

• A.If User2 has the sysadmin role they will be able to see the results.
• B.If User2 has the securityadmin role they will be able to see the results.
• C.If User2 has the ACCOUNTADMIN role they will be able to see the results.
• D.User2 will be unable to view the result set of the query executed by User1.

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 last query using the warehouse completes.
• C.All Snowflake sessions using the warehouse are terminated.
• D.The Warehouse is inactive for a specified period of time.

Comment: *

Name: *

Email: *

Verification: *

When does Snowflake automatically encrypt data that is loaded into Snowflake? (Select TWO}.

• A.After the data is micro-partitioned.
• B.After loading the data into a table.
• C.After loading the data into an internal stage.
• D.After loading data into an external stage.
• E.Only when using an encrypted stage.

Comment: *

Name: *

Email: *

Verification: *

Which type of Snowflake security policy requires users to re-authenticate after a given period of inactivity?

• A.Network policy
• B.Password policy
• C.Authentication policy
• D.Session policy

Comment: *

Name: *

Email: *

Verification: *

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

• A.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.
• B.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();
• C.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();
• 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 ..

Comment: *

Name: *

Email: *

Verification: *