Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

Microsoft Exam DP-600 Topic 3 Question 34 Discussion

Actual exam question for Microsoft's DP-600 exam
Question #: 34
Topic #: 3
[All DP-600 Questions]

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?

Show Suggested Answer Hide Answer
Suggested Answer: B

Contribute your Thoughts:

Shanice
23 hours ago
I think the correct answer is C) CREATE TABLE schema2.city AS SELECT * FROM schemal.city;
upvoted 0 times
...

Save Cancel