nerdexam
CompTIA

FC0-U61 · Question #463

Which of the following is the BEST example of structured data?

The correct answer is D. Customer information that can be sorted or grouped by any field. Structured data is characterized by its organization in a defined, fixed format, making it easy to sort, group, and analyze. Customer information with distinct fields that allow for various types of sorting and grouping is a prime example.

Database Fundamentals

Question

Which of the following is the BEST example of structured data?

Options

  • AEmployee beverage preferences organized in a single text field
  • BManager home addresses stored in a flat file without fields
  • CVendor order information stored in unnamed fields
  • DCustomer information that can be sorted or grouped by any field

How the community answered

(57 responses)
  • A
    2% (1)
  • B
    5% (3)
  • C
    4% (2)
  • D
    89% (51)

Why each option

Structured data is characterized by its organization in a defined, fixed format, making it easy to sort, group, and analyze. Customer information with distinct fields that allow for various types of sorting and grouping is a prime example.

AEmployee beverage preferences organized in a single text field

Organizing beverage preferences in a single text field makes the data difficult to query, sort, or analyze based on individual preferences, defining it as unstructured or semi-structured rather than fully structured.

BManager home addresses stored in a flat file without fields

Storing information in a flat file without distinct fields means the data lacks a defined structure for systematic organization and retrieval, making it unstructured.

CVendor order information stored in unnamed fields

Vendor order information stored in unnamed fields lacks a consistent, predefined schema that would allow for proper indexing, querying, and analysis, rendering it effectively unstructured for practical use.

DCustomer information that can be sorted or grouped by any fieldCorrect

Structured data is characterized by its organization in a fixed format, typically in rows and columns within a relational database, where each field has a defined purpose and data type. The ability to sort or group customer information by any field indicates that the data is well-defined into distinct categories (fields) and stored in a database or similar structure, which is the hallmark of structured data.

Concept tested: Characteristics of structured data

Source: https://learn.microsoft.com/en-us/azure/architecture/data-guide/relational-data/structured-data

Topics

#Structured data#Data types#Database concepts

Community Discussion

No community discussion yet for this question.

Full FC0-U61 Practice