A.SHOW GRANTS TO ROLE MY_ROLE

B.SHOW GRANTS FOR ROLE MY_ROLE

C.SHOW GRANTS OF ROLE MY_ROLE

D.SHOW GRANTS ON ROLE MY_ROLE

A.Use the FAIL_SAFE parameter for Time Travel to retrieve the data from Fail-safe storage.

B.Use Time Travel, as long as DATA_RETENTION_TIME_IN_DAYS was set to at least 3 days.

C.The transient table version cannot be retrieved after 24 hours.

D.Contact Snowflake Support to have the data retrieved from Fail-safe storage.

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

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

A.Infrastructure security

B.Computing the data

C.Parsing and optimizing queries

D.Management of metadata

E.Maintaining Availability Zones

A.User

B.External table

C.Role

D.Stream

E.Share

F.Warehouse