Spring Sale Special Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: xmasmnth

You have a Fabric tenant that contains a warehouse named Warehouse!.

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;

Microsoft DP-600 Summary

  • Vendor: Microsoft
  • Product: DP-600
  • Update on: Feb 15, 2026
  • Questions: 166
Price: $52.5  $149.99
Buy Now DP-600 PDF + Testing Engine Pack

Payments We Accept

Your purchase with ExamsVCE is safe and fast. Your products will be available for immediate download after your payment has been received.
The ExamsVCE website is protected by 256-bit SSL from McAfee, the leader in online security.

examsvce payment method