Microsoft Exam DP-700 Topic 1 Question 12 Discussion

Actual exam question for Microsoft's DP-700 exam

Question #: 12
Topic #: 1

[All DP-700 Questions]

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.

Show Suggested Answer

Suggested Answer:

by Johnathan at Mar 25, 2025, 03:22 AM

Limited Time Offer

25%

Off

Get Premium DP-700 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Dona

10 days ago

Yes, we should move the appropriate code segments to the answer area and arrange them correctly.

upvoted 0 times

...

Kenny

11 days ago

Should we run the code segments in the order they are listed?

upvoted 0 times

...

Merrilee

14 days ago

Primary keys, the foundation of any good data model. This'll be a piece of cake!

upvoted 0 times

...

Dona

15 days ago

I agree, that will help maintain data integrity.

upvoted 0 times

...

Tyra

19 days ago

Ah, the age-old question of how to make a table work. Just gotta get those key constraints set up properly.

upvoted 0 times

Stephaine

4 days ago

Drag the code segment that sets the Customerkey column as the primary key of the DimCustomer table to the answer area.

upvoted 0 times

...

Daron

28 days ago

Hmm, this seems straightforward. Just need to set the CustomerKey column as the primary key, no problem!

upvoted 0 times

Deane

4 days ago

Drag the code segment that sets the CustomerKey column as the primary key to the answer area.

upvoted 0 times

...

Lilli

17 days ago

Drag the code segment that creates the DimCustomer table to the answer area.

upvoted 0 times

...

Kenny

29 days ago

I think we need to set the Customerkey column as the primary key.

upvoted 0 times

...