Exam CSCP All Questions

View all questions & answers for the CSCP exam

Exam DP-600 topic 1 question 39 discussion

Actual exam question from APICS's CSCP

Question #: 39
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 Momoanwar at Feb. 18, 2024, 12:44 a.m.

Comments

Submit Cancel

thuss

Highly Voted 1 year, 4 months ago

Just took the exam. In the actual answers the typo in A is gone, and c actually reads "Additional data changes".

upvoted 18 times

Pegooli

11 months, 3 weeks ago

for additional data changes will apply, did you select "YES"?

upvoted 1 times

Martin_Nbg

9 months, 1 week ago

The answer would be No. From the documentation: Table clones help to create historical reports that reflect the state of data as it existed as of a specific point-in-time in the past.

upvoted 1 times

...

a_51

1 year, 3 months ago

That was the same for my exam. There were many other new questions, but I found at the end when I was reviewing there is the Microsoft Learn documentation that can be opened in the exam and really wish I had known that earlier as you are permitted to use it. I passed the exam, but sharing that other is there as there was some questions for new syntax I had not used, but once I looked up I had guessed right for them. One was a SQL statement to use a function called GREATEST and another was a question about merging schema in python. There were many questions of putting things in the right order to have something work proper. One was related to reviewing DAX performance and another related to order of pipeline for establishing a Bronze, Silver, Gold set of data.

upvoted 17 times

...

SamuComqi

Highly Voted 1 year, 4 months ago

Y - N - N The AS CLONE AS creates a replica of the original table by copying the metadata (no data). The two copies are independent therefore any changes will not be inherited. Source: https://learn.microsoft.com/en-us/fabric/data-warehouse/clone-table

upvoted 11 times

...

Rakesh16

Most Recent 7 months, 3 weeks ago

Yes,No,No

upvoted 1 times

...

dev2dev

1 year ago

actual typo is in the table name its going to create. its not dbo.Sales for sure. 1st option is yes only if there is no typo

upvoted 2 times

...

dev2dev

1 year, 1 month ago

If there are no typos in the choices first choice is NO because we are not closing dbo.Sales but dbo.FactSales

upvoted 3 times

...

stilferx

1 year, 2 months ago

IMHO, Y -> N -> N Because of: 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. in https://learn.microsoft.com/en-us/sql/t-sql/statements/create-table-as-clone-of-transact-sql?view=fabric&preserve-view=true and 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. in https://learn.microsoft.com/en-us/fabric/data-warehouse/clone-table#separate-and-independent

upvoted 3 times

...

XiltroX

1 year, 4 months ago

This is such a weird question. in the first statement, there is a typo and the question contains dbo.Sales when in fact, the original table is dbo.FactSales. I guess there was a typo so I'll let that pass and the answer is that YES, a replica is created of the original table. The 2nd and 3rd questions are exact replicas of each other so both of their answers are NO. Any changes done after the cloning will not directly affect the cloned table.

upvoted 2 times

...

estrelle2008

1 year, 4 months ago

YNN is correct now. Second and third statements are equal "Additional schema changes to dbo.FactSales will also apply to test.FactSales" What happens with this statement: - A new table called test.FactSales is created. - The structure (columns, data types, constraints) of test.FactSales will be identical to that of Dbo.FactSales at the time of creation. - The data in test.FactSales will be a snapshot of the data in Dbo.FactSales at the moment of table creation.

upvoted 2 times

...