Question 150
A data professional makes this decision: Enforce referential integrity through relational key constraints. Which outcome is the most direct expected result?
Explanation
Correct Answer
This is the expected outcome for Consistency constraint: Invalid relationships are rejected rather than leaving orphaned references.
Incorrect Answers
This result would follow the different ETL processing decision (Classify the workflow as extract-transform-load data integration.) rather than the specified design.
This result would follow the different Stream anomaly decision (Choose a streaming or near-real-time analytical processing pattern.) rather than the specified design.
This result would follow the different OLTP checkout decision (Classify the checkout application as an online transactional processing workload.) rather than the specified design.