A Clarity table's primary key includes a line count. What does this indicate?

A Clarity table's primary key includes a line count. What does this indicate?

• A. Line counts indicate the number of times data is updated.
• B. All tables with a line count extract single-response items.
• C. Line counts indicate the number of columns in the table.
• D. Only Chronicles items with a response type of multiple-response or related group have line counts, so you know the table must extract multiple-response or related group items.

Answer: (D)

Line count in the primary key shows that this row is one line of a multi-line item. In Clarity, some Chronicles items can produce several lines of data—for example, a multiple-response question (where more than one option can be chosen) or a related-group item (a set of sub-items). The line number differentiates each line within the same parent item, so the table can store and reconstruct all the lines that belong to that parent. Because of that, you know the table is extracting multiple-response or related-group items, not just a single-line item. It’s not about how often data is updated or about how many columns there are; it’s about handling multiple lines per parent item.

Line count in the primary key shows that this row is one line of a multi-line item. In Clarity, some Chronicles items can produce several lines of data—for example, a multiple-response question (where more than one option can be chosen) or a related-group item (a set of sub-items). The line number differentiates each line within the same parent item, so the table can store and reconstruct all the lines that belong to that parent. Because of that, you know the table is extracting multiple-response or related-group items, not just a single-line item. It’s not about how often data is updated or about how many columns there are; it’s about handling multiple lines per parent item.