Q: 19
DRAG DROP You have a Fabric . 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. 
Drag & Drop
Discussion
ALTER TABLE dbo. DimCustomer, ADD CONSTRAINT PK_DimCustomer PRIMARY KEY NONCLUSTERED, NOT ENFORCED. Super clear question order here.
Yeah, for Fabric warehouses you go with ALTER TABLE dbo. DimCustomer, ADD CONSTRAINT PK_DimCustomer PRIMARY KEY NONCLUSTERED, NOT ENFORCED. Only NONCLUSTERED and NOT ENFORCED are supported for primary keys here, pretty sure. Anyone see reason to pick a different order?
Had something like this in a mock, I did ALTER TABLE, ADD CONSTRAINT with CLUSTERED, ENFORCED. Seemed to fit but not sure if that matches Fabric specifics.
Ugh, Fabric syntax always feels confusing but I'd do ALTER TABLE dbo. DimCustomer, ADD CONSTRAINT PK_DimCustomer PRIMARY KEY CLUSTERED, ENFORCED.
Be respectful. No spam.