Implementing Analytics Solutions Using Microsoft Fabric — Question 128

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?

Answer options

• A. INSERT INTO
• B. CREATE TABLE AS SELECT (CTAS)
• C. CREATE TABLE AS CLONE OF
• D. CREATE MATERIALIZED VIEW AS SELECT

Correct answer: B

Explanation

The correct answer is B, CREATE TABLE AS SELECT (CTAS), because it allows you to create a new table while directly selecting and copying the data from the source tables, ensuring that the column types match without additional operations. The other options either do not create a new table with the required column types or involve more complex processes that would not minimize operations.