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
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Microsoft DP-600 Exam - Topic 3 Question 34 Discussion

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?
B) CREATE TABLE schema2.city AS CLONE OF schemal.city;
A) INSERT INTO schema2.city SELECT * FROM schemal.city;
C) CREATE TABLE schema2.city AS SELECT * FROM schemal.city;
D) SELECT * INTO schema2.eity FROM schemal.city;

Microsoft DP-600 Exam - 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

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:

0/2000 characters
Submit Cancel
Chantay
9 months ago
Wait, is "CREATE TABLE AS CLONE OF" even a valid syntax?
upvoted 0 times
...
Alesia
10 months ago
I disagree, A seems more straightforward.
upvoted 0 times
...
Denae
10 months ago
B definitely sounds like the way to go!
upvoted 0 times
...
Charlene
10 months ago
I think C would just create a full copy, not efficient at all.
upvoted 0 times
...
Maile
10 months ago
Option B is the best choice for minimizing data copying.
upvoted 0 times
...
Lashonda
10 months ago
I'm leaning towards option A, but I wonder if it really minimizes the data copying like the question asks.
upvoted 0 times
...
Heidy
11 months ago
I feel like option C is a common approach, but it might not minimize data copying as effectively as option B.
upvoted 0 times
...
Felix
11 months ago
I remember practicing a similar question where we had to copy tables, but I can't recall if using "INSERT INTO" is the most efficient way.
upvoted 0 times
...
Marjory
11 months ago
I think option B sounds familiar, but I'm not entirely sure if "CLONE OF" is the right syntax for T-SQL.
upvoted 0 times
...
Lilli
11 months ago
I'm a little confused by the wording of this question. What exactly do they mean by "minimize the copying of data"? Is there a specific performance or storage concern we need to address? I'm leaning towards option A, but I want to make sure I fully understand the requirements first.
upvoted 0 times
...
Kanisha
12 months ago
Ah, this is a good one! I think option C is the way to go here. Creating a new table and selecting all the data from the original table is a classic SQL technique that should get the job done without any unnecessary data copying.
upvoted 0 times
...
Shawnna
12 months ago
Hmm, I'm a bit unsure about this one. I know we need to minimize the copying of data, but I'm not sure if the "CLONE OF" syntax is the right approach. Maybe I should double-check the other options to see if there's a more standard SQL solution.
upvoted 0 times
...
Crissy
12 months ago
This looks like a straightforward data copying task. I think I'll go with option B - it seems like the most efficient way to create a copy of the table without actually copying the data.
upvoted 0 times
...
Georgene
1 year 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
1 year ago
C) CREATE TABLE schema2.city AS SELECT * FROM schemal.city;
upvoted 0 times
...
Sean
1 year ago
B) CREATE TABLE schema2.city AS CLONE OF schemal.city;
upvoted 0 times
...
Janna
1 year ago
A) INSERT INTO schema2.city SELECT * FROM schemal.city;
upvoted 0 times
...
...
Wynell
1 year 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
1 year ago
Option D doesn't seem like the right choice in this scenario.
upvoted 0 times
...
Georgiana
1 year ago
I would go with Option C for clarity.
upvoted 0 times
...
Joseph
1 year ago
I agree, Option B seems simpler and more straightforward.
upvoted 0 times
...
Luisa
1 year ago
I think Option A is the best choice.
upvoted 0 times
...
...
Mabelle
1 year 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
1 year 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
1 year ago
User 2
upvoted 0 times
...
Sol
1 year ago
User 1
upvoted 0 times
...
...
Tracey
1 year 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
1 year ago
I agree with Shanice, option C seems like the most efficient way to copy the table.
upvoted 0 times
...
Valda
1 year ago
Option B looks like the way to go. It's a clean and efficient solution that minimizes data copying.
upvoted 0 times
Jettie
1 year ago
User4: Option B is definitely the cleanest solution for minimizing data copying.
upvoted 0 times
...
Zack
1 year ago
User3: I agree, option B looks like the way to go.
upvoted 0 times
...
Kristine
1 year ago
User2: Yeah, option B seems like the most efficient solution.
upvoted 0 times
...
Julianna
1 year ago
User1: I think option B is the best choice.
upvoted 0 times
...
Carmela
1 year ago
User1: True, but Option B specifically mentions minimizing data copying.
upvoted 0 times
...
Carey
1 year ago
User3: I think Option C could also work, just selecting the data from schemal.city.
upvoted 0 times
...
Veronika
1 year ago
User2: I agree, it seems like the most efficient solution.
upvoted 0 times
...
Val
1 year ago
User1: Option B looks like the way to go.
upvoted 0 times
...
...
Shanice
1 year ago
I think the correct answer is C) CREATE TABLE schema2.city AS SELECT * FROM schemal.city;
upvoted 0 times
...

Save Cancel