ARA-C01 · Question #85
ARA-C01 Question #85: Real Exam Question with Answer & Explanation
The correct answer is A: A query using Time Travel in the secondary database is available for every hourly table version. Snowflake's Time Travel feature allows users to query historical data within a defined retention period. In the given scenario, since the secondary database is refreshed every hour, Time Travel can be used to query each hourly version of the table as long as it falls within the r
Question
An Architect has a design where files arrive every 10 minutes and are loaded into a primary database table using Snowpipe. A secondary database is refreshed every hour with the latest data from the primary database. Based on this scenario, what Time Travel query options are available on the secondary database?
Options
- AA query using Time Travel in the secondary database is available for every hourly table version
- BA query using Time Travel in the secondary database is available for every hourly table version
- CUsing Time Travel, secondary database users can query every iterative version within each hour
- DUsing Time Travel, secondary database users can query every iterative version within each hour
Explanation
Snowflake's Time Travel feature allows users to query historical data within a defined retention period. In the given scenario, since the secondary database is refreshed every hour, Time Travel can be used to query each hourly version of the table as long as it falls within the retention window. This does not include individual Snowpipe loads within each hour unless they coincide with the hourly refresh.
Topics
Community Discussion
No community discussion yet for this question.