312-50V11 · 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 data in a hierarchical tree structure called the Directory Information Tree (DIT), while SQL databases use a relational structure of tables with rows and columns. The hierarchical nature of LDAP makes many-to-one relationships difficult to model natively.
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
(28 responses)- A4% (1)
- B4% (1)
- D93% (26)
Why each option
LDAP organizes data in a hierarchical tree structure called the Directory Information Tree (DIT), while SQL databases use a relational structure of tables with rows and columns. The hierarchical nature of LDAP makes many-to-one relationships difficult to model natively.
'Strict' and 'Abstract' are not recognized technical terms describing either LDAP's or SQL's data structure models.
'Simple' and 'Complex' are not accurate or standard technical classifications for LDAP or SQL database structures.
This reverses the correct answer - LDAP uses a hierarchical structure and SQL uses a relational structure, not the other way around.
LDAP uses a hierarchical structure where entries are arranged as nodes in a tree (the Directory Information Tree), with each entry identified by a Distinguished Name (DN) reflecting its position in the hierarchy. SQL databases use a relational model with flat tables, foreign keys, and joins to represent complex relationships - which makes many-to-one relationships straightforward in SQL but cumbersome in LDAP's rigid tree layout.
Concept tested: LDAP hierarchical directory structure vs SQL relational model
Source: https://learn.microsoft.com/en-us/previous-versions/windows/desktop/ldap/the-ldap-model
Topics
Community Discussion
No community discussion yet for this question.