Microsoft Azure Data Fundamentals DP-900 Practice Question
In a relational database, you need to ensure that an Order record cannot reference a Customer that does not exist. Which feature of relational data provides this capability for enforcing referential integrity between related tables?
Storing related entities inside embedded JSON columns
Distributing tables through horizontal partitioning (sharding)
Defining foreign key constraints that reference primary keys
Representing each table row as a key-value pair in a NoSQL store
Relational databases maintain relationships between tables by pairing a primary key in the parent table with a foreign key in the child table. A foreign key constraint guarantees that every value in the child column matches a valid primary-key value in the parent, so a row cannot reference a non-existent entity. Embedded JSON columns, horizontal sharding, and storing rows as key-value pairs are techniques associated with non-relational designs or physical deployment choices; none of them, by themselves, enforce referential integrity in a relational schema.
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 a primary key in a relational database?
Open an interactive chat with Bash
How does a foreign key work in a relational database?
Open an interactive chat with Bash
What is referential integrity in relational databases?
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 .