Certified Data Management Professional – Fundamentals (CDMP) — Question 145

What is a super key?

Answer options

• A. A numeric, often system generated key uniquely identify an entity instance.
• B. An inverted architecture key, frequently used in high speed data retrieval systems
• C. Any set of attributes without duplicates that uniquely identify an entity instance.
• D. Any set of attributes that uniquely identify an entity instance.
• E. Any set of attributes where each component is a shortened identifier to provide meaning to the reader of a key

Correct answer: D

Explanation

A super key is defined as any set of attributes that can uniquely identify an entity instance, which aligns with option D. Options A and C describe specific types of keys or conditions that do not encompass the broader definition of a super key, while option B refers to a different concept in data retrieval, and option E discusses identifiers without capturing the essence of a super key.