Microsoft Azure Data Fundamentals DP-900 Practice Question

Graph databases model data as nodes and edges, making relationship traversal operations-such as finding all entities within a certain number of connections-fast and intuitive. Relational row-oriented databases store data in tables and require multiple joins for this scenario, which is inefficient at scale. Key-value stores are optimized for simple lookups by key, not complex relationship queries. Columnar analytical databases are tuned for aggregations over large datasets rather than path-finding across connected entities. Therefore, a graph database is the most appropriate choice.