Chapter 6

If your data needs exceed traditional RDBMSs and requires​ NoSQL, _______________ is considered a popular option. A. Oracle B. MySQL C. DB2 D. SQL Server E. Hadoop

E. Hadoop

The purpose of​ a(n) ________ is to store and distribute valuable data from an​ organization's internal information systems and external sources for analysis and querying. A. operational system B. data dictionary C. transaction processing system D. master file E. data warehouse

E. data warehouse

Using a decision support system to determine market share is​ a(n) ____________ function. A. human resources B. finance C. accounting D. production E. marketing

E. marketing

​________________ algorithms search for hidden patterns in large volumes of data in order to develop predictive models. A. Data mining B. OLAP C. RDBMS D. OLTP E. E-commerce

A. Data mining

​_______ typically​ provide(s) push​ reporting, exception​ reporting, and pull reporting. A. Digital dashboards B. OLAP C. Web crawlers D. Intelligent agents E. Neural networks

A. Digital dashboards

The type of data mining that is used to identify items that are frequently purchased together is called​ _________________ discovery. A. association B. intersection C. sequence D. predictive E. class

A. association

To stay ahead of the​ competition, organizations have turned to​ _____________, using information systems to gather and analyze data and information from internal and external sources in order to make better business decisions. A. business intelligence B. Web sites C. business applications D. transaction processing E. e-commerce

A. business intelligence

A​ ______ is a software application with which you​ create, store,​ organize, and retrieve data from a single database or several databases. A. database management system B. network C. application program D. file E. transaction

A. database management system

​A(n) ______ is something you collect data about. A. entity B. column C. table D. row E. record

A. entity

​A(n) ______ system uses reasoning methods based on knowledge about a specific problem domain in order to provide advice. A. expert B. OLAP C. data mining D. decision support E. competitive intelligence

A. expert

A key consideration related to business intelligence​ (BI) is that it focuses on​ ___________ data to aid in decision making. A. past B. aligned C. predictive D. redundant E. future

A. past

Which of the following is a limitation of relational database management systems​ (RDBMS)? A. RDBMS allow for different data types. B. RDBMS are not easily scalable in response to demand variations. C. RDBMS data are stored in tables. D. RDBMS support business processes. E. RDBMS allows for inserting data.

B. RDBMS are not easily scalable in response to demand variations.

Which of the following is NOT a common purpose of a geographic information​ system? A. Locate target customers. B. Replicate an​ expert's judgment. C. Perform competitor analysis. D. Find optimal site locations. E. Identify optimal product mixes at specific locations.

B. Replicate an​ expert's judgment.

A key function of RDMBS is the​ ____________, which enables users to retrieve data from the database to answer questions. A. question B. query C. form D. table E. data dictionary

B. query

A(n) _____________ is also known as an entity instance. A. table B. record C. column D. attribute E. cell

B. record

A key challenge of knowledge management systems is to identify and manage​ ______ knowledge assets and make them available to organization members. A. textual B. tacit C. private D. explicit E. archival

B. tacit

A common feature of a decision support system​ (DSS) is to perform​ _______ to examine alternative problem solutions. A. association discovery B. what-if analysis C. correlation analysis D. Web content mining E. competitive intelligence

B. what-if analysis

The​ ________ database management system is capable of handling large volumes of unstructured data. A. file-based B. client-based C. NoSQL D. RDBMS E. MySQL

C. NoSQL

Which of the following is NOT a key purpose of business​ analytics? A. Understand the data. B. Predict business outcomes. C. Provide a detailed picture of the current state of a business. D. Identify trends. E. Build explanatory models.

C. Provide a detailed picture of the current state of a business.

The purpose of an OLAP cube is​ to: A. allow data to be analyzed on a single dimension. B. analyze an​ expert's judgment. C. allow data to be analyzed by multiple dimensions. D. facilitate​ e-commerce. E. record a sales transaction.

C. allow data to be analyzed by multiple dimensions.

Today, organizations require​ a(n) _________ in order to monitor and analyze data and business​ processes, adjust business​ processes, and update organizational plans. A. random planning cycle B. separate company C. continuous planning process D. budget plan E. annual strategic plan

C. continuous planning process

Which of the following statements about data marts is NOT​ true? A. Data marts can be implemented on simpler and less expensive hardware compared to data warehouses. B. A data mart is a​ smaller-scope data warehouse. C. Data marts are often found in small and​ medium-sized businesses. D. Data marts are considerably more expensive to develop than data warehouses. E. Data marts can be targeted to a specific group of end users.

D. Data marts are considerably more expensive to develop than data warehouses.

The purpose of online analytical processing​ (OLAP) is to​ provide: A. simple data summaries. B. expert decision making. C. predictive forecasts. D. complex multidimensional data analyses. E. rapid posting of transaction data.

D. complex multidimensional data analyses.

An example of a type of unstructured data​ is: A. clickstream data from a website. B. transaction data. C. sensor readings. D. customer comments posted on a social media site. E. spreadsheets.

D. customer comments posted on a social media site.

The purpose of a key indicator report is​ to: A. provide answers to unplanned questions. B. highlight situations that fall outside the expected normal range of values. C. provide a summary of critical information on a regular schedule. D. provide routine information at predefined intervals. E. provide access to greater levels of detail.

normal range of values. C. provide a summary of critical information on a regular schedule.