Microsoft Azure Data Fundamentals DP-900 Practice Question

A foreign key constraint enforces referential integrity between two tables by ensuring that values in the child table (Orders) match existing primary-key values in the parent table (Customers). If a corresponding parent row does not exist, the database engine blocks the insert or update, preventing orphaned rows. A view is a virtual table that does not enforce data integrity. An index speeds up data retrieval but cannot enforce relationships. A stored procedure can contain logic that checks data, but the enforcement would be manual and not inherent to the table definition.