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.
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)- A3% (1)
- B90% (35)
- C5% (2)
- D3% (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.
Relational databases use structured tables with predefined schemas and relationships between tables, which is more complex than simple comma-separated records.
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.
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.
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
Community Discussion
No community discussion yet for this question.