Module 4 Flashcards

1
Q

Data Management

A

tools for achieving consistent access to and delivery of data across the spectrum of data subject areas and data structure types in the enterprise.

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

Data

A

unorganized info

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

Information

A

processed, organized, and structured data

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

Data Governance

A

standards to govern business-critical data

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

Database Management System (DBMS)

A

An application software that is used to create a collection of related files that consist of records of data separated by fields that can be queired to produce populations of information.

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

Relational Databases

A

tables connected to tables

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q
  1. Structured Query Language (SQL)
A

data mining software program

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

Primary Key

A

A field in a database table that uniquely identifies a record in the table

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

Foreign Key

A

A field in a database table that provides a link between two tables in a relational database.

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

Schema

A

The organization or layout of a databse that defines the tables, fields, and constraints of the database.

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

Query

A

tool that lets you ask your data questions which leads to answers.

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

Big Data

A

large and expansive collected data sets

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

Data Mining

A

Examination of huge sets of data to find patterns and connections and identify outliers and hidden relationships.

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

Volume

A

Amount of data

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

Variety

A

Form of the data (Structured or Unstructured)

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

Veracity

A

Quality of the data

17
Q

Velocity

A

speed the data is created

18
Q

Structured Data

A

Fixed Formats - Table like data

19
Q

Unstructured Data

A

unorganized data that can not be easily read by a computer - Video, Audio, Satellite Imagery

20
Q

Semi-Structured Data

A

between structured and un - Email/ HTML

21
Q

Extract

A

remove or transfer

22
Q

Transform

A

create a structured database

23
Q

Load

A

transferred to data warehouse

24
Q

Hadoop

A

Infrastructure for storing and processing large sets of data across multiple servers

25
Q

Tableau

A

produces interactive data visualizations focused on business intelligence