For a survey, how many rows are added to the Response table per question in the survey?

• A. One
• B. One per question in the survey
• C. The total number of questions
• D. None

Answer: (B)

In a survey data model, you allocate a separate place to store each question’s answer, so there is one row in the Response table for every question included in the survey. This setup gives a clean, direct association between a specific question and its answer, which makes querying for per-question statistics or linking responses back to the exact question straightforward. When a respondent completes the survey, that same row for each question is filled with the respondent’s answer, so the total number of response rows grows with the number of respondents times the number of questions. If you tried to store all answers in fewer rows, you’d lose the clear mapping between each question and its answer and make analysis more complex. Therefore, one row per question in the survey is the intended design.