Microsoft Azure Data Fundamentals DP-900 Practice Question
You are designing a table in a relational database. You must guarantee that every row can be uniquely identified and that the identifying column cannot contain NULL values. Which relational data feature satisfies this requirement?
A primary key constraint enforces entity integrity by requiring that the selected column or combination of columns contain unique, non-NULL values for every row. Foreign keys enforce referential integrity between tables but do not guarantee uniqueness in the referenced table. A unique index that allows NULLs can still store multiple NULLs and therefore does not fully meet the requirement. A default constraint only supplies a value when none is provided; it does not enforce uniqueness or prevent NULLs on its own.
Ask Bash
Bash is our AI bot, trained to help you pass your exam. AI Generated Content may display inaccurate information, always double-check anything important.
What is the purpose of a primary key in a relational database?
Open an interactive chat with Bash
How does a foreign key differ from a primary key in relational databases?
Open an interactive chat with Bash
Why can't a unique index that allows NULLs be used instead of a primary key?
Open an interactive chat with Bash
Microsoft Azure Data Fundamentals DP-900
Identify considerations for relational data on Azure
Your Score:
Report Issue
Bash, the Crucial Exams Chat Bot
AI Bot
Loading...
Loading...
Loading...
Pass with Confidence.
IT & Cybersecurity Package
You have hit the limits of our free tier, become a Premium Member today for unlimited access.
Military, Healthcare worker, Gov. employee or Teacher? See if you qualify for a Community Discount.
Monthly
$19.99
$19.99/mo
Billed monthly, Cancel any time.
3 Month Pass
$44.99
$14.99/mo
One time purchase of $44.99, Does not auto-renew.
MOST POPULAR
Annual Pass
$119.99
$9.99/mo
One time purchase of $119.99, Does not auto-renew.
BEST DEAL
Lifetime Pass
$189.99
One time purchase, Good for life.
What You Get
All IT & Cybersecurity Package plans include the following perks and exams .