Exam DP-600 topic 1 question 123 discussion

Actual exam question from Microsoft's DP-600

Question #: 123
Topic #: 1

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.

Show Suggested Answer

Suggested Answer:

by mghf61 at Nov. 18, 2024, 11:04 a.m.

Comments

Submit Cancel

mghf61

Highly Voted 8 months, 2 weeks ago

it should be Yes.No.No the clone will create same table structure as first one

upvoted 24 times

f0dd605

7 months, 4 weeks ago

first is "Yes". Check documentation: https://learn.microsoft.com/en-us/sql/t-sql/statements/create-table-as-clone-of-transact-sql?view=fabric

upvoted 4 times

...

MultiCloudIronMan

8 months ago

I disagree, No No No - No, the CREATE TABLE ... AS CLONE statement does not copy only the metadata. It creates a new table that includes both the structure (metadata) and the data of the original table. This means that the new table test.FactSales will have the same columns, data types, and data as the original table dbo.FactSales.

upvoted 7 times

SKM1964

7 months, 2 weeks ago

Creates a new table as a zero-copy clone of another table in Warehouse in Microsoft Fabric. Only the metadata of the table is copied. The underlying data of the table, stored as parquet files, is not copied. Reference: https://learn.microsoft.com/en-us/sql/t-sql/statements/create-table-as-clone-of-transact-sql?view=fabric

upvoted 5 times

SKM1964

7 months, 2 weeks ago

So the answer for me is: Yes, No, No

upvoted 2 times

...

shorymor

8 months ago

Agree. Correct answer should be yes no no

upvoted 4 times

4b35503

7 months, 3 weeks ago

Yes, No, No REF https://learn.microsoft.com/en-us/sql/t-sql/statements/create-table-as-clone-of-transact-sql?view=fabric&preserve-view=true Creates a new table as a zero-copy clone of another table in Warehouse in Microsoft Fabric. Only the metadata of the table is copied. The underlying data of the table, stored as parquet files, is not copied. REF https://learn.microsoft.com/en-us/fabric/data-warehouse/clone-table Separate and independent Upon creation, a table clone is an independent and separate copy of the data from its source. Any changes made through DML or DDL on the source of the clone table are not reflected in the clone table.Similarly, any changes made through DDL or DML on the table clone are not reflected on the source of the clone table.

upvoted 5 times

...

PradeepikaGadai

Most Recent 2 months, 1 week ago

it should be yes , no yes : Since shallow clones share the same Delta data files, changes to data in one table are reflected in the other.

upvoted 1 times

...