The diagram shows the process flow for Snowpipe auto-ingest with Amazon Simple Notification Service (SNS) with the following steps:
Step 1: Data files are loaded in a stage.
Step 2: An Amazon S3 event notification, published by SNS, informs Snowpipe - by way of Amazon Simple Queue Service (SQS) - that files are ready to load. Snowpipe copies the files into a queue.
Step 3: A Snowflake-provided virtual warehouse loads data from the queued files into the target table based on parameters defined in the specified pipe.

If an AWS Administrator accidentally deletes the SQS subscription to the SNS topic in Step 2, what will happen to the pipe that references the topic to receive event messages from Amazon S3?

• A.The pipe will no longer be able to receive the messages and the user must wait for 24 hours from the time when the SNS topic subscription was deleted. Pipe recreation is not required as the pipe will reuse the same subscription to the existing SNS topic after 24 hours.
• B.The pipe will no longer be able to receive the messages. To restore the system immediately, the user needs to manually create a new SNS topic with a different name and then recreate the pipe by specifying the new SNS topic name in the pipe definition.
• C.The pipe will continue to receive the messages as Snowflake will automatically restore the subscription to the same SNS topic and will recreate the pipe by specifying the same SNS topic name in the pipe definition.
• D.The pipe will continue to receive the messages as Snowflake will automatically restore the subscription by creating a new SNS topic. Snowflake will then recreate the pipe by specifying the new SNS topic name in the pipe definition.

Comment: *

Name: *

Email: *

Verification: *

Which of the below privileges are required for search optimization?

• A.OWNERSHIP privilege on the table
• B.ADD SEARCH OPTIMIZATION privilege on the schema that contains the table
• C.ADD SEARCH OPTIMIZATION privilege on the table.

Comment: *

Name: *

Email: *

Verification: *

You have created a reader account for sharing data. who will pay for the compute usage of the account

• A.Consumer
• B.Provider

Comment: *

Name: *

Email: *

Verification: *

One of your query is taking a long time to finish, when you open the query profiler you see that lot of data is spilling to the remote disk(Bytes spilled to remote storage).
What may be the cause of this?

• A.The size of the AWS bucket used to hold the data is not sufficient for the query
• B.The amount of memory available for the servers used to execute the operation might not be sufficient to hold intermediate results
• C.Number of disks attached to the virtual warehouse is not enough for the processing

Comment: *

Name: *

Email: *

Verification: *

A table, EMP_ TBL has three records as shown:

The following variables are set for the session:

Which SELECT statements will retrieve all three records? (Select TWO).

• A.Select * FROM Stbl_ref WHERE Scol_ref IN ('Name1','Nam2','Name3');
• B.SELECT * FROM EMP_TBL WHERE identifier(Scol_ref) IN ('Namel','Name2', 'Name3');
• C.SELECT * FROM identifier<Stbl_ref> WHERE NAME IN ($var1, $var2, $var3);
• D.SELECT * FROM identifier($tbl_ref) WHERE ID IN Cvarl','var2','var3');
• E.SELECT * FROM $tb1_ref WHERE $col_ref IN ($var1, Svar2, Svar3);

Comment: *

Name: *

Email: *

Verification: *