Microsoft DP-600 Exam - Topic 2 Question 50 Discussion

Actual exam question for Microsoft's DP-600 exam

Question #: 50
Topic #: 2

You have a Fabric tenant that contains a warehouse named DW1 and a lakehouse named LH1. DW1 contains a table named Sales.Product. LH1 contains a table named Sales.Orders.

You plan to schedule an automated process that will create a new point-in-time (PIT) table named Sales.ProductOrder in DW1. Sales.ProductOrder will be built by using the results of a query that will join Sales.Product and Sales.Orders.

You need to ensure that the types of columns in Sales. ProductOrder match the column types in the source tables. The solution must minimize the number of operations required to create the new table.

Which operation should you use?

ACREATE TABLE AS SELECT (CTAS)

BINSERT INTO

CCREATE MATERIALIZED VIEW AS SELECT

DCREATE TABLE AS CLONE OF

Show Suggested Answer

Suggested Answer: A

by Tommy at May 01, 2026, 05:37 PM

Limited Time Offer

25%

Off

Get Premium DP-600 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Lezlie

5 days ago

I'm not entirely sure, but I remember something about using INSERT INTO for appending data. Would that be efficient here?

upvoted 0 times

...

Ezekiel

10 days ago

I think the CTAS option might be the best choice since it allows you to create the new table directly from the query results.

upvoted 0 times

...