01. What is Zero Copy Cloning in Snowflake?
02. Which of the following can not be cloned using Zero Copy Cloning?
03. What happens to storage costs when you create a Zero Copy Clone?
04. Can Time Travel be used to recover a dropped table?
05. A developer creates a backup table using CTAS: CREATE TABLE CUSTOMER_BKP AS SELECT * FROM CUSTOMER; Which statement is true?
06. A developer clones a database containing a 10 TB CUSTOMER table: CREATE DATABASE CORE_CLONED_DB CLONE CORE_DB; Immediately after cloning, what is the storage impact?
07. Which command is used to clone a table in Snowflake?
08. What happens when a row is deleted from a cloned table?
09. Will temporary table be available in CLONED database?
10. What does cloning a database include?
11. A developer creates a clone of a table: CREATE TABLE CUSTOMER_CLONED CLONE CUSTOMER; After verifying the cloned data, the developer accidentally drops the original table: DROP TABLE CUSTOMER; The table retention period is set to 7 days. Which of the following statements is TRUE?
12. What does the condition CLONE_GROUP_ID = ID indicate in TABLE_STORAGE_METRICS?
13. What type of cloning is used when restoring a dropped object?
14. Can Time Travel be disabled on a table?
15. Which of the following is true about cloned objects?
16. What happens when a clone is created from a table that has Time Travel turned off?
17. Which clause lets you clone a table as it was 2 days ago?
18. Are constraints like primary keys cloned as part of Zero Copy Cloning?
19. Which feature enables recovery from accidental data deletion in Snowflake?
20. A database is cloned: CREATE DATABASE CORE_CLONED_DB CLONE CORE_DB; A user inserts 1 million new rows into: CORE_CLONED_DB.CORE_SCHEMA.CUSTOMER; What happens?
