Data Management Tools

Question 1

Well-thought-out collections of computer files, the most important of which are called tables.

Answer 1

Databases

Question 2

Consist ofrecords(rows) separated byfields(columns) that can be queried (questioned) to produce subsets of information.

Answer 2

Tables

Question 3

Software systems used to create databases.

Answer 3

Database Management Systems (DBMS)

Question 4

• Volume
• Variety
• Veracity
• Velocity

Answer 4

4 Attributes That Define Big Data (4 Vs)

Question 5

Akin to the “trustworthiness” of the data.

Answer 5

Veracity

Question 6

How many data are presented that need to be stored or processed over a given time period.

Answer 6

Velocity

Question 7

Sometimes calleddata discoveryis the examination of huge sets of data to find patterns and connections and identify outliers and hidden relationships.

Answer 7

Data mining

Question 8

Are tools that are used to standardize data across systems and allow the data to be queried.

Answer 8

ETL is an acronym forextract, transform, and load

Question 9

Evolved as an infrastructure for storing and processing large sets of data across multiple servers. Instead of centralized files in one place like a data warehouse or datamart, it uses a distributed file system that allows files to be stored on multiple servers.

Answer 9

Hadoop

Question 10

The most widely used standard computer language for relational databases, as it allows a programmer to manipulate and query data.

Answer 10

Structured Query Language (SQL)

Question 11

Produces interactive data visualization products focused on business intelligence.

Answer 11

Tableau