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: Feb 20, 2026

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

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 3

A company has a Snowflake account named ACCOUNTA in AWS us-east-1 region. The company stores its marketing data in a Snowflake database named MARKET_DB. One of the company’s business partners has an account named PARTNERB in Azure East US 2 region. For marketing purposes the company has agreed to share the database MARKET_DB with the partner account. Which of the following steps MUST be performed for the account PARTNERB to consume data from the MARKET_DB database?

A : Create a new account (called AZABC123) in Azure East US 2 region. From account ACCOUNTA create a share of database MARKET_DB, create a new database out of this share locally in AWS us-east-1 region, and replicate this new database to AZABC123 account. Then set up data sharing to the PARTNERB account.

B : From account ACCOUNTA create a share of database MARKET_DB, and create a new database out of this share locally in AWS us-east-1 region. Then make this database the provider and share it with the PARTNERB account.

C : Create a new account (called AZABC123) in Azure East US 2 region. From account ACCOUNTA replicate the database MARKET_DB to AZABC123 and from this account set up the data sharing to the PARTNERB account

D : Create a share of database MARKET_DB, and create a new database out of this share locally in AWS us-east-1 region. Then replicate this database to the partner’s account PARTNERB.

Answer: C

Question 4

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 5

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

Page: 1 / 34

Total 166 Questions | Updated On: Feb 20, 2026

Add To Cart