Learn the most efficient T-SQL statement to create a copy of a table in a Fabric tenant, minimizing data copying and maximizing performance. Covers the use of the CLONE keyword in the CREATE TABLE statement.
Table of Contents
Question
You have a Fabric tenant that contains a warehouse named Warehouse1. Warehouse1 contains two schemas name schema1 and schema2 and a table named schema1.city.
You need to make a copy of schema1.city in schema2. The solution must minimize the copying of data.
Which T-SQL statement should you run?
A. INSERT INTO schema2.city SELECT * FROM schema1.city;
B. SELECT * INTO schema2.city FROM schema1.city;
C. CREATE TABLE schema2.city AS CLONE OF schema1.city;
D. CREATE TABLE schema2.city AS SELECT * FROM schema1.city;
Answer
C. CREATE TABLE schema2.city AS CLONE OF schema1.city;
Explanation
The “CREATE TABLE … AS CLONE OF” statement is the most efficient way to create a copy of a table in the same Fabric tenant. This statement creates a new table in the specified schema that is an exact clone of the source table, including the table structure, data, and indexes. This approach minimizes the amount of data copied, as it simply creates a reference to the underlying data rather than performing a full table scan and data copy.
Options A and B, which use INSERT INTO or SELECT INTO, would require scanning the entire source table and copying the data row-by-row, which is less efficient than the CLONE method.
Option D, CREATE TABLE … AS SELECT, would also work to create a copy of the table, but it would perform a full table scan and data copy, which is less efficient than the CLONE approach.
Microsoft DP-600 certification exam practice question and answer (Q&A) dump with detail explanation and reference available free, helpful to pass the Microsoft DP-600 exam and earn Microsoft DP-600 certification.