Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Microsoft DP-600 Exam - Topic 2 Question 50 Discussion

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?
A) CREATE TABLE AS SELECT (CTAS)
B) INSERT INTO
C) CREATE MATERIALIZED VIEW AS SELECT
D) CREATE TABLE AS CLONE OF

Microsoft DP-600 Exam - Topic 2 Question 50 Discussion

Actual exam question for Microsoft's DP-600 exam
Question #: 50
Topic #: 2
[All DP-600 Questions]

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?

Show Suggested Answer Hide 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:

0/2000 characters
Submit Cancel
Pete
4 days ago
But we need a new table, not a view.
upvoted 0 times
...
Noah
9 days ago
Option C is interesting for materialized views, though.
upvoted 0 times
...
Shawana
14 days ago
I feel confident with CTAS too. Less hassle.
upvoted 0 times
...
Joaquin
20 days ago
CTAS guarantees that. It’s straightforward.
upvoted 0 times
...
Apolonia
25 days ago
True, but we need to ensure column types match.
upvoted 0 times
...
Yuki
30 days ago
But what about option D? Cloning could save time.
upvoted 0 times
...
Dorothy
1 month ago
Agreed! It creates the table directly from the query.
upvoted 0 times
...
Marnie
1 month ago
I think option A is the best. CTAS is efficient.
upvoted 0 times
...
Galen
2 months ago
D) CREATE TABLE AS CLONE OF is interesting, but not sure it fits here.
upvoted 0 times
...
Glenn
2 months ago
Wait, can you really match types with CTAS? Sounds too easy!
upvoted 0 times
...
Mitsue
2 months ago
A) CTAS definitely minimizes operations.
upvoted 0 times
...
Edison
2 months ago
I disagree, B) INSERT INTO could work too.
upvoted 0 times
...
Nina
2 months ago
A) CTAS is the way to go for this!
upvoted 0 times
...
Leatha
2 months ago
I wonder if CREATE TABLE AS CLONE OF could work, but I think it’s more for duplicating existing tables rather than joining data from two different sources.
upvoted 0 times
...
Franklyn
4 months ago
I feel like the CREATE MATERIALIZED VIEW could be useful, but it might not be the best fit for a one-time table creation like this.
upvoted 0 times
...
Lezlie
4 months 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
4 months 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
...

Save Cancel