A company stores customer information in a table with columns CustomerID, Name, Address, and PhoneNumber. Every row has values for all these columns, and the data follows a fixed schema. Which type of data does this represent?
This option is correct because a table with defined columns and specified data types is the hallmark of structured data, which conforms to a fixed schema typical of relational database management systems. Each customer record will have the same set of attributes, and constraints enforce consistency, allowing efficient querying with SQL. Since the company stores customer information in such a normalized, column-based format, the data is structured.
Why this answer
Structured data conforms to a fixed schema where each row has the same columns and data types. The table with CustomerID, Name, Address, and PhoneNumber, where every row contains values for all columns, perfectly fits this definition. This is typical of relational database tables (e.g., in Azure SQL Database) where the schema is enforced at the table level.
Exam trap
The trap here is that candidates may confuse 'semi-structured' with 'structured' because both have some organization, but the key distinction is that structured data enforces a fixed schema for all rows, while semi-structured data allows schema flexibility (e.g., missing attributes or varying data types).
How to eliminate wrong answers
Option A is wrong because unstructured data has no predefined schema or organization (e.g., text files, images, videos), whereas the table has a fixed schema with defined columns. Option B is wrong because semi-structured data has some organizational properties (like tags or key-value pairs) but does not enforce a rigid schema across all records (e.g., JSON or XML files), unlike the fixed schema described. Option D is wrong because streaming data refers to data that is continuously generated and processed in real time (e.g., from IoT devices or event hubs), not to the static storage format of a table.