Exam DISC-DA Practice Question 228

Study guide: Exam DISC-DA

An analyst needs one row per policy term with its claim count. The tables are policy_term (one row per term) and claim (one row per claim, with the term it belongs to). Which approach produces the right data set?

• A) Inner join claim to policy_term, then count rows for each term
• B) Count claims by term in claim, left join that onto policy_term, and set missing counts to 0
• C) Left join policy_term to claim and count rows for each term without changing nulls
• D) Count claims by term in claim and use that summary as the data set

Answer this question and see the worked solution

Concepts tested

• Data Preparation
• SQL
• Table Join
• Underwriting Modeling Dataset

More questions from this set

• Exam DISC-DA Practice Question 227
• Exam DISC-DA Practice Question 229