Exam DP-700 All Questions

View all questions & answers for the DP-700 exam

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 5 months, 1 week 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 41 times

mvg100

1 week, 6 days ago

This is correct, Primary Key Non Clustered Not Enforced https://learn.microsoft.com/en-us/fabric/data-warehouse/table-constraints

upvoted 1 times

...

bettermakeme

1 month, 2 weeks ago

This is the correct option, I have tired it in my warehouse ALTER TABLE [dbo].[dim_cust] ADD CONSTRAINT [PK_dim_cust_CustomerKey] PRIMARY KEY NONCLUSTERED (CustomerKey) NOT ENFORCED

upvoted 4 times

...

ChenFu

4 months, 1 week ago

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

upvoted 3 times

...

Othman2110

Highly Voted 4 months ago

Primary Key Non Clustered Not Enforced

upvoted 10 times

...

smanzana

Most Recent 1 week, 4 days ago

ALTER TABLE NONCLUSTERED NOT ENFORCED

upvoted 1 times

...

DataSturdy

2 weeks, 2 days ago

ALTER TABLE dbo.dimcustomer ADD CONSTRAINT PK_DimCustomer PRIMARY KEY NONCLUSTERED (customerkey) not ENFORCED this is the right answer

upvoted 1 times

...

turlakDE

2 weeks, 3 days ago

Alter table dbo.dimcustomer Add constraint PK_dimcustomer primary key nonclustered (customerkey) not enforced Alter table dbo.dimcustomer Add constraint PK_dimcustomer primary key nonclustered (customerkey) not enforced - This is from Microsoft documentation

upvoted 1 times

...

Rajib

2 weeks, 4 days ago

The provided answer is wrong Alter table dbo.dimcustomer Add constraint PK_dimcustomer primary key nonclustered (customerkey) not enforced https://learn.microsoft.com/en-us/fabric/data-warehouse/table-constraints

upvoted 1 times

...

PBridge

1 month ago

Correct Sequence: ALTER TABLE dbo.DimCustomer → Prepares the table to modify its structure. ADD CONSTRAINT PK_DimCustomer PRIMARY KEY CLUSTERED (CustomerKey) → Adds the primary key constraint to the column. Clustered is preferred by default unless specified otherwise. ENFORCED → Ensures referential integrity is applied.

upvoted 1 times

...

kim32

1 month, 2 weeks ago

https://learn.microsoft.com/en-us/fabric/data-warehouse/table-constraints 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

...

fassil

4 months 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 5 times

...

Tuki93

5 months 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.

upvoted 7 times

...