Free Practice Snowflake ARA-R01 Exam Questions 2026

Stay ahead with 100% Free SnowPro Advanced: Architect Recertification ARA-R01 Dumps Practice Questions

Page: 1 / 34

Total 166 Questions | Updated On: May 22, 2026

Add To Cart

Question 1

Which data models can be used when modeling tables in a Snowflake environment? (Select THREE).

A : Graph model

B : Dimensional/Kimball

C : Data lake

D : lnmon/3NF

E : Bayesian hierarchical model

F : Data vault

Answer: B,D,F

Question 2

Following objects can be cloned in snowflake

A : Permanent table

B : Transient table

C : Temporary table

D : External tables

E : Internal stages

Answer: A,B,D

Question 3

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

Question 4

An Architect needs to grant a group of ORDER_ADMIN users the ability to clean old data in an ORDERS table (deleting all records older than 5 years), without granting any privileges on the table. The group’s manager (ORDER_MANAGER) has full DELETE privileges on the table. How can the ORDER_ADMIN role be enabled to perform this data cleanup, without needing the DELETE privilege held by the ORDER_MANAGER role?

A : Create a stored procedure that runs with caller’s rights, including the appropriate "> 5 years" business logic, and grant USAGE on this procedure to ORDER_ADMIN. The ORDER_MANAGER role owns the procedure.

B : Create a stored procedure that can be run using both caller’s and owner’s rights (allowing the user to specify which rights are used during execution), and grant USAGE on this procedure to ORDER_ADMIN. The ORDER_MANAGER role owns the procedure.

C : Create a stored procedure that runs with owner’s rights, including the appropriate "> 5 years" business logic, and grant USAGE on this procedure to ORDER_ADMIN. The ORDER_MANAGER role owns the procedure.

D : This scenario would actually not be possible in Snowflake – any user performing a DELETE on a table requires the DELETE privilege to be granted to the role they are using.

Answer: C

Question 5

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

Page: 1 / 34

Total 166 Questions | Updated On: May 22, 2026

Add To Cart