Microsoft
DP-700 · Question #42
You have a Fabric workspace that contains a warehouse named Warehouse1. In Warehouse1, you create a table named DimCustomer by running the following statement: CREATE TABLE dbo.DimCustomer (…
The correct sequence of code segments is: 1. ALTER TABLE dbo.DimCustomer 2. ADD CONSTRAINT PK_DimCustomer PRIMARY KEY NONCLUSTERED (CustomerKey) 3. NOT ENFORCED Explanation: PRIMARY KEY is only supported when NONCLUSTERED and NOT ENFORCED are both used…
Design and implement data modeling
Question
You have a Fabric workspace that contains a warehouse named Warehouse1. In Warehouse1, you create a table named DimCustomer by running the following statement: CREATE TABLE dbo.DimCustomer ( CustomerKey VARCHAR(255) NOT NULL, Name VARCHAR(255) NOT NULL, Email VARCHAR(255) NOT NULL ); 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.
Explanation
The correct sequence of code segments is: 1. ALTER TABLE dbo.DimCustomer 2. ADD CONSTRAINT PK_DimCustomer PRIMARY KEY NONCLUSTERED (CustomerKey) 3. NOT ENFORCED Explanation: PRIMARY KEY is only supported when NONCLUSTERED and NOT ENFORCED are both used. https://learn.microsoft.com/en-us/fabric/data-warehouse/table-constraints
Topics
#Fabric Warehouse#SQL DDL#Primary Key#Table Constraints
Community Discussion
No community discussion yet for this question.