MENU
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.)
Suggested Answer: B, D
Get Premium ARA-C01 Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
17 comments · newest first
DE
Derick
11 months ago
If the role doesn't have ALLOW_RECOVERY, that could definitely cause problems.
BR
Brinda
11 months ago
Wait, are you saying tables over 1 TB can't be recovered? That seems odd.
DE
Denae
12 months ago
Definitely agree, the MANAGED ACCESS setup is crucial!
GO
Goldie
12 months ago
I think the TRANSIENT type tables might be the issue here.
OS
Osvaldo
12 months ago
The DATA_RETENTION_TIME_IN_DAYS for the staging schema has to be set correctly.
RE
Reuben
1 year ago
I have a feeling that TRANSIENT tables might not support long-term recovery, so option D could be a valid choice here.
TR
Troy
1 year ago
I practiced a similar question where the retention time was set incorrectly, so I feel like option B could definitely be a reason for the 1-day limit.
AL
Alpha
1 year ago
I think if the staging schema is set to MANAGED ACCESS, it might affect recovery options, but I can't recall the specifics.
VI
Vinnie
1 year ago
I remember something about the DATA_RETENTION_TIME_IN_DAYS setting, but I'm not sure if it applies to the schema level or just the individual tables.
DO
Donette
1 year ago
I feel like the ALLOW_RECOVERY privilege might be important, but I’m not entirely confident about how it interacts with the schema settings.
HY
Hyman
1 year ago
I practiced a similar question where the TRANSIENT type tables had limitations on recovery, so I wonder if that applies here too.
VE
Vernice
1 year ago
I think if the staging schema is set to MANAGED ACCESS, it might affect recovery options, but I can't recall the specifics.
BR
Brittani
1 year ago
I remember something about the DATA_RETENTION_TIME_IN_DAYS needing to be set at the schema level, but I'm not sure if it can be overridden by table settings.
PA
Pamella
1 year ago
Ah, this is a tricky one. Hedge funds have a reputation for being risky, not low risk. And I think they have higher fees than index funds. I'm going to have to guess on this one - I'll go with B, since that seems the most likely based on what I know about hedge funds.
OR
Oretha
1 year ago
Easy, it's definitely `rm -rf`. That command will delete everything in the current directory and all subdirectories. Better have a good backup before running that!
TA
Tamar
1 year ago
Hmm, I'm a bit unsure about this one. The wording is a bit technical, so I'll need to think it through step-by-step to make sure I understand what they're asking.
SE
Serina
1 year ago
This is a classic case study question. I'll need to read through the details carefully and think about the most practical, efficient solution for the user's needs.