ITEC39_Q Flashcards

1
Q

collective information that gives you the ability to make effective, important, and strategic business decisions

A

Business intelligence ( BI )

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

the science of fact-based decision making

A

Analytics

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

OLTP stands for ?

A

Online transaction processing ( OLTP )

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

OLAP stands for?

A

Online analytical processing ( OLAP )

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

collection of information that you organize and access according to the logical structure of the information

A

Database

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

series of logically related two-dimensional tables or files for storing information

A

Relational Database

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

what is Most popular database model?

A

Relational database model

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

field (or group of fields) that uniquely describes each record

A

Primary Key

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

primary key of one file that appears in another file

A

Foreign Key

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

helps you specify the logical requirements for a database and access and use the information in a database

A

Database management system (DBMS

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

DBMS stands for?

A

Database management System

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

Help you build and work with BI and some forms of knowledge

A

Data warehouses and data mining

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

collection of information (from many places) that supports business analysis activities and decision making

A

Data warehouse

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

A data warehouse system has an engine responsible for converting your logical requests into their physical equivalent

A

DBMS

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

The analytics life cycle

A

Gather analytics needs
find the data
ETL
mine the data

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

Gather analytics needs

A
  • Interview users
  • Determine key performance
17
Q

Find the data

A
  • identify sources _ internally or externally
18
Q

subset of a data warehouse in which only a focused portion of the data warehouse information is kept

A

Data mart

19
Q

Information is a resource you must manage and organize to help the organization meet its goals and objectives

A

Information ownership

20
Q

DBMS engine / Data dictionary

A

Data Definition
Data Manipulation
Application Generation
Data Administrator

21
Q

Information ( 3 )

A

Product Database
Advertise Database
Customer Database

22
Q

Business intelligence

A

Data Warehouse