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

Remote service in external function can be an AWS Lambda function

A : TRUE

B : FALSE

Answer: A

Question 2

What is a characteristic of loading data into Snowflake using the Snowflake Connector for Kafka?

A : The Connector only works in Snowflake regions that use AWS infrastructure.

B : The Connector works with all file formats, including text, JSON, Avro, Ore, Parquet, and XML.

C : The Connector creates and manages its own stage, file format, and pipe objects.

D : Loads using the Connector will have lower latency than Snowpipe and will ingest data in real time.

Answer: C

Question 3

A copy command is executed to load a file.

After the file has loaded and the metadata has expired, what options can be used to reload the file? (Select TWO).

A : Set the FORCE option to TRUE.

B : Set the DISABLE_SNOWFLAKE_DATA option to TRUE.

C : Set the ALLOW_DUPLICATE option to TRUE.

D : Set the LOAD_UNCERTAIN_FILES option to TRUE.

E : Set the PRESERVE_SPACE option to TRUE.

Answer: A,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

What does a successful response from the insertFiles Snowpipe endpoint mean?

A : Snowflake has recorded the list of files to add to the table.

B : The files have been ingested.

C : It Retrieves a report of files submitted via the insertFile endpoint.

Answer: A

Page: 1 / 89

Total 442 Questions | Updated On: Apr 01, 2022

Add To Cart