Question 1

Which semi structured data function interprets an input string as a JSON document, producing a VARIANT value.

Options :

A : PARSE_JSON

B : PARSE_XML

C : STRIP_JSON

D : Try a hands-on exercise to understand this

Answer: A

Question 2

You have a query that will take 20 minutes to be executed in a data warehouse. This warehouse auto-suspends after 15 minutes. What will happen with the query?

Options :

A : The query will be canceled after 15 minutes

B : The query will stop until the warehouse resumes again

C : The query will finish as expected

Answer: C

Question 3

You ran the below query and it took a long time to run

select itembarcode from checkouts where BIBNUMBER = '2213435';

The clustering information shows the below result. What can you derive from this information

select system$clustering_information('checkouts','(BIBNUMBER)');

2020-09-06-20-26-48-21b07202e527a5b67bbba720952a3ecf

Options :

A : The data is not clustered well by BIBNUMBER and it is spread across all the micro-partitions, hence to retrieve a small number of micro-partitions, the query has to scan all the partitions in the table

B : The query is running slow because the warehouse does not have enough memory

C : The query is running slow because BIBNUMBER does not have an index created on it.

Answer: A

Question 4

A healthcare company wants to share data with a medical institute. The institute is running a Standard edition of Snowflake; the healthcare company is running a Business Critical edition. How can this data be shared?

Options :

A : The healthcare company will need to change the institute’s Snowflake edition in the accounts panel.

B : By default, sharing is supported from a Business Critical Snowflake edition to a Standard edition.

C : Contact Snowflake and they will execute the share request for the healthcare company.

D : Set the share_restriction parameter on the shared object to false.

Answer: D

Question 5

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