Exam DP-600 All QuestionsBrowse all questions from this exam
Question 82

HOTSPOT

-

You have a Fabric tenant that contains a workspace named Workspace1. Workspace1 contains a lakehouse named Lakehouse1 and a warehouse named Warehouse1.

You need to create a new table in Warehouse1 named POSCustomers by querying the customer table in Lakehouse1.

How should you complete the T-SQL statement? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

    Correct Answer:

Discussion
clux

Correct answer

VAzureD

https://learn.microsoft.com/en-us/fabric/data-warehouse/clone-table#limitations Table clones across warehouses in a workspace are not currently supported. ANSWER, AS SELECT

282b85d

CREATE TABLE dbo.POSCustomers AS SELECT DISTINCT customerid, customer, postalcode, category FROM lakehouse1.dbo.customer

Nefirs

answer is correct

7d97b62

Correct