Free Snowflake ARA-R01 Exam Questions

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

Page: 1 / 34

Total 166 Questions | Updated On: Sep 10, 2025

Add To Cart

Question 1

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?

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 2

How is the change of local time due to daylight savings time handled in Snowflake tasks? (Choose two.)

A : A task scheduled in a UTC-based schedule will have no issues with the time changes.

B : Task schedules can be designed to follow specified or local time zones to accommodate the time changes

C : A task will move to a suspended state during the daylight savings time change.

D : A frequent task execution schedule like minutes may not cause a problem, but will affect the task history.

E : A task schedule will follow only the specified time and will fail to handle lost or duplicated hours.

Answer: A,B

Question 3

Based on the Snowflake object hierarchy, what securable objects belong directly to a Snowflake account? (Select THREE).

A : Database

B : Schema

C : Table

D : Stage

E : Role

F : Warehouse

Answer: A,E,F

Question 4

An Architect has designed a data pipeline that Is receiving small CSV files from multiple sources. All of the files are landing in one location. Specific files are filtered for loading into Snowflake tables using the copy command. The loading performance is poor. What changes can be made to Improve the data loading performance?

A : Increase the size of the virtual warehouse.

B : Create a multi-cluster warehouse and merge smaller files to create bigger files.

C : Create a specific storage landing bucket to avoid file scanning.

D : Change the file format from CSV to JSON.

Answer: B

Question 5

What is a characteristic of event notifications in Snowpipe?

A : The load history is stored In the metadata of the target table.

B : Notifications identify the cloud storage event and the actual data in the files.

C : Snowflake can process all older notifications when a paused pipe Is resumed.

D : When a pipe Is paused, event messages received for the pipe enter a limited retention period.

Answer: D

Page: 1 / 34

Total 166 Questions | Updated On: Sep 10, 2025

Add To Cart