True or False: A Clarity table with only one column listed as the primary key will always hold no-add, single-response data.

True or False: A Clarity table with only one column listed as the primary key will always hold no-add, single-response data.

• A. True
• B. False; for example, a table with a CSN listed as the primary key would hold overtime, single-response data.
• C. False; it can extract no-add data sometimes.
• D. True; but only for no-add data.

Answer: (B)

The main idea here is that the way you design the primary key doesn’t by itself determine whether a table’s data are strictly no-add and single-response. If you use a single column as the primary key (for example, CSN), you still can model data in a way that includes a single value for certain fields per key, such as an overtime indicator or amount stored in that same row. That shows you can have data that are clearly single-response per key even with just one primary key column. Because of that, the blanket statement that such a table will always hold no-add, single-response data isn’t guaranteed to be true. The example with a CSN primary key illustrates that you can have overtime-related data present as a single response for each key, so the claim is not universally valid.

The main idea here is that the way you design the primary key doesn’t by itself determine whether a table’s data are strictly no-add and single-response. If you use a single column as the primary key (for example, CSN), you still can model data in a way that includes a single value for certain fields per key, such as an overtime indicator or amount stored in that same row. That shows you can have data that are clearly single-response per key even with just one primary key column. Because of that, the blanket statement that such a table will always hold no-add, single-response data isn’t guaranteed to be true. The example with a CSN primary key illustrates that you can have overtime-related data present as a single response for each key, so the claim is not universally valid.