A retail company stores product inventory data in a fixed-schema table with columns for ProductID, ProductName, QuantityInStock, and ReorderLevel. How should this data be classified?
Correct - The data has a fixed schema organized in rows and columns, which is the definition of structured data.
Why this answer
This data is classified as structured data because it conforms to a fixed schema with clearly defined columns (ProductID, ProductName, QuantityInStock, ReorderLevel) and data types, stored in a relational table. Structured data is highly organized, easily queryable via SQL, and follows a rigid schema, which matches the description of the inventory table.
Exam trap
The trap here is that candidates may confuse structured data with semi-structured data because both involve some organization, but the key distinction is that structured data requires a rigid, predefined schema (like a fixed-schema table), while semi-structured data allows schema flexibility (e.g., JSON with optional fields).
How to eliminate wrong answers
Option B is wrong because semi-structured data (e.g., JSON, XML, or CSV with flexible schemas) does not enforce a fixed schema or strict column definitions, whereas this table has a predefined schema. Option C is wrong because unstructured data (e.g., text files, images, or videos) lacks any predefined data model or organization, unlike the tabular inventory data. Option D is wrong because streaming data refers to continuous, real-time data flows (e.g., IoT sensor data or clickstreams), not static data stored in a table.