Free Snowflake ARA-C01 Exam Questions

Become Snowflake Certified with updated ARA-C01 exam questions and correct answers

Page: 1 / 89

Total 442 Questions | Updated On: Apr 01, 2022

Add To Cart

Question 1

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?

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: C

Question 2

Who can view account-level Credit and Storage Usage?

A : ACCOUNTADMIN

B : A role which has been granted the MONITOR USAGE global privilege

C : STORAGEADMIN

D : STORAGEMONITOR

Answer: A,B

Question 3

A large join query takes around 3 hours to complete in an L warehouse. After increasing the warehouse size to XL one, the query's performance didn't improve. What can be the cause of it?

A : The query was still running before the new size of the warehouse was applied

B : The warehouse doesn't have enough power still

C : The warehouse had auto-suspended before the query finished, and it had to re-start again

D : One of the column's values is significantly more than the rest of the values in the column; that's why it produces a skew in your data.

Answer: D

Question 4

For authentication, snowflake Kafka connector relies on:

A : key pair authentication

B : username/password

C : Both key pair authentication and username/password

Answer: A

Question 5

The kafka connector creates one pipe for each partition in a Kafka topic.

A : TRUE

B : FALSE

Answer: A

Page: 1 / 89

Total 442 Questions | Updated On: Apr 01, 2022

Add To Cart