DP-600 · Question #73
DP-600 Question #73: Real Exam Question with Answer & Explanation
The correct answer is C: CREATE TABLE schema2.city AS CLONE OF schema1.city;. https://learn.microsoft.com/en-us/fabric/data-warehouse/clone-table Microsoft Fabric offers the capability to create near-instantaneous zero-copy clones with minimal
Question
You have a Fabric tenant that contains a warehouse named Warehouse1. Warehouse1 contains two schemas name schema1 and schema2 and a table named schema1.city. You need to make a copy of schema1.city in schema2. The solution must minimize the copying of data. Which T-SQL statement should you run?
Options
- AINSERT INTO schema2.city SELECT * FROM schema1.city;
- BSELECT * INTO schema2.city FROM schema1.city;
- CCREATE TABLE schema2.city AS CLONE OF schema1.city;
- DCREATE TABLE schema2.city AS SELECT * FROM schema1.city;
Explanation
https://learn.microsoft.com/en-us/fabric/data-warehouse/clone-table Microsoft Fabric offers the capability to create near-instantaneous zero-copy clones with minimal
Topics
Community Discussion
No community discussion yet for this question.