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.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.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.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.

A.Query parsing and optimization

B.Query execution

C.Infrastructure management

D.Management of the storage layer

E.Metadata management

A.Set the user's access to expire within a specified timeframe.

B.Set the number of minutes to unlock to 15 minutes.

C.Configure the user to be initially disabled.

D.Force an immediate password change.

E.Set a default role for the user.

A.The data consumer and data provider can form a Data Exchange within the same organization to create a share from Azure Central Canada to AWS Asia Pacific.

B.The data provider uses the GET DATA workflow in the Snowflake Data Marketplace to create a share between Azure Central Canada and AWS Asia Pacific.

C.The data provider in Azure Central Canada can create a direct share to AWS Asia Pacific, if they are both in the same organization.

D.The data provider must replicate the database to a secondary account in AWS Asia Pacific within the same organization then create a share to the data consumer's account.

A.COPY INTO

B.GET

C.WRITE

D.EXTRACT INTO