Microsoft Exam DP-600 Topic 3 Question 34 Discussion

Actual exam question for Microsoft's DP-600 exam

Question #: 34
Topic #: 3

You have a Fabric tenant that contains a warehouse named Warehouse!. Warehousel contains two schemas name schemal and schema2 and a table named schemal.city.

You need to make a copy of schemal.city in schema2. The solution must minimize the copying of data.

Which T-SQL statement should you run?

AINSERT INTO schema2.city SELECT * FROM schemal.city;

BCREATE TABLE schema2.city AS CLONE OF schemal.city;

CCREATE TABLE schema2.city AS SELECT * FROM schemal.city;

DSELECT * INTO schema2.eity FROM schemal.city;

Show Suggested Answer

Suggested Answer: B

by Shad at Mar 19, 2025, 04:44 AM

Limited Time Offer

25%

14 days ago

I think the correct answer is C) CREATE TABLE schema2.city AS SELECT * FROM schemal.city;

upvoted 0 times

...