BTM Exam UPDATED ACTUAL Exam
Questions and CORRECT Answers
problems with the file environment - CORRECT ANSWER - data redundancy and
inconsistency, program data dependence, lack of flexibility, poor security, lack of data sharing
and availability
database - CORRECT ANSWER - Collection of data organized to serve many applications by
centralizing data and controlling redundant data
DBMS - CORRECT ANSWER - software that permits an organization to centralize data,
manage it efficiently, and provide access to stored data by application programs.
database and DBMS solve what problems - CORRECT ANSWER - controls redundancy,
eliminates inconsistencies, uncouples programs and data, enables organizations to manage data
and data security
operations of a relational DBMS - CORRECT ANSWER - Select: Creates subset of rows that
meet specific criteria
Join: Combines relational tables to provide users with information
Project: Enables users to create new tables containing only relevant information
key techniques for large databases and systems - CORRECT ANSWER - -Data warehousing
-OLAP
-Data mining
data warehouse - CORRECT ANSWER - Stores current and historical data from many core
operational transaction systems and external sources
, Consolidates and standardizes information for use across enterprise, but data cannot be altered
Data warehouse system will provide query, analysis, and reporting tools
components of data warehouse - CORRECT ANSWER -
OLAP (online analytical processing) - CORRECT ANSWER - Supports multidimensional
data analysis
Viewing data using multiple dimensions
Each aspect of information (product, pricing, cost, region, time period) is different dimension
E.g., how many washers sold in East in June compared with other regions?
OLAP enables rapid, online answers to ad hoc queries
data mining - CORRECT ANSWER - Find hidden patterns and infer rules to predict trends
E.g., Finding patterns in customer data for one-to-one marketing campaigns or to identify
profitable customers.
Types of information obtainable from data mining
-Associations
-Sequences
-Classification
-Clustering
-Forecasting
Lack of security, control can lead to: - CORRECT ANSWER - -Loss of revenue
-Lowered market value
Questions and CORRECT Answers
problems with the file environment - CORRECT ANSWER - data redundancy and
inconsistency, program data dependence, lack of flexibility, poor security, lack of data sharing
and availability
database - CORRECT ANSWER - Collection of data organized to serve many applications by
centralizing data and controlling redundant data
DBMS - CORRECT ANSWER - software that permits an organization to centralize data,
manage it efficiently, and provide access to stored data by application programs.
database and DBMS solve what problems - CORRECT ANSWER - controls redundancy,
eliminates inconsistencies, uncouples programs and data, enables organizations to manage data
and data security
operations of a relational DBMS - CORRECT ANSWER - Select: Creates subset of rows that
meet specific criteria
Join: Combines relational tables to provide users with information
Project: Enables users to create new tables containing only relevant information
key techniques for large databases and systems - CORRECT ANSWER - -Data warehousing
-OLAP
-Data mining
data warehouse - CORRECT ANSWER - Stores current and historical data from many core
operational transaction systems and external sources
, Consolidates and standardizes information for use across enterprise, but data cannot be altered
Data warehouse system will provide query, analysis, and reporting tools
components of data warehouse - CORRECT ANSWER -
OLAP (online analytical processing) - CORRECT ANSWER - Supports multidimensional
data analysis
Viewing data using multiple dimensions
Each aspect of information (product, pricing, cost, region, time period) is different dimension
E.g., how many washers sold in East in June compared with other regions?
OLAP enables rapid, online answers to ad hoc queries
data mining - CORRECT ANSWER - Find hidden patterns and infer rules to predict trends
E.g., Finding patterns in customer data for one-to-one marketing campaigns or to identify
profitable customers.
Types of information obtainable from data mining
-Associations
-Sequences
-Classification
-Clustering
-Forecasting
Lack of security, control can lead to: - CORRECT ANSWER - -Loss of revenue
-Lowered market value
