MENU
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?
Suggested Answer: A
Get Premium DP-600 Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
26 comments · newest first
BR
Breana
3 days ago
I think A) CTAS is the best choice. It creates the table directly from the query.
NO
Noelia
8 days ago
I like A) CTAS too. Quick and straightforward for this scenario.
DI
Diane
14 days ago
C) MATERIALIZED VIEW could be useful, but it complicates things.
LE
Lelia
19 days ago
I feel like B) INSERT INTO is too many steps. CTAS is cleaner.
MA
Mattie
24 days ago
But CLONE won’t work if you need to join tables. CTAS is more flexible.
LA
Lashanda
29 days ago
I’m leaning towards D) CLONE. It’s efficient if the structure is the same.
KR
Krissy
1 month ago
Agreed! CTAS minimizes operations and matches column types easily.
LA
Lakeesha
1 month ago
I think A) CTAS is the best choice. It creates the table directly from the query.
DO
Dorothy
1 month ago
Right! CTAS is the way to go.
PE
Pete
2 months ago
But we need a new table, not a view.
NO
Noah
2 months ago
Option C is interesting for materialized views, though.
SH
Shawana
2 months ago
I feel confident with CTAS too. Less hassle.
JO
Joaquin
2 months ago
CTAS guarantees that. It’s straightforward.
AP
Apolonia
2 months ago
True, but we need to ensure column types match.
YU
Yuki
3 months ago
But what about option D? Cloning could save time.
DO
Dorothy
3 months ago
Agreed! It creates the table directly from the query.
MA
Marnie
3 months ago
I think option A is the best. CTAS is efficient.
GA
Galen
3 months ago
D) CREATE TABLE AS CLONE OF is interesting, but not sure it fits here.
GL
Glenn
3 months ago
Wait, can you really match types with CTAS? Sounds too easy!
MI
Mitsue
3 months ago
A) CTAS definitely minimizes operations.
ED
Edison
4 months ago
I disagree, B) INSERT INTO could work too.
NI
Nina
4 months ago
A) CTAS is the way to go for this!
LE
Leatha
4 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.
FR
Franklyn
5 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.
LE
Lezlie
6 months ago
I'm not entirely sure, but I remember something about using INSERT INTO for appending data. Would that be efficient here?
EZ
Ezekiel
6 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.