ExamTopics Logo
Mail Us[email protected]
Menu
Apics Discussions
exam questions

Exam CSCP All Questions

View all questions & answers for the CSCP exam
Go to Exam

Exam DP-600 topic 1 question 39 discussion

Actual exam question from APICS's CSCP
Question #: 39
Topic #: 1
[All CSCP Questions]

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 Hide Answer
Suggested Answer:
by Momoanwar at Feb. 18, 2024, 12:44 a.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
thuss
Highly Voted 1 year, 1 month 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
9 months ago
for additional data changes will apply, did you select "YES"?
upvoted 1 times
Martin_Nbg
6 months, 2 weeks 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 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, 2 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 5 months, 1 week ago
Yes,No,No
upvoted 1 times
...
dev2dev
10 months 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
10 months, 3 weeks 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
11 months, 2 weeks 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, 1 month 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, 1 month 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
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago