Microsoft Certified: Azure Solutions Architect ExpertDesign data storage solutionsEasy
A media company is building a content management system that will store metadata for millions of digital assets (images, videos, documents). Each asset can have a highly variable and evolving set of attributes (e.g., tags, categories, copyrights, resolution, codecs). The system requires fast lookups by various metadata fields and needs to accommodate frequent schema changes without downtime. Eventual consistency is acceptable. Which Azure non-relational data storage solution is most suitable?
- AAzure Database for PostgreSQL
- BAzure Blob Storage
- CAzure SQL Database
- DAzure Table Storage
Show answer & explanationAnswer & explanation
Correct answer: D. Azure Table Storage
Azure Table Storage is a NoSQL key-value store optimized for storing large amounts of structured, non-relational data. Its schemaless design allows for flexible and evolving attributes, making it ideal for metadata with variable properties. It offers high scalability and fast lookups at a low cost.
Why the other options are wrong
- A. Azure Database for PostgreSQL is a relational database, unsuitable for the flexible, evolving schema requirements of this metadata scenario.
- B. Azure Blob Storage is for storing the digital assets themselves (binary large objects), not for querying the metadata attributes efficiently.
- C. Azure SQL Database is a relational database and struggles with highly variable, evolving schemas and the scale required for millions of assets' flexible metadata.
Azure Table Storage
A NoSQL key-value store service that stores large amounts of structured, non-relational data. It's schemaless, allowing for flexible data models, and provides high scalability and low-cost storage.
- Schemaless design for flexible data models
- High scalability for massive datasets
- Low cost for structured non-relational data
- Supports fast lookups by partition key and row key
Memory trick: Table stores simple key-values, Blob stores big files.