nerdexam
CompTIA

FC0-U61 · Question #627

The data set that is supporting an application utilizes commas to separate records. Which of the following describes the data set?

The correct answer is B. Flat file. A data set that uses commas to separate individual records is characteristic of a flat file, often referred to as a Comma Separated Values (CSV) file.

Database Fundamentals

Question

The data set that is supporting an application utilizes commas to separate records. Which of the following describes the data set?

Options

  • ARelational
  • BFlat file
  • CNoSQL
  • DSpreadsheet

How the community answered

(39 responses)
  • A
    3% (1)
  • B
    90% (35)
  • C
    5% (2)
  • D
    3% (1)

Why each option

A data set that uses commas to separate individual records is characteristic of a flat file, often referred to as a Comma Separated Values (CSV) file.

ARelational

Relational databases use structured tables with predefined schemas and relationships between tables, which is more complex than simple comma-separated records.

BFlat fileCorrect

A flat file is a simple database where all data is contained in a single table, with records typically separated by delimiters such as commas or tabs. This structure means there are no structural relationships between records, fitting the description of comma-separated data.

CNoSQL

NoSQL databases are non-relational and typically use flexible schemas like key-value pairs, documents, or graphs, which differs from a comma-separated record structure.

DSpreadsheet

A spreadsheet is an application for organizing and analyzing data in rows and columns, but the underlying data set itself, when stored as comma-separated values, is best described as a flat file.

Concept tested: Data set types- flat file definition

Source: https://en.wikipedia.org/wiki/Flat_file_database

Topics

#data formats#flat file#CSV#data sets

Community Discussion

No community discussion yet for this question.

Full FC0-U61 Practice