Implementing Analytics Solutions Using Microsoft Fabric — Question 83

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?

Answer options

• 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;

Correct answer: C

Explanation

The correct answer is C because using 'CREATE TABLE ... AS CLONE OF' efficiently creates a reference to the original table without duplicating the data. The other options involve copying the data, which does not meet the requirement to minimize data transfer.