Microsoft Azure Data FundamentalsDescribe core data conceptsHard
A data scientist is performing exploratory data analysis on a large dataset of customer reviews. The reviews are free-form text, and the scientist needs to quickly identify common sentiments, keywords, and topics without pre-defining a rigid schema. Which data representation approach would be MOST flexible for storing and querying this type of data?
- ARelational
- BUnstructured
- CSemi-structured
- DStrictly Structured
Show answer & explanationAnswer & explanation
Correct answer: B. Unstructured
Unstructured data, such as free-form text reviews, provides the most flexibility as it does not enforce any predefined schema. This allows data scientists to apply various analytical techniques to extract insights without being constrained by data structure.
Why the other options are wrong
- A. Relational data is strictly structured, making it unsuitable for the scenario's flexibility requirements.
- C. Semi-structured data has some organizational properties (like JSON), but free-form text is typically considered unstructured, offering even more flexibility.
- D. Strictly structured data requires a predefined schema, which is not suitable for free-form text with varying content.
Unstructured Data
Data that does not have a predefined data model or is not organized in a pre-defined manner. It accounts for a large majority of data generated today.
- Cannot be stored in traditional relational databases without significant effort.
- Examples include text documents, emails, social media posts, audio, video files.
- Requires advanced analytics techniques (NLP, machine learning) to extract insights.
- Often stored in data lakes or NoSQL document databases.
Memory trick: Unstructured is like a wild, free-flowing river of information.