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: Mar 28, 2025

Add To Cart

Question 1

Which of the below commands will use warehouse credits?

A : SHOW TABLES LIKE 'SNOWFL%';

B : SELECT MAX(FLAKE_ID) FROM SNOWFLAKE;

C : SELECT COUNT(*) FROM SNOWFLAKE;

D : SELECT COUNT(FLAKE_ID) FROM SNOWFLAKE GROUP BY FLAKE_ID;

Answer: B,C,D

Question 2

An Architect runs the following SQL query:

How can this query be interpreted?

A : FILEROWS is a stage. FILE_ROW_NUMBER is line number in file.

B : FILEROWS is the table. FILE_ROW_NUMBER is the line number in the table.

C : FILEROWS is a file. FILE_ROW_NUMBER is the file format location.

D : FILERONS is the file format location. FILE_ROW_NUMBER is a stage.

Answer: A

Question 3

When activating Tri-Secret Secure in a hierarchical encryption model in a Snowflake account, at what level is the customer-managed key used?

A : At the root level (HSM)

B : At the account level (AMK)

C : At the table level (TMK)

D : At the micro-partition level

Answer: B

Question 4

What are some of the characteristics of result set caches? (Choose three.)

A : Time Travel queries can be executed against the result set cache.

B : Snowflake persists the data results for 24 hours.

C : Each time persisted results for a query are used, a 24-hour retention period is reset.

D : The data stored in the result cache will contribute to storage costs.

E : The retention period can be reset for a maximum of 31 days.

F : The result set cache is not shared between warehouses.

Answer: B,C,E

Question 5

How can the Snowpipe REST API be used to keep a log of data load history?

A : Call insertReport every 20 minutes, fetching the last 10,000 entries.

B : Call loadHistoryScan every minute for the maximum time range.

C : Call insertReport every 8 minutes for a 10-minute time range.

D : Call loadHistoryScan every 10 minutes for a 15-minute time range.

Answer: D

Page: 1 / 34

Total 166 Questions | Updated On: Mar 28, 2025

Add To Cart