Practice Test GeeksDMC - Data Modeling Certification Practice Test
← All DMC Flashcard Decks

Data Modeling Fundamentals Flashcards

6 cards from real DMC practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.

Read the first 6 Data Modeling Fundamentals flashcards as text

  1. What is a surrogate key?

    Answer: A system-generated identifier with no business meaning

    A surrogate key is a system-generated, meaningless identifier — typically an integer sequence — used solely to uniquely identify a row.

  2. Which of the following is a characteristic of a natural key?

    Answer: It derives its value from business attributes that already exist

    A natural key is derived from existing business data — such as a Social Security number or product barcode — that already has meaning in the real world.

  3. What is the key difference between a strong entity and a weak entity?

    Answer: A weak entity cannot be uniquely identified without referencing its parent entity

    A weak entity depends on a parent (owner) entity for its identification and cannot be uniquely identified by its own attributes alone.

  4. What does the term 'optionality' refer to in a data model?

    Answer: Whether a relationship participation is mandatory or optional

    Optionality describes whether an entity's participation in a relationship is mandatory (must exist) or optional (may or may not exist).

  5. Which modeling artifact is used to document the meaning and origin of a single data element across an enterprise?

    Answer: Data element definition record

    A data element definition record captures the business name, definition, data type, source, and steward of a single atomic piece of data.

  6. In the context of DMC, what does 'domain' mean when applied to an attribute?

    Answer: The set of all valid values an attribute can hold

    A domain is the complete set of allowable values for an attribute, defined by data type, length, format, and business constraints.

How this page was made: written with AI tools and published by Nathan Beja, founder of Practice Test Geeks, who is responsible for its content. Exam facts are checked against the official sources listed below. Not reviewed by a subject-matter expert. Editorial policy

Sources & references

Exam facts on this page (fees, format, dates, passing scores) are checked against these official sources; the date is our last check. Editorial policy

  1. technicspub.com — Test delivery, eligibility, fees, exam format, passing score, retake policy, score release, time limit, exam information · verified Oct 2026