Explanation:
The correct answer is SHALLOW CLONE. If you need to quickly create a copy of a table to test changes without altering the original table, SHALLOW CLONE is an excellent choice. It copies only the Delta transaction logs, making the process very fast.
CREATE OR REPLACE TABLE {new_table_name} SHALLOW CLONE {source_table_name}|[LOCATION path]
CREATE OR REPLACE TABLE {new_table_name} SHALLOW CLONE {source_table_name}|[LOCATION path]
In contrast, DEEP CLONE copies all data and metadata from the source to the target table, which can be time-consuming depending on the table's size.
CREATE OR REPLACE TABLE {new_table_name} DEEP CLONE {source_table_name}|[LOCATION path]
CREATE OR REPLACE TABLE {new_table_name} DEEP CLONE {source_table_name}|[LOCATION path]
Ultimate access to all questions.
No comments yet.
The data engineering team plans to add a new column to a table, but the QA team needs to test this change before it goes into production. Which option allows for a quick copy of the table from production to the QA environment for modification and testing?
A
DEEP CLONE
B
SHADOW CLONE
C
ZERO COPY CLONE
D
SHALLOW CLONE
E
METADATA CLONE