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

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

Jackie

2 months ago

C) CREATE TABLE schema2.city AS SELECT * FROM schemal.city;

upvoted 0 times

...

Sean

2 months ago

B) CREATE TABLE schema2.city AS CLONE OF schemal.city;

upvoted 0 times

...

Janna

2 months ago

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

upvoted 0 times

...

Wynell

4 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

Christoper

2 months ago

Option D doesn't seem like the right choice in this scenario.

upvoted 0 times

...

Georgiana

2 months ago

I would go with Option C for clarity.

upvoted 0 times

...

Joseph

2 months ago

I agree, Option B seems simpler and more straightforward.

upvoted 0 times

...

Luisa

3 months ago

I think Option A is the best choice.

upvoted 0 times

...

Mabelle

4 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

4 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

3 months ago

User 2

upvoted 0 times

...

Sol

3 months ago

User 1

upvoted 0 times

...

Tracey

4 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

4 months ago

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

upvoted 0 times

...

Valda

4 months ago

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

upvoted 0 times

Jettie

2 months ago

User4: Option B is definitely the cleanest solution for minimizing data copying.

upvoted 0 times

...

Zack

2 months ago

User3: I agree, option B looks like the way to go.

upvoted 0 times

...

Kristine

2 months ago

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

upvoted 0 times

...

Julianna

2 months ago

User1: I think option B is the best choice.

upvoted 0 times

...

Carmela

2 months ago

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

upvoted 0 times

...

Carey

2 months ago

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

upvoted 0 times

...

Veronika

2 months ago

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

upvoted 0 times

...

Val

3 months ago

User1: Option B looks like the way to go.

upvoted 0 times

...

Shanice

4 months ago

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

upvoted 0 times

...