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

Georgene

29 days ago

I heard the Fabric team is working on a new feature called 'schema2.city.exe' for an even more efficient data cloning process.

upvoted 0 times

Janna

7 days ago

A) INSERT INTO schema2.city SELECT * FROM schemal.city;

upvoted 0 times

...

Wynell

1 months 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

Joseph

8 days ago

I agree, Option B seems simpler and more straightforward.

upvoted 0 times

...

Luisa

22 days ago

I think Option A is the best choice.

upvoted 0 times

...

Mabelle

1 months 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

2 months 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

Theola

22 days ago

User 2

upvoted 0 times

...

Sol

24 days ago

User 1

upvoted 0 times

...

Tracey

2 months 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

2 months ago

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

upvoted 0 times

...

Valda

2 months ago

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

upvoted 0 times

Kristine

4 hours ago

User2: Yeah, option B seems like the most efficient solution.

upvoted 0 times

...

Julianna

1 days ago

User1: I think option B is the best choice.

upvoted 0 times

...

Carmela

4 days ago

User1: True, but Option B specifically mentions minimizing data copying.

upvoted 0 times

...

Carey

6 days ago

User3: I think Option C could also work, just selecting the data from schemal.city.

upvoted 0 times

...

Veronika

7 days ago

User2: I agree, it seems like the most efficient solution.

upvoted 0 times

...

Val

18 days ago

User1: Option B looks like the way to go.

upvoted 0 times

...

Shanice

2 months ago

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

upvoted 0 times

...