Cloning -2

When you clone a table, what happens initially?

• The clone does not consume additional storage

• The micro-partitions that make up the original table copied and allocated to the new table

• The clone is read only.

• Storage for all the micro-partitions is allocated to the orginal table

Which of the following is true about cloned tables?

• Clones tables are read only

• Cloned tables can access the time travel data of the original table

• Cloned tables can, in turn, be cloned

• Cloned tables must retain the same paramater values at the source (such as DATA_RETENTION_TIME_IN_DAYS)

Which of these statements will clone DB_A to DB_B?

• CLONE DB_A TO DB_B

• CLONE DB_B FROM DB_A

• CREATE DB_B CLONE DB_A

• CREATE DB_B FROM DB_A

• CLONE DB_A CREATE DB_B

With the Enterprise edition of Snowflake, what is the longest setting for the parameter DATA_RETENTION_TIME_IN_DAYS?

• 1 DAY

• 10 DAYS

• 90 DAYS

• 120 DAYS

What causes micro-partitons to go into time travel?

• Inserting data into a table

• Deleting data from a table

• Updating rows in a table

• Truncating a table

What are common use cases for database replication?

With DATABASE replication, which of the following objects will be replicated?

• Schemas

• Views

• Resource Monitors

• Tables

• Users