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.
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)- B7% (2)
- C3% (1)
- D90% (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.
Neither 'strict' nor 'abstract' are recognized terms for describing the structural models of LDAP or SQL databases.
'Simple' and 'complex' do not describe the database models of LDAP and SQL and have no technical meaning in this context.
This reverses the correct mapping - LDAP is hierarchical, not relational, and SQL is relational, not hierarchical.
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
Community Discussion
No community discussion yet for this question.