Snowflake Exam ARA-C01 Topic 1 Question 7 Discussion

Actual exam question for Snowflake's ARA-C01 exam

Question #: 7
Topic #: 1

A DevOps team has a requirement for recovery of staging tables used in a complex set of data pipelines. The staging tables are all located in the same staging schem

a. One of the requirements is to have online recovery of data on a rolling 7-day basis.

After setting up the DATA_RETENTION_TIME_IN_DAYS at the database level, certain tables remain unrecoverable past 1 day.

What would cause this to occur? (Choose two.)

AThe staging schema has not been setup for MANAGED ACCESS.

BThe DATA_RETENTION_TIME_IN_DAYS for the staging schema has been set to 1 day.

CThe tables exceed the 1 TB limit for data recovery.

DThe staging tables are of the TRANSIENT type.

EThe DevOps role should be granted ALLOW_RECOVERY privilege on the staging schema.

Show Suggested Answer

Suggested Answer: B, D

by Theodora at Mar 28, 2023, 10:58 AM

Limited Time Offer

25%

Off

Get Premium ARA-C01 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!