ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam DP-600 All Questions

View all questions & answers for the DP-600 exam
Go to Exam

Exam DP-600 topic 1 question 82 discussion

Actual exam question from Microsoft's DP-600
Question #: 82
Topic #: 1
[All DP-600 Questions]

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.

Show Suggested Answer Hide Answer
Suggested Answer:
by clux at April 7, 2024, 3:36 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
clux
Highly Voted 1 year, 2 months ago
Correct answer
upvoted 20 times
...
VAzureD
Highly Voted 1 year, 1 month ago
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
upvoted 12 times
...
7d97b62
Most Recent 11 months, 1 week ago
Correct
upvoted 1 times
...
282b85d
1 year ago
CREATE TABLE dbo.POSCustomers AS SELECT DISTINCT customerid, customer, postalcode, category FROM lakehouse1.dbo.customer
upvoted 6 times
...
Nefirs
1 year, 1 month ago
answer is correct
upvoted 2 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel