Exam DP-800 Topic 2 Question 28 Discussion

Actual exam question for Microsoft's DP-800 exam
Question #: 28
Topic #: 2
You have an Azure SQL database that contains a table named Rooms. Roomswas created by using the following Transact-SQL statement.

You discover that some records in the Rooms table contain NULL values for the Owner field.
You need to ensure that all future records have a value for the Owner field.
What should you add?

Suggested Answer: B Vote an answer

A CHECK constraint is one way to do it.
If you use a CHECK constraint (e.g., CHECK (ColumnName IS NOT NULL)), the database will indeed reject new NULL entries. However, the column's metadata will still technically allow NULLs, which can sometimes affect how external tools or APIs interact with your schema.
Reference:
https://www.postgresql.org/docs/7.0/sql-createtable.htm

by Hilda at Jun 27, 2026, 10:35 PM

Limited Time Offer

15%

Off

Get Premium DP-800 Questions as Interactive Self Test Engine or PDF

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
Nick name: Submit Cancel
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
0
0
0
10