A data model that is used by implementation subject matter experts to address concerns such as performance, concurrency, and security, is:

Question

Options

• Aa conceptual data model.
• Ba logical data model.
• Can enterprise data model.
• Da physical data model.

• A
  3% (1)
• B
  5% (2)
• C
  3% (1)
• D
  89% (33)

Explanation

Option D is correct because a physical data model is the implementation-level model where technical experts address how data is actually stored and managed - covering performance tuning, indexing strategies, concurrency controls, partitioning, and security constraints specific to a target database platform.

Why the distractors are wrong:

• A (Conceptual): Focuses on high-level business entities and relationships without any technical detail - it's for stakeholders, not implementers.
• B (Logical): Adds structure (attributes, keys, normalization) but remains platform-independent and doesn't address implementation concerns.
• C (Enterprise): Spans the entire organization's data landscape at a high level - a governance/strategic tool, not an implementation one.

Memory tip: Think of the three models as What → How → Now: Conceptual = what the business needs, Logical = how data relates, Physical = now let's build it (performance, security, the real stuff).

No community discussion yet for this question.