Question 1

What command can we use to delete a share from the Snowflake account?

Options :

A : DELETE SHARE

B : DROP SHARE

C : REMOVE SHARE

D : ALTER SHARE SET REMOVED = True

Answer: B

Question 2

An Architect is designing a data lake with Snowflake. The company has structured, semi-structured, and unstructured data. The company wants to save the data inside the data lake within the Snowflake system. The company is planning on sharing data among its corporate branches using Snowflake data sharing. What should be considered when sharing the unstructured data within Snowflake?

Options :

A :

A pre-signed URL should be used to save the unstructured data into Snowflake in order to share data over secure views, with no time limit for the URL.

B :

A scoped URL should be used to save the unstructured data into Snowflake in order to share data over secure views, with a 24-hour time limit for the URL.

C :

A file URL should be used to save the unstructured data into Snowflake in order to share data over secure views, with a 7-day time limit for the URL.

D :

A file URL should be used to save the unstructured data into Snowflake in order to share data over secure views, with the "expiration_time" argument defined for the URL time limit.

Answer: B

Question 3

You are running a large join on snowflake. You ran it on a medium warehouse and it took almost an hour to run. You then tried to run the join on a large warehouse but still the performance did not improve. What may be the most possible cause of this.

Options :

A : There may be a symptom on skew in your data where one of the value of the column is significantly more than rest of the values in the column

B : Your warehouses do not have enough memory

C : Since you have configured an warehouse with a low auto-suspend value, your warehouse is going down frequently

Answer: A

Question 4

create or replace table result_scan_table_1 like result_scan_table;

Will the above query cost compute credits?

Options :

A : No, since it is a metadata operation only

B : Yes, it will need compute as the table structure is also getting created

C : It is hard to say without looking at query profile

Answer: A

Question 5

Which of the below objects cannot be replicated?

Options :

A : Resource Monitors

B : Warehouses

C : Users

D : Databases

E : Shares

F : Roles

Answer: A,B,C

Higher Test Marks with Free Online ARA-C01 Exam Practice

Buying Options: