Exam DP-700 Topic 3 Question 35 Discussion

Actual exam question for Microsoft's DP-700 exam
Question #: 35
Topic #: 3
You have a Fabric workspace that contains a warehouse named Warehouse1.
In Warehouse1, you create a table named DimCustomer by running the following statement.

You need to set the Customerkey column as a primary key of the DimCustomer table.
Which three code segments should you run in sequence? To answer, move the appropriate code segments from the list of code segments to the answer area and arrange them in the correct order.

Suggested Answer:

by tejveersinghpundhir at Apr 09, 2025, 01:43 PM

Limited Time Offer

15%

Off

Get Premium DP-700 Questions as Interactive Self Test Engine or PDF

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
Nick name: Submit Cancel
machfer54
2025-05-09 17:03:47
NON CLUSTERED NOT ENFORCED ARE THE CORRECT ANSWERS
upvoted 1 times
...
tejveersinghpundhir
2025-04-09 13:43:36
SQL analytics endpoint and Warehouse in Microsoft Fabric support these table constraints:

PRIMARY KEY is only supported when NONCLUSTERED and NOT ENFORCED are both used.
FOREIGN KEY is only supported when NOT ENFORCED is used.
UNIQUE constraint is only supported when NONCLUSTERED and NOT ENFORCED are both used.
https://learn.microsoft.com/en-us/fabric/data-warehouse/table-constraints
upvoted 1 times
...
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.
0
0
0
10