MGSC 300 - Chapter 3 Exam Questions With
Complete Answers
Which of the following data management technologies store data that are generated by
business apps and operations? - ANSWER Databases
________ tools and techniques process data and do statistical analysis for insight and
discovery. - ANSWER Business intelligence
Ad-hoc requests for specific data from a database or warehouse are called ___________. -
ANSWER Queries
After data are extracted from a database and processed to standardize their format, they
are then loaded into a ________ and ready for analysis. - ANSWER Data warehouse
Users typically access data as needed from a database management system by using
________. - ANSWER SQL
Data in a ________ are volatile because record transactions. - ANSWER Database
Organizations that cannot afford the cost of a data warehouse, but want the benefits of
online analytic processing invest in___________. - ANSWER data marts
, Data warehouses and data marts are optimized for all of the following except: - ANSWER
Transaction processing
An accurate and consistent view of data throughout the enterprise is needed so one can
make informed, actionable decisions that support the business strategy. A function
performed by a DBMS to integrate, match, or link data from disparate sources is data
_____________. - ANSWER synchronization
NoSQL systems have increased in popularity because of the growing need for ________,
which means the system can increase in size to handle data growth. - ANSWER scalability
Which of the following is not a consequence of poor quality or dirty data? - ANSWER
The company faces data ownership problems
The primary benefits of centralized database configuration are better ___________ and
____________. - ANSWER Quality / Security
The primary disadvantage of centralized database systems is ________. - ANSWER
Transmission delay when users are geo-dispersed
Distributed databases use ___________ architecture to process information requests. -
ANSWER Client/server
In terms of the major functions performed by a DBMS, "data filtering and profiling"
refers to which of the following? - ANSWER Inspecting the data for errors,
Complete Answers
Which of the following data management technologies store data that are generated by
business apps and operations? - ANSWER Databases
________ tools and techniques process data and do statistical analysis for insight and
discovery. - ANSWER Business intelligence
Ad-hoc requests for specific data from a database or warehouse are called ___________. -
ANSWER Queries
After data are extracted from a database and processed to standardize their format, they
are then loaded into a ________ and ready for analysis. - ANSWER Data warehouse
Users typically access data as needed from a database management system by using
________. - ANSWER SQL
Data in a ________ are volatile because record transactions. - ANSWER Database
Organizations that cannot afford the cost of a data warehouse, but want the benefits of
online analytic processing invest in___________. - ANSWER data marts
, Data warehouses and data marts are optimized for all of the following except: - ANSWER
Transaction processing
An accurate and consistent view of data throughout the enterprise is needed so one can
make informed, actionable decisions that support the business strategy. A function
performed by a DBMS to integrate, match, or link data from disparate sources is data
_____________. - ANSWER synchronization
NoSQL systems have increased in popularity because of the growing need for ________,
which means the system can increase in size to handle data growth. - ANSWER scalability
Which of the following is not a consequence of poor quality or dirty data? - ANSWER
The company faces data ownership problems
The primary benefits of centralized database configuration are better ___________ and
____________. - ANSWER Quality / Security
The primary disadvantage of centralized database systems is ________. - ANSWER
Transmission delay when users are geo-dispersed
Distributed databases use ___________ architecture to process information requests. -
ANSWER Client/server
In terms of the major functions performed by a DBMS, "data filtering and profiling"
refers to which of the following? - ANSWER Inspecting the data for errors,
