nerdexam
EC-Council

312-50V10 · Question #722

An LDAP directory can be used to store information similar to a SQL database. LDAP uses a ____ database structure instead of SQL's ______ structure. Because of this, LDAP has difficulty representing m

The correct answer is D. Hierarchical, Relational. LDAP organizes directory entries in a tree-like hierarchical structure, while SQL databases use a relational (table-based) structure. LDAP's hierarchy makes it awkward to represent many-to-one or many-to-many relationships that relational databases handle naturally via joins.

Enumeration

Question

An LDAP directory can be used to store information similar to a SQL database. LDAP uses a ____ database structure instead of SQL's ______ structure. Because of this, LDAP has difficulty representing many-to-one relationships.

Options

  • AStrict, Abstract
  • BSimple, Complex
  • CRelational, Hierarchical
  • DHierarchical, Relational

How the community answered

(29 responses)
  • B
    7% (2)
  • C
    3% (1)
  • D
    90% (26)

Why each option

LDAP organizes directory entries in a tree-like hierarchical structure, while SQL databases use a relational (table-based) structure. LDAP's hierarchy makes it awkward to represent many-to-one or many-to-many relationships that relational databases handle naturally via joins.

AStrict, Abstract

Neither 'strict' nor 'abstract' are recognized terms for describing the structural models of LDAP or SQL databases.

BSimple, Complex

'Simple' and 'complex' do not describe the database models of LDAP and SQL and have no technical meaning in this context.

CRelational, Hierarchical

This reverses the correct mapping - LDAP is hierarchical, not relational, and SQL is relational, not hierarchical.

DHierarchical, RelationalCorrect

LDAP uses a hierarchical Directory Information Tree (DIT) where each entry has exactly one parent, making it well-suited for organizational structures but poorly suited for representing many-to-one relationships. SQL databases use a relational model with tables, rows, and foreign keys that naturally support complex relationships through joins. The fundamental structural difference is the reason LDAP and SQL serve complementary rather than interchangeable roles.

Concept tested: LDAP hierarchical vs SQL relational data structure

Source: https://learn.microsoft.com/en-us/previous-versions/windows/it-pro/windows-2000-server/cc961766(v=technet.10)

Topics

#LDAP#directory services#hierarchical database#SQL comparison

Community Discussion

No community discussion yet for this question.

Full 312-50V10 Practice