Question 1

A user is executing the following command sequentially within a timeframe of 10 minutes from start to finish:

What would be the output of this query?

Options :

A : Table T_SALES_CLONE successfully created.

B : Time Travel data is not available for table T_SALES.

C : The offset -> is not a valid clause in the clone operation.

D : Syntax error line 1 at position 58 unexpected 'at’.

Answer: A

Question 2

The following DDL command was used to create a task based on a stream:

Assuming MY_WH is set to auto_suspend – 60 and used exclusively for this task, which statement is true?

Options :

A : The warehouse MY_WH will be made active every five minutes to check the stream.

B : The warehouse MY_WH will only be active when there are results in the stream.

C : The warehouse MY_WH will never suspend.

D : The warehouse MY_WH will automatically resize to accommodate the size of the stream.

Answer: B

Question 3

A company has a Snowflake account named ACCOUNTA in AWS us-east-1 region. The company stores its marketing data in a Snowflake database named MARKET_DB. One of the company’s business partners has an account named PARTNERB in Azure East US 2 region. For marketing purposes the company has agreed to share the database MARKET_DB with the partner account. Which of the following steps MUST be performed for the account PARTNERB to consume data from the MARKET_DB database?

Options :

A :

Create a new account (called AZABC123) in Azure East US 2 region. From account ACCOUNTA create a share of database MARKET_DB, create a new database out of this share locally in AWS us-east-1 region, and replicate this new database to AZABC123 account. Then set up data sharing to the PARTNERB account.

B :

From account ACCOUNTA create a share of database MARKET_DB, and create a new database out of this share locally in AWS us-east-1 region. Then make this database the provider and share it with the PARTNERB account.

C :

Create a new account (called AZABC123) in Azure East US 2 region. From account ACCOUNTA replicate the database MARKET_DB to AZABC123 and from this account set up the data sharing to the PARTNERB account

D :

Create a share of database MARKET_DB, and create a new database out of this share locally in AWS us-east-1 region. Then replicate this database to the partner’s account PARTNERB.

Answer: C

Question 4

A company has a table with that has corrupted data, named Data. The company wants to recover the data as it

was 5 minutes ago using cloning and Time Travel.

What command will accomplish this?

Options :

A : CREATE CLONE TABLE Recover_Data FROM Data AT(OFFSET => -60*5);

B : CREATE CLONE Recover_Data FROM Data AT(OFFSET => -60*5);

C : CREATE TABLE Recover_Data CLONE Data AT(OFFSET => -60*5);

D : CREATE TABLE Recover Data CLONE Data AT(TIME => -60*5);

Answer: C

Question 5

Data is being imported and stored as JSON in a VARIANT column. Query performance was fine, but most recently, poor query performance has been reported. What could be causing this?

Options :

A : There were JSON nulls in the recent data imports.

B : The order of the keys in the JSON was changed.

C : The recent data imports contained fewer fields than usual.

D : There were variations in string lengths for the JSON values in the recent dataimports.

Answer: B,D