Chapter 2 - Common File Formats Flashcards

Know the use cases for different file formats

1
Q

What file format is also known as a flat file?

A

Text File format

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Output of machine data uses what file format?

A

Text file format

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

What two types of semi-structured files use the text file format to store data?

A

Comma Separated Files and Tabular Separated Files

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

The content of a CSV or TSV is always structured, true or false?

A

False, it can be semi-structured and contain both structured and unstructured data

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

Which common file format was designed to be easily readable by humans and easily parsed by programming languages?

A

JavaScript Object Notation (JSON)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

Which common file formats were designed to add structure to a text files containing unstructured data? What’s the main difference between the two?

A

JSON and XML.
The main differences is that XML has a lot more overhead due to tags

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

Which file format allows documents to be displayed in a web browser?

A

HTML

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

JSON, XML, HTML, CSV and TSV are all file formats stored in what kind of file?

A

Text File

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

If you want to transfer simple structured data, what’s the best file format to use?

A

CSV/TSV

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

You have complex structured data you need to transmit between systems, which type of file format is best to transfer between machines?
JSON or XML

A

JSON

JSON is best remember as less overhead than XML

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

What is the preferred delimited file type extension for UTF-8?

A

.CSV

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

Which markup languiage lets you set customizable tags?

A

XML

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

“Pet ID”: 1,
This row format is from what data format?
Is is known as a what pair?

A

JSON
Key-value (or name-value) pair

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

What data type can store unstructured data but is itself composed of a structured data type?

A

Text

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

Considered the most basic type of unstructured data

A

Images

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

You need a database for web traffic that can handle large amounts of data. Which kind would you pick?

A

non-relational database