Q: 5
HOTSPOT Select the answer that correctly completes the sentence. 
Your Answer
Discussion
Gotta watch for unique vs primary here, it's primary key.
PRIMARY KEY
That should be PRIMARY KEY. Only primary key enforces both uniqueness and not allowing NULLs. Pretty sure that's what the question describes.
Primary key. Similar exam question tripped me up when I forgot about the not-null part, so unless it only talks about unique values, primary key is right here. Correct me if I missed something in the wording.
For stuff like this I’d recommend going through the official Microsoft Learn DP-900 modules and maybe review some practice exams. Had a similar primary key/entity integrity question pop up before so pretty sure that’s the angle here.
Primary key
Had something like this in a mock and went with unique constraint.
Primary key for sure. Unique lets NULLs through, primary is the strict one the exam wants here.
Unique constraint (saw similar wording on a practice test), but PK is the obvious trap.
Unique constraint (based on some exam reports, but check the official DP-900 modules just to be sure).
Be respectful. No spam.
