Q: 14
HOTSPOT
You have a Fabric tenant that contains a warehouse named Warehouse1. Warehouse1 contains a fact
table named FactSales that has one billion rows. You run the following T-SQL statement.
CREATE TABLE test.FactSales AS CLONE OF Dbo.FactSales;
For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE:
Each correct selection is worth one point.
Your Answer
Discussion
Its Yes, No, No. The CLONE copies all current data and structure at that moment but doesn't sync changes after. So any later table or data changes in dbo.FactSales won't show up in the cloned table. Pretty sure that's right, correct me if not.
Be respectful. No spam.
