Manage Time Travel and Fail-Safe DEA-C02 Practice Questions (Page 4)

Questions 16–20

1. 16expert · medium

   A company is on Snowflake Enterprise edition and has a large table that is updated frequently. They are considering increasing the Time Travel retention from 1 day to 30 days to meet audit requirements. The data engineering team is concerned about storage costs. Which approach would minimize storage cost while meeting the audit requirement?

   • AUse a separate table to store historical snapshots and set the original table's retention to 1 day.
   • BSet DATA_RETENTION_TIME_IN_DAYS = 30 on the table.
   • CSet DATA_RETENTION_TIME_IN_DAYS = 30 on the account.
   • DSet DATA_RETENTION_TIME_IN_DAYS = 30 on the schema.
   Reveal Solution Discussion Select an answer first
2. 17foundation · easy

   How long is the Fail-safe recovery period in Snowflake?

   • A1 day
   • B30 days
   • C7 days
   • D90 days
   Reveal Solution Discussion Select an answer first
4. 18foundation · easy

   Which clause is used to query data as it existed exactly at a specific timestamp?

   • ABEFORE (TIMESTAMP => '...')
   • BWITH (TIMESTAMP => '...')
   • CAT (TIMESTAMP => '...')
   • DAS OF (TIMESTAMP => '...')
   Reveal Solution Discussion Select an answer first
5. 19foundation · easy

   Which of the following is a difference between Time Travel and Fail-safe?

   • ATime Travel is accessible only by support, while Fail-safe is user-accessible
   • BTime Travel is 7 days, while Fail-safe is 90 days
   • CTime Travel is configurable, while Fail-safe is not
   • DTime Travel is free, while Fail-safe is billed separately
   Reveal Solution Discussion Select an answer first
6. 20application · medium

   A company is on Snowflake Enterprise edition. They want to set the Time Travel retention period to 90 days for a specific table that contains financial data. The account-level parameter is set to 1 day. What is the correct way to achieve this?

   • AALTER ACCOUNT SET DATA_RETENTION_TIME_IN_DAYS = 90;
   • BALTER TABLE financial_data SET DATA_RETENTION_TIME_IN_DAYS = 90;
   • CCREATE TABLE financial_data CLONE financial_data AT (OFFSET => -90*86400);
   • DALTER DATABASE SET DATA_RETENTION_TIME_IN_DAYS = 90;
   Reveal Solution Discussion Select an answer first