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%

Off

Get Premium DP-600 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Wynell

3 days ago

Option A might work, but it feels a bit overkill if we just need to copy the table. I'd go with Option B for simplicity.

upvoted 0 times

...

Mabelle

6 days ago

I'm leaning towards Option B as well. It seems like the most straightforward and elegant solution to the problem.

upvoted 0 times

...

Leah

12 days ago

Hmm, I'm not sure if Option D is a typo or someone's attempt at humor. 'schema2.eity' doesn't sound right.

upvoted 0 times

...

Tracey

16 days ago

I'm not sure, but I think option A could also work. It's always good to double-check the syntax though.

upvoted 0 times

...

Zona

17 days ago

I agree with Shanice, option C seems like the most efficient way to copy the table.

upvoted 0 times

...

Valda

17 days ago

Option B looks like the way to go. It's a clean and efficient solution that minimizes data copying.

upvoted 0 times

...

Shanice

22 days ago

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

upvoted 0 times

...