Ultimate access to all questions.
You have a Fabric tenant with a warehouse named DW1 and a lakehouse named LH1. DW1 contains a table named Sales.Product
, and LH1 contains a table named Sales.Orders
.
You plan to schedule an automated process to create a new point-in-time table named Sales.ProductOrder
in DW1. This table will be built from the results of a query that joins Sales.Product
and Sales.Orders
.
You need to ensure the column types 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?