Exam SnowPro Advanced Data Engineer topic 1 question 62 discussion

Actual exam question from Snowflake's SnowPro Advanced Data Engineer

Question #: 62
Topic #: 1

[All SnowPro Advanced Data Engineer Questions]

Database XYZ has the data_retention_time_in_days parameter set to 7 days and table XYZ.public.ABC has the data_retention_time_in_days set to 10 days.
A Developer accidentally dropped the database containing this single table 8 days ago and just discovered the mistake.
How can the table be recovered?

A. undrop database xyz;
B. create table abc_restore as select * from xyz.public.abc at (offset => -60*60*24*8);
C. create table abc_restore clone xyz.public.abc at (offset => -3600*24*8);
D. Create a Snowflake Support case to restore the database and table from Fail-safe.

Show Suggested Answer

Suggested Answer: D 🗳️

by Snow_P at Nov. 18, 2023, 4:03 p.m.

Comments

Submit Cancel

Snow_P

Highly Voted 1 year, 2 months ago

Selected Answer: D

I think D, the retention period for the table although longer should not be honored when dropping the DB, the table should have been dropped first

upvoted 5 times

...

prshntdxt7

Most Recent 1 year ago

Selected Answer: D

A.Snowflake does not provide a direct undrop command for databases or tables. B.The at (offset => -60*60*24*8) syntax is not a valid way to recover dropped tables in Snowflake. The at clause is used for temporal queries, and it doesn't have the capability to recover dropped tables. C.However, it does not have the ability to recover dropped tables. The at (offset => -3600*24*8) part is not a valid syntax for recovering dropped tables. D. Create a Snowflake Support case to restore the database and table from Fail-safe. This is the correct option. Snowflake's Fail-safe feature is designed for recovering dropped tables or databases within a specified retention period. By creating a support case, you can request assistance from Snowflake support to restore the dropped database and table from Fail-safe, ensuring data recovery within the allowed retention time.

upvoted 1 times

...

Maicas

1 year ago

Selected Answer: D

Just like Snow_P said, D is the correct answer. https://docs.snowflake.com/en/user-guide/data-time-travel#dropped-containers-and-object-retention-inheritance

upvoted 1 times

...