Microsoft Azure Data FundamentalsDescribe core data conceptsEasy
A data analyst is designing a data storage solution for a small e-commerce business. The business needs to store semi-structured data, such as product catalogs with varying attributes and customer reviews, and requires high scalability and flexible schema. Which of the following data storage types is BEST suited for this requirement?
- ANoSQL Database
- BData Warehouse
- CRelational Database
- DFile System Storage
Show answer & explanationAnswer & explanation
Correct answer: A. NoSQL Database
NoSQL databases are designed to handle semi-structured data with flexible schemas, making them ideal for product catalogs with varying attributes and customer reviews, while also offering high scalability.
Why the other options are wrong
- B. Data warehouses are optimized for analytical queries on large volumes of structured data, not flexible schema storage.
- C. Relational databases are best for structured data with fixed schemas and strong consistency.
- D. File system storage lacks the query capabilities and schema flexibility required for managing complex semi-structured data.
NoSQL Database
NoSQL databases provide a mechanism for storage and retrieval of data that is modeled in means other than the tabular relations used in relational databases.
- Handles semi-structured and unstructured data.
- Offers flexible schemas.
- Provides high scalability and availability.
Memory trick: No-SQL is no problem for flexible data.