Preparing Practice Exam…
Please wait a moment while the system generates the exam questions, answers, and study session.
Please wait a moment while the system generates the exam questions, answers, and study session.
Question 28 of 40
Free Preview · 40 of 131 · questions 1–40 of 131 are free. Sign up free to sync your progress across devices.
Drag & Drop Scenario
Read the scenario requirements and decide your answer. Click Check Answer below to see the marked solution.
Hotspot Solution:
Primary Key Non Clustered Not enforced As a SQL developer I would use CLUSTERED and ENFORCED in SQL Server. But this appears to be a particular constraint within Fabric. The Details are as follows. "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" Source:
Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.
please correct the provided answer is incorrect one
Primary Key Non Clustered Not enforced As a SQL developer I would use CLUSTERED and ENFORCED in SQL Server. But this appears to be a particular constraint within Fabric. The Details are as follows. "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" Source: https://learn.microsoft.com/en-us/fabric/data-warehouse/table-constraints
ALTER TABLE myTable ADD CONSTRAINT PK_myTable PRIMARY KEY CLUSTERED (c1) ENFORCED; PRIMARY KEY must be enforced to guarantee uniqueness and non-null values. NOT ENFORCED is only valid for FOREIGN KEY or CHECK constraints, not for PRIMARY KEY.