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?

Question

Accepted Answer

C. CREATE TABLE schema2.city AS CLONE OF schema1.city;

Answer

A. INSERT INTO schema2.city SELECT * FROM schema1.city;

Answer

B. SELECT * INTO schema2.city FROM schema1.city;

Answer

D. CREATE TABLE schema2.city AS SELECT * FROM schema1.city;

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

Question

Options

How the community answered

Explanation

Topics

Community Discussion