Pre-Summer Special Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: validbest

Discussions
  1. Home
  2. Discussions
  3. Microsoft
  4. Microsoft Certified: Fabric Analytics Engineer Associate
  5. DP-600 Discussions
  6. DP-600 Exam Topic 3 Question 23 Discussion
 Microsoft Discussions
Exam DP-600 All Questions
Exam DP-600 All Questions

View all questions & answers for the DP-600 exam

Go to Exam

Microsoft Certified: Fabric Analytics Engineer Associate DP-600 Question # 23 Topic 3 Discussion

DP-600 Exam Topic 3 Question 23 Discussion:
Question #: 23
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?
A.

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

B.

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

C.

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

D.

SELECT * INTO schema2.eity FROM schemal.city;

Get Premium DP-600 Questions
Actual exam question for Microsoft DP-600 exam by Kairo7673 at May 9, 2026, 3:08:43 AM

Contribute your Thoughts:


Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.

Submit