Teradata Vantage Certified Associate — Question 18

A transaction table tracks customer account activity. An administrator wants to ensure that every customer account number in the transaction table has a matching entry in the customer table.
Which capability makes this an appropriate use case for a relational model?

Answer options

Correct answer: A

Explanation

Referential integrity ensures that relationships between tables remain consistent, meaning that every customer account number in the transaction table must match an entry in the customer table. The other options, such as authenticity verification and cross domain validation, do not specifically address the need for matching entries between tables, while check integrity is a broader term that does not specifically apply to relational database constraints.