ITEC39_Q

Question 1

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

Answer 1

Business intelligence ( BI )

Question 2

the science of fact-based decision making

Answer 2

Analytics

Question 3

OLTP stands for ?

Answer 3

Online transaction processing ( OLTP )

Question 4

OLAP stands for?

Answer 4

Online analytical processing ( OLAP )

Question 5

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

Answer 5

Database

Question 6

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

Answer 6

Relational Database

Question 7

what is Most popular database model?

Answer 7

Relational database model

Question 8

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

Answer 8

Primary Key

Question 9

primary key of one file that appears in another file

Answer 9

Foreign Key

Question 10

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

Answer 10

Database management system (DBMS

Question 11

DBMS stands for?

Answer 11

Database management System

Question 12

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

Answer 12

Data warehouses and data mining

Question 13

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

Answer 13

Data warehouse

Question 14

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

Answer 14

DBMS

Question 15

The analytics life cycle

Answer 15

Gather analytics needs
find the data
ETL
mine the data

Question 16

Gather analytics needs

Answer 16

• Interview users
• Determine key performance

Question 17

Find the data

Answer 17

• identify sources _ internally or externally

Question 18

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

Answer 18

Data mart

Question 19

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

Answer 19

Information ownership

Question 20

DBMS engine / Data dictionary

Answer 20

Data Definition
Data Manipulation
Application Generation
Data Administrator

Question 21

Information ( 3 )

Answer 21

Product Database
Advertise Database
Customer Database

Question 22

Business intelligence

Answer 22

Data Warehouse