Configure Cloning and Data Retention DEA-C02 Practice Questions (Page 1)

Questions 1–5

1. 1foundation · easy

   In Snowsight, which action allows you to create a clone of a database?

   • ASelect the database, then choose 'Clone' from the '...' menu.
   • BRun a SQL command from the worksheet, but Snowsight does not support cloning.
   • COpen the database and click 'Copy' in the top-right corner.
   • DUse the 'Export' function to create a clone of the database.
   Reveal Solution Discussion Select an answer first
2. 2foundation · easy

   What is the default time travel retention period for a permanent table in Snowflake?

   • A0 days
   • B30 days
   • C1 day
   • D7 days
   Reveal Solution Discussion Select an answer first
4. 3expert · hard

   A company has an account-level DATA_RETENTION_TIME_IN_DAYS of 1. A database has its retention set to 3 days. A schema within that database has its retention set to 0. A table in that schema has its retention explicitly set to 5 days. The table is dropped at noon. Until when can the table be recovered using time travel?

   • AUntil noon + 0 days, because the schema-level setting of 0 disables retention
   • BUntil noon + 3 days, because the database setting is the highest non-zero parent
   • CUntil noon + 5 days, because the table's explicit setting takes precedence
   • DUntil noon + 1 day, because the account-level setting is the ultimate default
   Reveal Solution Discussion Select an answer first
5. 4foundation · easy

   Which SQL clause is used to query data as of a specific timestamp within the time travel window?

   • AAT (TIMESTAMP => '2024-01-01 12:00:00')
   • BAS OF (TIMESTAMP => '2024-01-01 12:00:00')
   • CBEFORE (TIMESTAMP => '2024-01-01 12:00:00')
   • DAT (TIME => '2024-01-01 12:00:00')
   Reveal Solution Discussion Select an answer first
6. 5foundation · medium

   A Snowflake administrator is planning to clone a database to support a development environment. Which restriction applies to cloning in Snowflake?

   • AA database can be cloned to any account if the source and target share the same cloud provider.
   • BA database can be cloned across regions only if the source database is not encrypted.
   • CA database can be cloned across accounts only if both accounts are in the same region.
   • DA database can only be cloned within the same account and region.
   Reveal Solution Discussion Select an answer first