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 1 month, 2 weeks ago

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

upvoted 12 times

f0dd605

1 month 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 3 times

...

MultiCloudIronMan

1 month 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 4 times

SKM1964

2 weeks, 6 days 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 3 times

SKM1964

2 weeks, 6 days ago

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

upvoted 2 times

...

shorymor

1 month, 1 week ago

Agree. Correct answer should be yes no no

upvoted 2 times

4b35503

3 weeks, 3 days 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 3 times

...

Exam DP-600 All Questions

View all questions & answers for the DP-600 exam

Exam DP-600 topic 1 question 123 discussion

Comments

mghf61

f0dd605

MultiCloudIronMan

SKM1964

SKM1964

shorymor

4b35503

SY0-701