Microsoft Certified: Azure Solutions Architect ExpertDesign data storage solutionsHard
A startup is developing a real-time analytics dashboard for monitoring social media trends. The application needs to store user posts, comments, and interactions, which are highly interconnected. Queries will frequently involve traversing relationships between users, posts, and comments to identify influencers and communities. The solution must provide high performance for these graph-based queries. Which Azure non-relational data storage solution is most suitable?
- AAzure Cosmos DB (Gremlin API)
- BAzure Redis Cache
- CAzure Blob Storage
- DAzure Table Storage
Show answer & explanationAnswer & explanation
Correct answer: A. Azure Cosmos DB (Gremlin API)
Azure Cosmos DB (Gremlin API) is a graph database solution that allows for efficient storage and querying of highly interconnected data. It is optimized for traversing relationships between entities like users, posts, and comments, making it ideal for identifying social media influencers and communities.
Why the other options are wrong
- B. Azure Redis Cache is an in-memory data store for caching, not a persistent database for storing and querying complex graph relationships.
- C. Azure Blob Storage is for unstructured object storage and does not provide database capabilities for managing relationships or performing queries.
- D. Azure Table Storage is a key-value store, not designed for complex, graph-based relationships and traversal queries.
Azure Cosmos DB (Gremlin API)
A graph database service within Azure Cosmos DB that enables you to store and query highly connected data using the Apache TinkerPop Gremlin graph traversal language.
- Optimized for relationships and connections
- Supports popular graph traversal algorithms
- Globally distributed and scalable
Memory trick: Cosmos DB Gremlin: 'G' for 'Graph' and 'G' for 'Gremlin' traversal.