Exam DP-700 topic 1 question 31 discussion

Actual exam question from Microsoft's DP-700

Question #: 31
Topic #: 1

DRAG DROP -
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 amli123 at Jan. 19, 2025, 4:20 p.m.

Comments

Submit Cancel

amli123

Highly Voted 3 months ago

Alter table dbo.dimcustomer Add constraint PK_dimcustomer primary key nonclustered (customerkey) not enforced PRIMARY KEY is only supported when NONCLUSTERED and NOT ENFORCED are both used. https://learn.microsoft.com/en-us/fabric/data-warehouse/table-constraints

upvoted 21 times

ChenFu

1 month, 4 weeks ago

ALTER TABLE dbo.DimCustomer ADD CONSTRAINT PK_DimCustomer PRIMARY KEY CLUSTERED (CustomerKey) ENFORCED

upvoted 1 times

...

abdulbasit170

Most Recent 6 days, 20 hours ago

Primary Key Non Clustered Not Enforced PRIMARY KEY is only supported when NONCLUSTERED and NOT ENFORCED are both used. https://learn.microsoft.com/en-us/fabric/data-warehouse/table-constraints

upvoted 2 times

...

Othman2110

1 month, 3 weeks ago

Primary Key Non Clustered Not Enforced

upvoted 4 times

...

fassil

1 month, 3 weeks ago

Alter table dbo.dimcustomer Add constraint PK_dimcustomer primary key nonclustered (customerkey) not enforced Create a Microsoft Fabric Warehouse table with a primary key: CREATE TABLE PrimaryKeyTable (c1 INT NOT NULL, c2 INT); ALTER TABLE PrimaryKeyTable ADD CONSTRAINT PK_PrimaryKeyTable PRIMARY KEY NONCLUSTERED (c1) NOT ENFORCED;

upvoted 3 times

...

Tuki93

2 months, 2 weeks ago

Provided answer is WRONG. https://learn.microsoft.com/en-us/fabric/data-warehouse/table-constraints 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. SQL analytics endpoint and Warehouse don't support default constraints at this time.