Answer-first summary for fast verification
Answer: SHALLOW CLONE
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. ```sql 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. ```sql CREATE OR REPLACE TABLE {new_table_name} DEEP CLONE {source_table_name}|[LOCATION path] ```
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
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
No comments yet.