Data Business Intelligence Chapter 6 Exam Questions - M Information Systems 5th Edition | Test Bank with Answer Key by Paige Baltzan by Paige Baltzan. DOCX document preview.
M: Information Systems, 5e (Baltzan)
Chapter 6 Data: Business Intelligence
1) Information granularity refers to the extent of detail within the information (fine and detailed or coarse and abstract).
2) Information quality refers to the extent of detail within the information (fine and detailed or coarse and abstract).
3) Organizational information has three characteristics including levels, formats, and granularities.
4) The four primary traits of the value of information include type, timeliness, quality, and governance.
5) Organizational information has three characteristics including timeliness, quality, and governance.
6) The four primary traits of the value of information include levels, formats, granularities, and type.
7) There are only two main primary traits that help you determine the value of information including timeliness and quality.
8) If a manager identifies numerous information integrity issues he should consider the reports generated from that data as invalid and not use them when making decisions.
9) Real-time information refers to the extent of detail within the information (fine and detailed or coarse and abstract).
10) Information granularity means immediate, up-to-date information.
11) Real-time systems provide real-time information in response to requests.
12) Information integrity issues occur when the same data element has different values.
13) Information integrity issues occur when a system produces incorrect, inconsistent, or duplicate data.
14) Data governance refers to the overall management of the availability, usability, integrity, and security of company data.
15) Transactional information is used when performing operational tasks and repetitive decisions such as analyzing daily sales reports and production schedules to determine how much inventory to carry.
16) Timely information must be up-to-the-second to be accurate.
17) Organizational information comes at the same levels, formats, and granularities.
18) Reports for each sales person, product, and part are examples of detail or fine information granularities.
19) Master data management (MDM) is the practice of gathering data and ensuring that it is uniform, accurate, consistent, and complete, including such entities as customers, suppliers, products, sales, employees, and other critical entities that are commonly integrated across organizational systems. MDM is commonly included in data governance.
20) Data governance is the practice of gathering data and ensuring that it is uniform, accurate, consistent, and complete, including such entities as customers, suppliers, products, sales, employees, and other critical entities that are commonly integrated across organizational systems.
21) Accurate information asks if there is an incorrect value in the information.
22) Complete information asks if there is a value missing from the information.
23) Consistent information asks if the aggregate or summary information is in agreement with detailed information.
24) Timely information asks if the information is current with respect to the business needs.
25) Unique information asks if each transaction and event is represented only once in the information.
26) Complete information asks if there is an incorrect value in the information.
27) Consistent information asks if there is a value missing from the information.
28) Accurate information asks if the aggregate or summary information is in agreement with detailed information.
29) Unique information asks if the information is current with respect to the business needs.
30) Timely information asks if each transaction and event is represented only once in the information.
31) Determining if there are any duplicate customers in the data is an example of a unique characteristic of high-quality information.
32) Determining if all total columns equal the true total of the individual item is an example of a consistent characteristic of high-quality information.
33) A data steward is responsible for ensuring the policies and procedures are implemented across the organization and acts as a liaison between the MIS department and the business.
34) Data stewardship is the management and oversight of an organization's data assets to help provide business users with high-quality data that is easily accessible in a consistent manner.
35) Data latency includes the tests and evaluations used to determine compliance with data governance polices to ensure correctness of data.
36) Data validation includes the tests and evaluations used to determine compliance with data governance polices to ensure correctness of data.
37) Data validation helps to ensure that every data value is correct and accurate. In Microsoft Word, you can use data validation to control the type of data or the values that users enter into a cell.
38) Identity management is the practice of gathering data and ensuring that it is uniform, accurate, consistent, and complete, including such entities as customers, suppliers, products, sales, employees, and other critical entities that are commonly integrated across organizational systems.
39) A data gap analysis occurs when a company examines its data to determine if it can meet business expectations, while identifying possible data gaps or where missing data might exist.
40) Determining if a name is spelled correctly is an example of an accurate characteristic of high-quality information.
41) Determining if information is updated weekly, daily, or hourly is an example of an accurate characteristic of high-quality information.
42) A foreign key is a field (or group of fields) that uniquely identifies a given entity in a table.
43) The core component of any system, regardless of size, is a database and a database management system.
44) MMSDB creates, reads, updates, and deletes data in a database while controlling access and security.
45) A foreign key provides details about data.
46) There are three primary data models for organizing information including the hierarchical, network, and relational database models.
47) Data element (or data field) is the smallest or basic unit of information.
48) Data elements can include a customer's name, address, email, discount rate, preferred shipping method, product name, quantity ordered, and so on.
49) Data models are logical data structures that detail the relationships among data elements by using graphics or pictures.
50) Metadata provides details about data. For example, metadata for an image could include its size, resolution, and date created.
51) Data dictionary compiles all of the metadata about the data elements in the data model.
52) Relational database model stores information in the form of logically related two-dimensional tables.
53) A relational database management system allows users to create, read, update, and delete data in a relational database.
54) Attributes (also called columns or fields) are the data elements associated with an entity.
55) A record is a collection of related data elements.
56) A primary key is a field (or group of fields) that uniquely identifies a given record in a table.
57) A foreign key is a primary key of one table that appears as an attribute in another table and acts to provide a logical relationship between the two tables.
58) A primary key is the smallest or basic unit of information.
59) Data models can include a customer's name, address, email, discount rate, preferred shipping method, product name, quantity ordered, and so on.
60) Metadata are logical data structures that detail the relationships among data elements by using graphics or pictures.
61) A DBMS provides details about data.
62) Structured query language compiles all of the metadata about the data elements in the data model.
63) A hierarchal database model stores information in the form of logically related two-dimensional tables.
64) Entities are the data elements associated with an attribute.
65) A field is a collection of related data elements
66) A foreign key uniquely identifies a given record in a table.
67) A primary key is a foreign key of one table that appears as an attribute in another table and acts to provide a logical relationship between the two tables.
68) Databases offer many security features including passwords to provide authentication, access levels to determine who can access the data, and access controls to determine what type of access they have to the information.
69) Information redundancy is the duplication of data, or the storage of the same data in multiple places.
70) Relational databases offer many advantages over using a text document or a spreadsheet, which include decreased flexibility and decreased scalability and performance.
71) The physical view of information deals with the physical storage of information on a storage device.
72) The logical view of information focuses on how individual users logically access information to meet their own particular business needs.
73) The logical view of information deals with the physical storage of information on a storage device.
74) The physical view of information focuses on how individual users logically access information to meet their own particular business needs.
75) A business rule defines how a company performs certain aspects of its business and typically results in either a yes/no or true/false answer.
76) A business catalog defines how a company performs certain aspects of its business and typically results in either a yes/no or true/false answer.
77) Information redundancy is the duplication of data, or the storage of the same data in multiple places.
78) Information integrity is a measure of the quality of information.
79) Integrity constraints are rules that help ensure the quality of information.
80) Relational integrity constraints are rules that enforce basic and fundamental information-based constraints.
81) Information constraints are a measure of the quality of information.
82) Information integrity are rules that help ensure the quality of information.
83) Relationship integrity criteria are rules that enforce basic and fundamental information-based constraints.
84) Master data management is a broad administrative area that deals with identifying individuals in a system (such as a country, a network, or an enterprise) and controlling their access to resources within that system by associating user rights and restrictions with the established identity.
85) Data latency is the time it takes for data to be stored or retrieved.
86) Relational integrity constraints enforce business rules vital to an organization's success and often require more insight and knowledge than relational integrity constraints.
87) Business critical integrity constraints enforce business rules vital to an organization's success and often require more insight and knowledge than relational integrity constraints.
88) One of the advantages found in a relational database is increased information redundancy.
89) Relational integrity constraints are rules that enforce basic and fundamental information-based constraints.
90) A data-driven website can help limit the amount of information displayed to customers based on unique search requirements.
91) Data-driven websites offer several advantages as it is far easier to manage content and store large amounts of data.
92) A content creator is the person responsible for creating the original website content.
93) A content creator is the person responsible for updating and maintaining website content.
94) A content editor is the person responsible for updating and maintaining website content.
95) Static information includes fixed data incapable of change in the event of a user action.
96) Static information includes data that changes based on user actions.
97) Dynamic information includes data that change based on user actions.
98) Dynamic website information is stored in a dynamic catalog, or an area of a website that stores information about products in a database.
99) A data-driven website is an interactive website kept constantly updated and relevant to the needs of its customers using a database.
100) What is it called when a manager has so much data and information that they cannot make a decision?
A) data rich, information poor
B) data rich, content poor
C) data rich, communication poor
D) data rich, intelligence
101) Which of the below questions can be answered using business intelligence?
A) Where has the business been?
B) Where is the business now?
C) Where is the business going?
D) All of these.
102) What is information that people use to support their decision-making efforts?
A) information cleansing and scrubbing
B) data-mining tools
C) data mining
D) business intelligence
103) How would the airline industry use business intelligence?
A) Analyze popular vacation locations with current flight listings.
B) Understand customer credit card usage and nonpayment rates.
C) Compare the demographics of patients with critical illnesses.
D) Predict claim amounts and medical coverage costs.
104) How would the banking industry use business intelligence?
A) Analyze popular vacation locations with current flight listings.
B) Understand customer credit card usage and nonpayment rates.
C) Compare the demographics of patients with critical illnesses.
D) Predict claim amounts and medical coverage costs.
105) How would the health care industry use business intelligence?
A) Analyze popular vacation locations with current flight listings.
B) Understand customer credit card usage and nonpayment rates.
C) Compare the demographics of patients with critical illnesses.
D) Predict claim amounts and medical coverage costs.
106) How would the insurance industry use business intelligence?
A) Analyze popular vacation locations with current flight listings.
B) Understand customer credit card usage and nonpayment rates.
C) Compare the demographics of patients with critical illnesses.
D) Predict claim amounts and medical coverage costs.
107) How would the law enforcement industry use business intelligence?
A) Track crime patterns, locations, and criminal behavior.
B) Analyze customer demographics.
C) Predict sales, inventory levels, and distribution.
D) Predict hardware failures.
108) How would the marketing industry use business intelligence?
A) Track crime patterns, locations, and criminal behavior.
B) Analyze customer demographics.
C) Predict sales, inventory levels, and distribution.
D) Predict hardware failures.
109) How would the retail industry use business intelligence?
A) Track crime patterns, locations, and criminal behavior.
B) Analyze customer demographics.
C) Predict sales, inventory levels, and distribution.
D) Predict hardware failures.
110) How would the technology industry use business intelligence?
A) Track crime patterns, locations, and criminal behavior.
B) Analyze customer demographics.
C) Predict sales, inventory levels, and distribution.
D) Predict hardware failures.
111) A data warehouse is a ________ collection of information, gathered from many different ________ databases, that supports business analysis activities and decision-making tasks.
A) logical; operational
B) physical; operational
C) logical; transactional
D) physical; transactional
112) Which of the following is incorrect in terms of data warehousing and business intelligence?
A) Does not include information from other operational applications
B) Operational systems are integrated
C) Operational information is mainly current
D) Operational information frequently has quality issues
113) What do data warehouses support?
A) OLAP
B) analytical processing
C) OLTP
D) OLAP and analytical processing
114) The primary purpose of a data warehouse is to
A) combine strategic information.
B) organize departments.
C) interface between the computer and employees.
D) all of these.
115) Gender can be referred to in many ways (Male, Female, M/F, 1/0) in a data warehouse. Ensuring gender is referenced the same way is an example of
A) information scaling.
B) streamlining data points.
C) standardizing information.
D) standardizing protocols.
116) Why were data warehouses created?
A) Numbers and types of operational databases increased as businesses grew.
B) Many companies had information scattered across multiple systems with different formats.
C) Completing reporting requests from numerous operational systems took days or weeks.
D) All of these.
117) What is extraction, transformation, and loading?
A) It is a process of entering data, tracking data, and loading it into a database.
B) It is a process that extracts information from internal and external databases, transforms it using a common set of enterprise definitions, and loads it into a data warehouse.
C) It is a process that is performed at the end of the data warehouse model prior to putting the information in a cube.
D) It is a process that is performed at the beginning of the data mining model.
118) Which of the following are examples of external databases in the data warehouse model?
A) marketing, sales, inventory, and billing
B) data mart 1, data mart 2, and data mart 3
C) competitor and industry information, mailing lists, and stock market analysis
D) marketing information, sales information, and stock market analysis
119) Which of the following is an example of an external databases in the data warehouse model?
A) marketing information
B) sales information
C) competitor information
D) all of these
120) Which of the following describes ETL?
A) a process that extracts information from internal and external databases
B) a process that transforms information using a common set of enterprise definitions
C) a process that loads information into a data warehouse
D) all of these
121) Which of the following statements is true regarding customer information?
A) Customer information can exist in several operational systems.
B) Customer information in each operational system could change.
C) Customer information in each operational system can be different.
D) All of these.
122) Which of the following occurs during data cleansing?
A) Clean missing records.
B) Clean redundant records.
C) Clean inaccurate data.
D) All of these.
123) Which of the following occurs during data cleansing?
A) Clean data marts.
B) Clean redundant customer data.
C) Clean accurate data.
D) Clean correct data.
124) Which of the following statements is true?
A) The more complete an organization wants to get its information, the less it costs.
B) The more accurate an organization wants to get its information, the less it costs.
C) The less accurate an organization wants to get its information, the more it costs.
D) The more complete and accurate an organization wants to get its information, the more it costs.
125) Within the beginning stage of the data warehouse models process, which of the following are included in the internal databases?
A) marketing, sales, inventory, and billing
B) data mart 1, data mart 2, data mart 3
C) competitor and industry information, mailing lists, and stock market analysis
D) marketing information, and stock market analysis numbers
126) What is the ultimate outcome of a data warehouse?
A) data goals
B) data relationships
C) data marketing
D) data marts
127) Which of the following contains a subset of data warehouse information?
A) data miner
B) data mart
C) data pool
D) data analyzing tool
128) What is the primary difference between a data warehouse and a data mart?
A) Data warehouses make quick decisions, data marts make slow decisions.
B) Data warehouse tackle ethical issues, data marts tackle hypothetical issues.
C) Data warehouses have a more organization-wide focus, data marts have functional focus.
D) Data warehouses have a physical focus, data marts have logical focus.
129) Which of the following is the common term for the representation of multidimensional information?
A) block
B) square
C) column
D) cube
130) What is another term for information cleansing?
A) information mining
B) information scrubbing
C) information scrapping
D) information marts
131) What determines the accuracy and completeness of organizational data?
A) data quantity audit
B) data quality audit
C) data intelligence audit
D) data accuracy audit
132) Which of the following is not an information cleansing activity?
A) identifies redundant records
B) identifies inaccurate or incomplete data
C) identifies missing records or attributes
D) identifies sales trends
133) What is erroneous or flawed data?
A) dirty data
B) information cleansing
C) information scrubbing
D) ETL
134) Which of the following is a problem associated with dirty data?
A) duplicate data
B) incorrect data
C) violates business rules
D) all of these
135) Which of the following is a problem associated with dirty data?
A) duplicate data
B) correct data
C) accurate data
D) all of these
136) Which of the following is a problem associated with dirty data?
A) inaccurate data
B) misleading data
C) non-formatted data
D) all of these
137) Which of the following is a problem associated with dirty data?
A) inaccurate data
B) nonintegrated data
C) violates business rules
D) all of these
138) Which of the following is a problem associated with dirty data?
A) accurate data
B) integrated data
C) violates business rules
D) all of these
139) Which of the following is a problem associated with dirty data?
A) non-formatted data
B) misleading data
C) incorrect data
D) all of these
140) Which of the following is a problem associated with dirty data?
A) formatted data
B) misleading data
C) correct data
D) all of these
141) A central location in which data is stored and managed is called a data mart.
142) A repository is a central location in which data is stored and managed.
143) A data mart contains a subset of data warehouse information.
144) Data aggregation is the collection of data from various sources for the purpose of data processing.
145) One example of a data aggregation is to gather information about particular groups based on specific variables such as age, profession, or income.
146) The complete removal of dirty data from a source is practical and possible.
147) According to Gartner Inc., dirty data is an MIS problem, not a business problem.
148) Dirty data is erroneous or flawed data.
149) A repository is a central location in which data is stored and managed.
150) A data warehouse is a central location in which data is stored and managed.
151) A data warehouse is a logical collection of information, gathered from many different operational databases, that supports business analysis activities and decision-making tasks.
152) Data warehouses struggle with combining too much standardized information.
153) The primary purpose of a data warehouse is to perform transactional processes.
154) The primary purpose of a data warehouse is to perform analytical processes.
155) Within the data warehouse model, the internal databases could include marketing, sales, inventory, and billing.
156) A data miner contains a subset of data warehouse information.
157) A data mart contains a subset of data warehouse information.
158) ETL, within a data warehouse model, stands for exit, track, and load.
159) ETL stands for extraction, transformation, and loading.
160) Within the data warehouse model, the external databases could include competitor information, industry information, and stock market analysis.
161) Dirty data is erroneous or flawed data. The complete removal of dirty data from a source is impractical or virtually impossible.
162) Information cleansing or scrubbing is a process that weeds out and fixes or discards inconsistent, incorrect, or incomplete information.
163) Duplicate data, inaccurate data, misleading data, and incorrect data are all problems associated with dirty data.
164) Many firms complete data quality audits to determine the accuracy and completeness of its data.
165) A data mart is the process of analyzing data to extract information not offered by the raw data alone.
166) Information cleansing or scrubbing is a process that weeds out and fixes or discards inconsistent, incorrect, or incomplete information.
167) In a data warehouse, information cleansing occurs first during the ETL process and again once the information is in the data warehouse.
168) A comparative analysis can compare two or more data sets to identify patterns and trends.
169) Comparative analysis can help managers with competitive monitoring where a company keeps tabs of its competitor's activities on the web using software that automatically tracks all competitor website activities such as discounts and new products.
170) A data set is an organized collection of data.
171) The financial industry uses business intelligence to predict hardware failures.
172) The banking industry uses business intelligence to understand customer credit card usage and nonpayment rates.
173) Many organizations find themselves in the position of being data rich and information poor. Even in today's electronic world, managers struggle with the challenge of turning their business data into business intelligence.
174) Competitive monitoring can compare two or more data sets to identify patterns and trends.
175) A data broker is an individual item on a graph or a chart.
176) A data lake is a business that collects personal information about consumers and sells that information to other organizations.
177) A data lake is a storage repository that holds a vast amount of raw data in its original format until the business needs it.
178) While a traditional data warehouse stores data in files or folders, a data lake uses a flat architecture to store data.
179) Source data identifies the primary location where data is collected. It can include invoices, spreadsheets, time-sheets, transactions, and electronic sources such as other databases.
180) Business intelligence is an approach to business governance that values decisions that can be backed up with verifiable data.
181) Effective data-driven decision management is reliant upon the quality of the data gathered and the effectiveness of its analysis and interpretation.
182) A data map is a technique for establishing a match, or balance, between the source data and the target data warehouse.
183) A data point is an individual item on a graph or chart.
184) Organizational data includes simple structured data elements in a database.
185) A data set is an individual item on a graph or chart.
186) A data set is an organized collection of data.
187) Big data is a collection of large, complex data sets, including structured and unstructured data, which cannot be analyzed using traditional database methods and tools.
188) The four common characteristics of big data include variety, veracity, volume, velocity.
189) Variety includes different forms of structured and unstructured data.
190) Veracity includes the uncertainty of data, including biases, noise, and abnormalities.
191) Volume includes the scale of data.
192) Velocity includes the analysis of streaming data as it travels around the Internet.
193) Velocity includes different forms of structured and unstructured data.
194) Volume includes the uncertainty of data, including biases, noise, and abnormalities.
195) Distributed computing processes and manages algorithms across many machines in a computing environment.
196) Advanced analytics focuses on forecasting future trends and producing insights using sophisticated quantitative methods, including statistics, descriptive and predictive data mining, simulation, and optimization.
197) Distributed computing focuses on forecasting future trends and producing insights using sophisticated quantitative methods, including statistics, descriptive and predictive data mining, simulation, and optimization.
198) Association detection reveals the relationship between variables along with the nature and frequency of the relationship.
199) Association detection is a technique used to divide information sets into mutually exclusive groups such that the members of each group are as close together as possible to one another and the different groups are as far apart as possible.
200) Data mining occurs on structured data that are already in a database or a spreadsheet.
201) Prediction is a statement about what will happen or might happen in the future, for example, predicting future sales or employee turnover.
202) Optimization is a statistical process that finds the way to make a design, system, or decision as effective as possible, for example, finding the values of controllable variables that determine maximal productivity or minimal waste.
203) Time-series information is time-stamped information collected at a particular frequency.
204) Forecasts are predictions based on time-series information.
205) Regression is a statistical process for estimating the relationships among variables. It includes many techniques for modeling and analyzing several variables when the focus is on the relationship between a dependent variable and one or more independent variables
206) Regression is a statement about what will happen or might happen in the future, for example, predicting future sales or employee turnover.
207) Prediction is a statistical process that finds the way to make a design, system, or decision as effective as possible, for example, finding the values of controllable variables that determine maximal productivity or minimal waste.
208) Regression is a prediction based on time-series information.
209) Optimization is a statistical process for estimating the relationships among variables.
210) Classification assigns records to one of a predefined set of classes.
211) Estimation determines values for an unknown continuous variable behavior or estimated future value.
212) Affinity grouping determines which things go together.
213) Clustering segments a heterogeneous population of more homogeneous subgroups.
214) Clustering assigns records to one of a predefined set of classes.
215) Affinity determines values for an unknown continuous variable behavior or estimated future value.
216) Estimation determines which things go together.
217) Classification segments a heterogeneous population of more homogeneous subgroups.
218) Data-mining tools use a variety of techniques to find patterns and relationships in large volumes of information that predict future behavior and guide decision making.
219) Infographics (information graphics) displays information graphically so it can be easily understood.
220) Infographics can present the results of large data analysis looking for patterns and relationships that monitor changes in variables over time.
221) Web mining analysis describes technologies that allow users to "see" or visualize data to transform information into a business perspective.
222) Analysis paralysis occurs when the user goes into an emotional state of over-analysis (or over-thinking) a situation so that a decision or action is never taken, in effect paralyzing the outcome.
223) A data artist is a business analytics specialist who uses visual tools to help people understand complex data.
224) Advanced analytics processes and manages algorithms across many machines in a computing environment.
225) Association detection occurs when the user goes into an emotional state of over-analysis (or over-thinking) a situation so that a decision or action is never taken, in effect paralyzing the outcome.
226) A data miner is a business analytics specialist who uses visual tools to help people understand complex data.
227) Social media analytics analyzes text flowing across the Internet, including unstructured text from blogs and messages.
228) Speech analytics is the process of analyzing recorded calls to gather information, brings structure to customer interactions, and exposes information buried in customer contact center interactions with an enterprise.
229) Speech analytics is heavily used in the customer service department to help improve processes by identifying angry customers and routing them to the appropriate customer service representative.
230) Text analytics analyzes unstructured data to find trends and patterns in words and sentences. Text mining a firm's customer support email might identify which customer service representative is best able to handle the question, allowing the system to forward it to the right person.
231) Web analytics analyzes unstructured data associated with websites to identify consumer behavior and website navigation.
232) Web analytics analyzes unstructured data to find trends and patterns in words and sentences.
233) Social media analytics analyzes unstructured data associated with websites to identify consumer behavior and website navigation.
234) Data visualization tools move beyond Excel graphs and charts into sophisticated analysis techniques such as pie charts, controls, instruments, maps, time-series graphs, and more.
235) Data visualization tools can help uncover correlations and trends in data that would otherwise go unrecognized.
236) Employees need to compare different types of information for what they commonly reveal to make strategic decisions. Which of the below represents the three common types of information found throughout an organization?
A) levels, forms, granularities
B) levels, forms, data
C) levels, formats, granularities
D) data, formats, granularities
237) Which of the following represents the different information levels?
A) detail, summary, aggregate
B) document, presentation, spreadsheet, database
C) individual, department, enterprise
D) executives, managers, operational employees
238) Which of the following represents the different information formats?
A) detail, summary, aggregate
B) document, presentation, spreadsheet, database
C) individual, department, enterprise
D) executives, managers, operational employees
239) Which of the following represents the different information granularities?
A) detail, summary, aggregate
B) document, presentation, spreadsheet, database
C) individual, department, enterprise
D) executives, managers, operational employees
240) Which of the following is not a primary trait of information?
A) governance
B) type
C) timeliness
D) quantity
241) What encompasses all of the information contained within a single business process or unit of work and its primary purpose is to support the performing of daily operational tasks?
A) transactional information
B) analytical information
C) timeliness
D) quality
242) What encompasses all organizational information and its primary purpose is to support the performing of managerial analysis tasks?
A) transactional information
B) analytical information
C) timeliness
D) quality
243) What is immediate, up-to-date information?
A) real-time information
B) real-time systems
C) information granularity
D) information governance
244) What provides real-time information in response to query requests?
A) real-time information
B) real-time systems
C) information level
D) information quality
245) What is one of the biggest pitfalls associated with real-time information?
A) It is only available to high-level executives due to the expense.
B) It is only available in aggregate levels of granularity.
C) It continually changes.
D) It rarely changes.
246) Which of the following is not one of the five characteristics common to high-quality information?
A) accuracy
B) completeness
C) quantity
D) consistency
247) What is a real-time system?
A) provides immediate, up-to-date information
B) provides real-time information in response to query requests
C) encompasses all organization information, and its primary purpose is to support the performing of managerial analysis tasks
D) encompasses all of the information contained within a single business process or unit of work, and its primary purpose is to support the performing of daily operational tasks
248) Which of the following implies that aggregate or summary information is in agreement with detailed information?
A) uniqueness
B) completeness
C) consistency
D) accuracy
249) Which of the following implies that information is current with respect to the business requirement?
A) uniqueness
B) accuracy
C) consistency
D) timeliness
250) What is it called when each transaction, entity, and event is represented only once in the information?
A) uniqueness
B) accuracy
C) consistency
D) timeliness
251) Which of the following refers to the extent of detail within the information?
A) knowledge information
B) information granularity
C) chance information
D) information analytics
252) Which of the following represent the four primary traits that help determine the value of information?
A) information type, information timeliness, information quality, and information governance
B) information statistics, information tracking, information quality, and information governance
C) information type, information chance, information analytics, and information policy
D) information timeliness, information quality, information quantity, and information governance policy
253) What are the two different categories for information type?
A) analytical and productive
B) analytical and analysis
C) transactional and analytical
D) transactional and analysis
254) Which of the following encompasses all of the information contained within a single business process or unit of work, and its primary purpose is to support daily operational tasks?
A) targeted information
B) analytical information
C) productive information
D) transactional information
255) Which of the following encompasses all organizational information, and its primary purpose is to support the performing of managerial analysis tasks?
A) analytical information
B) transactional information
C) statistical information
D) targeted information
256) Ben works at a top accounting firm in Salt Lake City and his responsibilities include writing letters, memos, and emails along with generating reports for financial analysis and marketing materials for products. Ben's duties provide added value to his company and would be categorized as occurring at different
A) information lists
B) information formats
C) information granularities
D) information focus
257) Ben works at a top accounting firm in Salt Lake City and his responsibilities include developing individual and departmental goals, and generating financial analysis across departments and the enterprise as a whole for the executive team to review. Ben's duties provide added value to his company and would be categorized as occurring at different
A) information levels
B) information formulas
C) information granularities
D) information focus
258) Ben works at a top accounting firm in Salt Lake City and his responsibilities include developing reports for each salesperson, product, and part as well as departmental-wide sales reports by salesperson, product, and part. Ben's duties provide added value to his company and would be categorized as occurring at different
A) information levels
B) information formats
C) information granularities
D) information focus
259) Which of the following refers to immediate, up-to-date information?
A) daily information
B) strategic information
C) real-time information
D) crisis information
260) Which of the below does not represent a company that requires up-to-the-second information?
A) 911 response
B) stock traders
C) banks
D) construction companies
261) Which of the following provides real-time information in response to requests?
A) sales system
B) transactional system
C) real-time system
D) salary system
262) Which of the following are examples of transactional information?
A) airline ticket, sales receipts, and packing slips
B) trends and sales statistics
C) product sales results, grocery receipts, and growth projections
D) airline tickets and sales growth spreadsheets
263) Which of the following are examples of analytical information?
A) airline ticket, sales receipts, and packing slips
B) hotel reservation, sales receipts, and packing slips
C) future growth analysis, sales projections, and product statistics
D) packing slips, grocery receipt, and competitor information
264) Most people request real-time information without understanding that continual ________ is one of its biggest pitfalls.
A) improvements
B) change
C) clustering
D) cleansing
265) Which of the following occurs when the same data element has different values?
A) data modeling issue
B) data mining issue
C) data governance issue
D) information inconsistency issue
266) Which of the following occurs when a system produces incorrect, inconsistent, or duplicate data?
A) information inconsistency issue
B) information integrity issue
C) data control issue
D) data mining issue
267) Which of the following lists include all of the five characteristics common to high-quality information?
A) accuracy, completeness, strength, support, and positive feedback
B) accuracy, association, referral, sales, and marketing
C) accuracy, competition, support, customer service, and visibility
D) accuracy, completeness, consistency, timeliness, and uniqueness
268) Which of the following would not be considered part of the complete characteristic of high-quality information?
A) Is a value missing from the personal information?
B) Is each transaction represented only once in the information?
C) Is the address incomplete?
D) Is the area code missing for the phone information?
269) Which of the following would not be considered part of the timely characteristic of high-quality information?
A) Is the zip code missing in the address?
B) Is the information current with respect to business needs?
C) Is the customer address current?
D) Is the information updated weekly or hourly?
270) Which of the following would not be considered part of the accurate characteristic of high-quality information?
A) Is the name spelled correctly?
B) Is the email address invalid?
C) Do the name and the phone values have the exact same information?
D) Is aggregate information in agreement with detailed information?
271) Which of the following would not be considered part of the unique characteristic of high-quality information?
A) Are there any duplicate orders?
B) Are there any duplicate customers?
C) Is aggregate information in agreement with detailed information?
D) Is each transaction and event represented only once in the information?
272) Which of the following would not be considered part of the consistent characteristic of high-quality information?
A) Do all sales columns equal the total for the revenue column?
B) Is the two-digit state code missing in the information?
C) Is all summary information in agreement with detailed information?
D) Does the order number match the item and the color options available?
273) Which of the following represents a reason for low-quality information?
A) Online customers intentionally enter inaccurate information to protect their privacy.
B) Different systems have different information entry standards and formats.
C) Third-party and external information contains inaccuracies and errors.
D) All of these.
274) Some of the serious business consequences that occur due to using low-quality information to make decisions are all of the following except
A) inability to accurately track customers
B) inability to identify selling opportunities
C) the success of the organization depends on appreciating and leveraging the low-quality information
D) lost revenue opportunities from marketing to nonexistent customers
275) What is the overall management of the availability, usability, integrity, and security of company data?
A) data Intelligence
B) data governance
C) data forbearance
D) data forecasting
276) What occurs when the same data element has different values?
A) information inconsistency
B) information integrity issues
C) data governance
D) master data management
277) What occurs when a system produces incorrect, inconsistent, or duplicate data?
A) information inconsistency
B) information integrity issues
C) data governance
D) master data management
278) What refers to the overall management of the availability, usability, integrity, and security of company data?
A) information inconsistency
B) information integrity issues
C) data governance
D) master data management
279) What is the practice of gathering data and ensuring that it is uniform, accurate, consistent, and complete, including such entities as customers, suppliers, products, sales, employees, and other critical entities that are commonly integrated across organizational systems?
A) information inconsistency
B) information integrity issues
C) data governance
D) master data management
280) What is information inconsistency?
A) occurs when the same data element has different values
B) occurs when a system produces incorrect, inconsistent, or duplicate data
C) refers to the overall management of the availability, usability, integrity, and security of company data
D) the practice of gathering data and ensuring that it is uniform, accurate, consistent, and complete, including such entities as customers, suppliers, products, sales, employees, and other critical entities that are commonly integrated across organizational systems
281) What are information integrity issues?
A) occurs when the same data element has different values
B) occurs when a system produces incorrect, inconsistent, or duplicate data
C) refers to the overall management of the availability, usability, integrity, and security of company data
D) the practice of gathering data and ensuring that it is uniform, accurate, consistent, and complete, including such entities as customers, suppliers, products, sales, employees, and other critical entities that are commonly integrated across organizational systems
282) What is data governance?
A) occurs when the same data element has different values
B) occurs when a system produces incorrect, inconsistent, or duplicate data
C) refers to the overall management of the availability, usability, integrity, and security of company data
D) the practice of gathering data and ensuring that it is uniform, accurate, consistent, and complete, including such entities as customers, suppliers, products, sales, employees, and other critical entities that are commonly integrated across organizational systems
283) What is master data management?
A) occurs when the same data element has different values
B) occurs when a system produces incorrect, inconsistent, or duplicate data
C) refers to the overall management of the availability, usability, integrity, and security of company data
D) the practice of gathering data and ensuring that it is uniform, accurate, consistent, and complete, including such entities as customers, suppliers, products, sales, employees, and other critical entities that are commonly integrated across organizational systems
284) What is a data steward responsible for?
A) acting as a liaison between the MIS department and the business
B) ensuring policies and procedures are implemented across the organization
C) ensuring the policies and procedures are implemented across the organization and acts as a liaison between the MIS department and the business
D) none of these
285) What is the term for the management and oversight of an organization's data assets to help provide business users with high-quality data that is easily accessible in a consistent manner?
A) data steward
B) data stewardship
C) data gap analysis
D) data governance
286) What is the term for the tests and evaluations used to determine compliance with data governance policies to ensure correctness of data?
A) data steward
B) data stewardship
C) data validation
D) data gap analysis
287) What is the term for when a company examines its data to determine if it can meet business expectations, while identifying possible data gaps or where missing data might exist?
A) data steward
B) data stewardship
C) data validation
D) data gap analysis
288) What is the term for the practice of gathering data and ensuring that it is uniform, accurate, consistent, and complete, including such entities as customers, suppliers, products, sales, employees, and other critical entities that are commonly integrated across organizational systems?
A) data governance
B) master data management
C) data validation
D) data gap analysis
289) What is the term for the time it takes for data to be stored or retrieved?
A) data governance
B) data latency
C) data validation
D) data gap analysis
290) What is data latency?
A) the time it takes for data to be stored or retrieved
B) the management and oversight of an organization's data assets
C) the person responsible for ensuring policies and procedures are implemented across the organization
D) when a company examines its data to determine if it can meet business expectations, while identifying possible data gaps
291) What is data stewardship?
A) the time it takes for data to be stored or retrieved
B) the management and oversight of an organization's data assets
C) the person responsible for ensuring policies and procedures are implemented across the organization
D) when a company examines its data to determine if it can meet business expectations, while identifying possible data gaps
292) What is a data steward?
A) the time it takes for data to be stored or retrieved
B) the management and oversight of an organization's data assets
C) the person responsible for ensuring policies and procedures are implemented across the organization
D) when a company examines its data to determine if it can meet business expectations, while identifying possible data gaps
293) What is data validation?
A) the time it takes for data to be stored or retrieved
B) the management and oversight of an organization's data assets
C) the tests and evaluations used to determine compliance with data governance policies to ensure correctness of data
D) when a company examines its data to determine if it can meet business expectations, while identifying possible data gaps
294) What is data gap analysis?
A) the time it takes for data to be stored or retrieved
B) the management and oversight of an organization's data assets
C) the tests and evaluations used to determine compliance with data governance policies to ensure correctness of data
D) when a company examines its data to determine if it can meet business expectations, while identifying possible data gaps
295) What is master data management?
A) the time it takes for data to be stored or retrieved
B) the practice of gathering data and ensuring that it is uniform, accurate, consistent, and complete
C) the tests and evaluations used to determine compliance with data governance policies to ensure correctness of data
D) when a company examines its data to determine if it can meet business expectations, while identifying possible data gaps
296) What maintains information about various types of objects, events, people, and places?
A) database
B) data model
C) data mining
D) data intelligence
297) A database maintains information on
A) inventory
B) transactions
C) employees
D) all of these
298) In the relational database model, what is a person, place, thing, transaction, or event about which information is stored?
A) entity
B) relationships
C) attribute
D) foreign Key
299) Why do relational databases use primary keys and foreign keys?
A) to create an entity
B) to create physical relationships
C) to create logical relationships
D) to create an attribute
300) What is a primary key?
A) a field (or group of fields) that uniquely identifies a given entity in a table
B) a primary key of one table that appears as an attribute in another table and acts to provide a logical relationship among the two tables
C) characteristics or properties of an entity
D) a field (or group of fields) that uniquely identifies a given attribute in a table
301) What is a foreign key?
A) a field (or group of fields) that uniquely identifies a given entity in a table
B) a primary key of one table that appears as an attribute in another table and acts to provide a logical relationship among the two tables
C) characteristics or properties of an entity
D) a field (or group of fields) that uniquely identifies a given attribute in a table
302) Which of the following creates, reads, updates, and deletes data in a database while controlling access and security?
A) database element
B) database management system
C) data governance
D) data file
303) Which of the following asks users to write lines of code to answer questions against a database?
A) structured query language
B) relational query language
C) structured elements
D) data mining tools
304) What is the primary tool that retrieves information and helps users graphically design the answer to a question?
A) data mining tools
B) structured example language
C) query-by-example tool
D) relational query tool
305) What is the smallest or basic unit of information?
A) database management element
B) data element
C) data model
D) data integrity issue
306) What is a logical data structure that details the relationship among data elements using graphics or pictures?
A) data model
B) data element
C) data mining tool
D) data mart tool
307) What compiles all of the metadata about the data elements in the data model?
A) data entity
B) data element
C) data attribute
D) data dictionary
308) Which of the following systems allows users to create, read, update, and delete data in a relational database?
A) business intelligence system
B) informational database system
C) relational database management system
D) data mining system
309) Which of the following illustrates the primary concepts of the relational database model?
A) ethics, applications, keys, and relationships
B) entities, attributes, keys, and relationships
C) endeavor, aspire, control, and regulate
D) early, after, before, and future
310) Which of the following stores information about a person, place, thing, transaction, or event, and is usually referred to as a table?
A) entity
B) extraction
C) attribute
D) foreign key
311) What is the primary difference between an entity and an attribute?
A) An attribute is a table, an entity is a column from the attribute table.
B) An entity is specific, whereas an attribute is not data at all but brainstorming ideas that take place before the entity is created.
C) An attribute refers to applications, and an entity refers to executives.
D) An entity is a table that stores information about people, places, or events, whereas an attribute is a column or specific field of the data elements associated with an entity.
312) What types of keys do you need to use to create a relational database model?
A) primary keys and secondary keys
B) primary keys and foreign keys
C) entity keys and attribute keys
D) relational keys and DBMS keys
313) What is a field that uniquely identifies a given record in a table?
A) foreign key
B) primary key
C) data mining key
D) DBMS key
314) What is the role of a foreign key?
A) It is a primary key of one table that appears as an attribute in another table and acts to provide a logical relationship between the two tables.
B) It is a unique way to identify each record.
C) It is a field that uniquely identifies a give record in a table.
D) All of these.
315) Your textbook discussed a record store example where one user could perform a query to determine which recordings had a track length of four minutes or more, and another user could perform an analysis to determine the distribution of recordings as they relate to the different categories. This is an advantage of which database example?
A) increased scalability and performance
B) increased information security
C) reduced information redundancy
D) increased flexibility
316) Which of the following is a disadvantage of database-stored information?
A) increased flexibility
B) increased performance
C) increased information redundancy
D) increased information integrity
317) Which of the following is incorrect in reference to a database?
A) A database can be relational or network.
B) Database information is accessed by logical structure.
C) Database information is accessed by physical structure.
D) Database users can have different views of information.
318) What is the logical view of information?
A) deals with the physical storage of information on a storage device such as a hard disk
B) deals with the logical storage of information on a storage device such as a hard disk
C) focuses on how users logically access information to meet their particular business needs
D) focuses on how users physically access information to meet their particular business needs
319) Which of the following is correct in reference to a database?
A) A database can support only one logical view.
B) A database can support many physical views.
C) A database can support many logical views.
D) A database can support up to three logical views.
320) Which of the below is not an example of an advantage of using a relational database?
A) increased information quality
B) increased flexibility
C) decreased information redundancy
D) decreased information security
321) What is information redundancy?
A) duplication of data
B) storing the same data in multiple places
C) storing duplicate data in multiple places
D) all of these
322) What is the primary problem with redundant information?
A) It is difficult to determine which values are the most current.
B) It is often inconsistent.
C) It is difficult to determine which values are the most accurate.
D) All of these.
323) Which of the following is true in regard to the elimination of redundant information?
A) uses additional hard disk space
B) makes performing information updates harder
C) improves information quality
D) all of these
324) What are the rules that help ensure the quality of information?
A) information integrity
B) integrity constraints
C) relational integrity constraints
D) business-critical integrity constraints
325) What are rules that enforce basic and fundamental information-based constraints?
A) information integrity
B) integrity constraint
C) business-critical integrity constraint
D) relational integrity constraint
326) Which of the following is a valid type of integrity constraint?
A) relational-critical integrity constraint
B) business integrity constraint
C) relational integrity constraint
D) business-critical integrity constraint
327) What type of integrity constraint does not allow someone to create an order for a nonexistent customer?
A) relational integrity constraint
B) business-critical integrity constraint
C) information-critical integrity constraint
D) mission-critical integrity constraint
328) Which of the following is a business-critical integrity constraint?
A) The system will not allow an entry for an order for a nonexistent customer.
B) The system will not allow returns of fresh produce after 15 days past delivery.
C) The system will not allow shipping a product to a customer who does not have a valid address.
D) The system will not allow shipping of a nonexistent product to a customer.
329) What is identity management?
A) enforces business rules vital to an organization's success
B) the practice of gathering data and ensuring that it is uniform, accurate, consistent, and complete
C) a broad administrative area that deals with identifying individuals in a system and controlling their access to resources within that system
D) when a company examines its data to determine if it can meet business expectations, while identifying possible data gaps
330) What is the term for a broad administrative area that deals with identifying individuals in a system and controlling their access to resources within that system by associating user rights and restrictions with the established identity?
A) identity management
B) master data management
C) data validation
D) data latency
331) Which of the following focuses on how individual users logically access information to meet their own particular business needs?
A) physical view
B) logical view
C) data mart view
D) data view
332) The example the book gave of www.EllisIsland.org, which generates more than 2.5 billion hits, is a site that offers a database that can easily adjust to handle massive volumes of information. What is this an example of?
A) increased scalability and performance
B) increased information security
C) reduced information redundancy
D) increased flexibility
333) One of the primary goals of a database is to eliminate information redundancy by recording each piece of data in only one place in the database. What does the elimination of information redundancy do for a database?
A) reduces disk space requirements
B) makes updating information easier
C) improves information quality
D) all of these
334) What are rules that help ensure the quality of information?
A) information integrity
B) integrity constraints
C) information quality
D) information ethics
335) What are the rules that enforce basic and fundamental information-based constraints?
A) responsibly integrity constraints
B) quality constraints
C) web integrity constraints
D) relational integrity constraints
336) Which of the following will enforce business rules vital to an organization's success and often require more insight and knowledge than relational integrity constraints?
A) quality business constraints
B) critical web constraints
C) business-critical integrity constraints
D) web integrity constraints
337) What type of website is an interactive website kept constantly updated and relevant to the needs of its customers using a database?
A) data-driven website
B) interactive website
C) database performing website
D) data processing website
338) Which of the following offers an advantage of using a data-driven website?
A) easy to eliminate human errors
B) easy to manage content
C) easy to store large amounts of data
D) all of these
339) Which of the below statements means the same as easy to manage content?
A) Website owners can make changes only with the aid of MIS professionals.
B) The website cannot organize customer data.
C) Users can update data-driven websites with little or no training.
D) Users with extensive training can update data-driven websites.
340) Which of the following is not an example of an advantage to using the Web to access organizational databases?
A) Web browsers are much easier to use than a computer based database.
B) The Web interface requires few or no changes to the database model.
C) It is cleaner and virus-free.
D) It costs less.
341) Which of the below does not describe Zappos' database?
A) Zappos' database is highly scalable.
B) Zappos' database is highly flexible.
C) Zappos' database is highly secure.
D) Zappos' database is highly redundant.
342) Which of the following is not an advantage to a data-driven website?
A) development
B) minimizing human error
C) increasing update costs
D) more efficient
343) Who is the person responsible for creating the original website content?
A) content creator
B) content editor
C) static information
D) dynamic information
344) Who is the person responsible for updating and maintaining website content?
A) content creator
B) content editor
C) static information
D) dynamic information
345) What includes fixed data incapable of change in the event of a user action?
A) content creator
B) content editor
C) static information
D) dynamic information
346) What includes data that change based on user actions?
A) content creator
B) content editor
C) static information
D) dynamic information
347) What is stored in a dynamic catalog, or an area of a website that stores information about products in a database?
A) dynamic website information
B) data-driven website
C) static information
D) dynamic information
348) What is an interactive website kept constantly updated and relevant to the needs of its customers using a database?
A) dynamic website
B) data-driven website
C) static information
D) dynamic information
349) What is a content creator?
A) the person responsible for creating the original website content
B) the person responsible for updating and maintaining website content
C) includes fixed data incapable of change in the event of a user action
D) includes data that change based on user action
350) What is a content editor?
A) the person responsible for creating the original website content
B) the person responsible for updating and maintaining website content
C) includes fixed data incapable of change in the event of a user action
D) includes data that change based on user action
351) What is static information?
A) the person responsible for creating the original website content
B) the person responsible for updating and maintaining website content
C) includes fixed data incapable of change in the event of a user action
D) includes data that change based on user action
352) What is dynamic information?
A) the person responsible for creating the original website content
B) the person responsible for updating and maintaining website content
C) includes fixed data incapable of change in the event of a user action
D) includes data that change based on user action
353) What is a dynamic website information?
A) the person responsible for creating the original website content
B) includes data that change based on user action
C) information is stored in a dynamic catalog, or an area of a website that stores information about products in a database
D) an interactive website kept constantly updated and relevant to the needs of its customers using a database
354) What is data-driven website?
A) the person responsible for creating the original website content
B) includes data that change based on user action
C) information is stored in a dynamic catalog, or an area of a website that stores information about products in a database
D) an interactive website kept constantly updated and relevant to the needs of its customers using a database
355) Business analysis is difficult from operational databases. Which of the following is a reason why?
A) Every department has its own method for recording data.
B) Lack of data standards across departments.
C) The data, if available, were often incorrect or incomplete.
D) All of these.
356) Business analysis is difficult to achieve from operational databases. Which of the following is not a reason why?
A) inconsistent data definitions
B) lack of data standards
C) effective direct data access
D) poor data quality
357) Which of the following is not a dirty data problem?
A) duplicate data
B) inaccurate data
C) specific data
D) non-integrated data
358) Companies can choose information cleansing software from several vendors. Which of the following is not a vendor mentioned in your text?
A) Oracle
B) SAS
C) Ascential Software
D) McAffee
359) What is erroneous or flawed data?
A) data set
B) dirty data
C) data map
D) data point
360) What is an organized collection of data?
A) data set
B) dirty data
C) data map
D) data point
361) What is a technique for establishing a match, or balance, between the source data and the target data warehouse?
A) data set
B) dirty data
C) data map
D) data point
362) What is an individual item on a graph or a chart?
A) data set
B) dirty data
C) data map
D) data point
363) What is a central location in which data is stored and managed?
A) repository
B) data warehouse
C) data aggregation
D) data broker
364) What is a collection of data from various sources for the purpose of data processing?
A) repository
B) data warehouse
C) data aggregation
D) data broker
365) What is a business that collects personal information about consumers and sells that information to other organizations?
A) repository
B) data warehouse
C) data aggregation
D) data broker
366) ________ can compare two or more data sets to identify patterns and trends.
A) Comparative analysis
B) Competitive monitoring
C) Data-driven decision management
D) Competitive analysis
367) BI can help managers with ________, where a company keeps tabs of its competitor's activities on the web using software that automatically tracks all competitor website activities such as discounts and new products.
A) comparative analysis
B) competitive monitoring
C) data-driven decision management
D) source data
368) Which of the following is an approach to business governance that values decisions that can be backed up with verifiable data?
A) comparative analysis
B) competitive monitoring
C) data-driven decision management
D) source data
369) Which of the following identifies the primary location where data is collected?
A) comparative analysis
B) competitive monitoring
C) data-driven decision management
D) source data
370) What is a storage repository that holds a vast amount of raw data in its original format until the business needs it?
A) data broker
B) data lake
C) data map
D) data point
371) What is a data broker?
A) a business that collects personal information about consumers and sells that information to other organizations
B) a storage repository that holds a vast amount of raw data in its original format until the business needs it
C) a technique for establishing a match, or balance, between the source data and the target data warehouse
D) an approach to business governance that values decisions that can be backed up with verifiable data
372) What is a data lake?
A) a business that collects personal information about consumers and sells that information to other organizations
B) a storage repository that holds a vast amount of raw data in its original format until the business needs it
C) a technique for establishing a match, or balance, between the source data and the target data warehouse
D) an approach to business governance that values decisions that can be backed up with verifiable data
373) What is a data map?
A) a business that collects personal information about consumers and sells that information to other organizations
B) a storage repository that holds a vast amount of raw data in its original format until the business needs it
C) a technique for establishing a match, or balance, between the source data and the target data warehouse
D) an approach to business governance that values decisions that can be backed up with verifiable data
374) What is data-driven decision management?
A) a business that collects personal information about consumers and sells that information to other organizations
B) a storage repository that holds a vast amount of raw data in its original format until the business needs it
C) a technique for establishing a match, or balance, between the source data and the target data warehouse
D) an approach to business governance that values decisions that can be backed up with verifiable data
375) What is source data?
A) identifies the primary location where data is collected
B) a storage repository that holds a vast amount of raw data in its original format until the business needs it
C) a technique for establishing a match, or balance, between the source data and the target data warehouse
D) an approach to business governance that values decisions that can be backed up with verifiable data
376) What is a data point?
A) identifies the primary location where data is collected
B) an individual item on a graph or chart
C) a technique for establishing a match, or balance, between the source data and the target data warehouse
D) an approach to business governance that values decisions that can be backed up with verifiable data
377) Business intelligence can provide managers with the ability to make better decisions. Which of the following is not an example of how different industries use business intelligence?
A) Analyze popular vacation locations with current flight listings.
B) Understand customer credit card usage and nonpayment rates.
C) Compare the demographics of patients with critical illnesses.
D) All of these are examples of how industries use business intelligence.
378) Business intelligence can provide managers with the ability to make better decisions. Which of the following is not an example of how different industries use business intelligence?
A) Predict claim amounts and medical coverage costs.
B) Track crime patterns, locations, and criminal behavior.
C) Identify the primary locations where data is collected.
D) Predict sales, inventory levels, and distribution.
379) Which of the following questions is an example of how managers can use BI to answer tough business questions?
A) Where has the business been?
B) Where is the business now?
C) Where is the business going?
D) All of these.
380) Managers can use BI to answer tough business questions. Which of the following describes the value of knowing where the business has been?
A) A historical perspective offers important variables for determining trends and patterns.
B) Looking at the current business situation allows managers to take effective action to solve issues before they grow out of control.
C) Setting strategic direction is critical for planning and creating solid business strategies.
D) None of these.
381) Managers can use BI to answer tough business questions. Which of the following describes the value of knowing where the business has been?
A) A historical perspective offers important variables for determining trends and patterns.
B) Looking at the current business situation allows managers to take effective action to solve issues before they grow out of control.
C) Setting strategic direction is critical for planning and creating solid business strategies.
D) None of these.
382) Managers can use BI to answer tough business questions. Which of the following describes the value of knowing where the business is now?
A) A historical perspective offers important variables for determining trends and patterns.
B) Looking at the current business situation allows managers to take effective action to solve issues before they grow out of control.
C) Setting strategic direction is critical for planning and creating solid business strategies.
D) None of these.
383) Managers can use BI to answer tough business questions. Which of the following describes the value of knowing where the business is going?
A) A historical perspective offers important variables for determining trends and patterns.
B) Looking at the current business situation allows managers to take effective action to solve issues before they grow out of control.
C) Setting strategic direction is critical for planning and creating solid business strategies.
D) None of these.
384) Data-driven decision management is usually undertaken as a way to gain a competitive advantage. A study from the MIT Center for Digital Business found that organizations driven most by data-based decision making had ________ productivity rates and ________ profits.
A) 4% lower; 6% higher
B) 4% higher; 6% lower
C) 4% higher; 6% higher
D) 4% lower; 6% lower
385) Business analysis is difficult from operational databases. Which of the following is not a reason why?
A) Every department has its own method for recording data.
B) When sharing data, it matches and users get the data they need.
C) The data is of poor quality.
D) The data collected is not always useful for intended purposes.
386) Business analysis is difficult from operational databases. Which of the following is not a reason why?
A) Every department has its own method for recording data.
B) Data stored in operational databases did not allow users direct access.
C) The data is standardized.
D) The data collected is not always useful for intended purposes.
387) What does standardization of data elements accomplish?
A) greater accuracy
B) completeness and completeness
C) increases the quality of information
D) all of these
388) In which ways does a data warehouse enable business users to be more effective?
A) analyzing trends
B) identifying financial issues
C) understanding competitors
D) all of these
389) Businesses collect a tremendous amount of ________ information as part of their routine operations.
A) operational
B) transactional
C) aggregate
D) comparative
390) Kassandra Young is a business manager at Weith Productions. Although she does not have a background in technology, her job requires her to work with analytical tools to make data-driven decisions. To make her job easier, what can she customize to display data quickly and run custom reports?
A) data point
B) information cleansing
C) dashboard
D) data set
391) What are processes that manage algorithms across many machines in a computing environment?
A) distributed computing
B) advanced analytics
C) analysis paralysis
D) data artist
392) What focuses on forecasting future trends and producing insights using sophisticated quantitative methods, including statistics, descriptive and predictive data mining, simulation, and optimization?
A) distributed computing
B) advanced analytics
C) analysis paralysis
D) data artist
393) What is distributed computing?
A) processes and manages algorithms across many machines in a computing environment
B) focuses on forecasting future trends and producing insights using sophisticated quantitative methods, including statistics, descriptive and predictive data mining, simulation, and optimization
C) occurs when the user goes into an emotional state of over-analysis (or over-thinking) a situation so that a decision or action is never taken, in effect paralyzing the outcome
D) a business analytics specialist who uses visual tools to help people understand complex data
394) What focuses on forecasting future trends and producing insights using sophisticated quantitative methods, including statistics, descriptive and predictive data mining, simulation, and optimization?
A) big data
B) distributed computing
C) advanced analytics
D) data scientist
395) In terms of big data what is variety?
A) includes different forms of structured and unstructured data
B) includes the uncertainty of data, including biases, noise, and abnormalities
C) includes the scale of data
D) includes the analysis of streaming data as it travels around the Internet
396) In terms of big data what is veracity?
A) includes different forms of structured and unstructured data
B) includes the uncertainty of data, including biases, noise, and abnormalities
C) includes the scale of data
D) includes the analysis of streaming data as it travels around the Internet
397) In terms of big data what is volume?
A) includes different forms of structured and unstructured data
B) includes the uncertainty of data, including biases, noise, and abnormalities
C) includes the scale of data
D) includes the analysis of streaming data as it travels around the Internet
398) In terms of big data what is velocity?
A) includes different forms of structured and unstructured data
B) includes the uncertainty of data, including biases, noise, and abnormalities
C) includes the scale of data
D) includes the analysis of streaming data as it travels around the Internet
399) In terms of big data what includes different forms of structured and unstructured data?
A) variety
B) veracity
C) volume
D) velocity
400) In terms of big data what includes the uncertainty of data, including biases, noise, and abnormalities?
A) variety
B) veracity
C) volume
D) velocity
401) In terms of big data what includes the scale of data?
A) variety
B) veracity
C) volume
D) velocity
402) In terms of big data what includes the analysis of streaming data as it travels around the Internet?
A) variety
B) veracity
C) volume
D) velocity
403) What is a collection of large, complex data sets, including structured and unstructured data, which cannot be analyzed using traditional database methods and tools?
A) big data
B) distributed computing
C) advanced analytics
D) data scientist
404) What is big data?
A) a collection of large, complex data sets, including structured and unstructured data, which cannot be analyzed using traditional database methods and tools
B) processes and manages algorithms across many machines in a computing environment
C) focuses on forecasting future trends and producing insights using sophisticated quantitative methods, including statistics, descriptive and predictive data mining, simulation, and optimization
D) extracts knowledge from data by performing statistical analysis, data mining, and advanced analytics on big data to identify trends, market changes, and other relevant information
405) What is distributed computing?
A) a collection of large, complex data sets, including structured and unstructured data, which cannot be analyzed using traditional database methods and tools
B) processes and manages algorithms across many machines in a computing environment
C) focuses on forecasting future trends and producing insights using sophisticated quantitative methods, including statistics, descriptive and predictive data mining, simulation, and optimization
D) extracts knowledge from data by performing statistical analysis, data mining, and advanced analytics on big data to identify trends, market changes, and other relevant information
406) What is advanced analytics?
A) a collection of large, complex data sets, including structured and unstructured data, which cannot be analyzed using traditional database methods and tools
B) processes and manages algorithms across many machines in a computing environment
C) focuses on forecasting future trends and producing insights using sophisticated quantitative methods, including statistics, descriptive and predictive data mining, simulation, and optimization
D) extracts knowledge from data by performing statistical analysis, data mining, and advanced analytics on big data to identify trends, market changes, and other relevant information
407) What is the process of analyzing data to extract information not offered by the raw data alone?
A) data integrity
B) data mart analysis
C) data mining
D) data extraction
408) What are the two main objectives associated with data mining?
A) uncovering tactics and plans
B) uncovering trends and patterns
C) uncovering intelligence and unstructured data issues
D) uncovering competitors and market advantages
409) Which of the following uses a variety of techniques to find patterns and relationships in large volumes of information that predict future behavior and guide decision making?
A) data analysis tools
B) electronic analysis tools
C) data-mining tools
D) data integrity tools
410) Which of the following is not a common form of data mining analysis?
A) division organization
B) classification
C) estimation
D) clustering
411) Which of the following forms of data mining assigns records to one of a predefined set of classes?
A) clustering
B) classification
C) estimation
D) affinity grouping
412) What is another term for data that is already contained in a database or a spreadsheet?
A) structured data
B) unstructured data
C) text mining
D) web mining
413) What is another term for data that does not exist in a fixed location?
A) structured data
B) unstructured data
C) text mining
D) web mining
414) What analyzes unstructured data to find trends and patterns in words and sentences?
A) structured data
B) unstructured data
C) text analytics
D) web analytics
415) What is web analytics?
A) unstructured data associated with websites to identify consumer behavior and website navigation
B) analyzes structured data associated with a website
C) filters information, both structured and unstructured, to help identify strong web customers
D) none of these
416) What is the technique used to divide information sets into mutually exclusive groups such that the members of each group are as close together as possible to one another and the different groups are as far apart as possible?
A) statistical detection
B) cluster analysis
C) association detection
D) social media analytics
417) What is an example of using cluster analysis in business to create target-marketing strategies?
A) Google search
B) first name information
C) zip code segmentation
D) last name associations
418) Which of the below reveals the relationship between variables along with the nature and frequency of the relationship?
A) association detection
B) masking detection tool
C) cluster grouping
D) blocking barriers
419) What is a common association detection analysis technique where you analyze certain items to detect customers' buying behavior and predict future behavior?
A) clustering factors
B) mashup technology
C) market basket analysis
D) drill-down basket analysis
420) What is prediction?
A) a statement about what will happen or might happen in the future, for example, predicting future sales or employee turnover
B) a statistical process that finds the way to make a design, system, or decision as effective as possible, for example, finding the values of controllable variables that determine maximal productivity or minimal waste
C) predictions based on time-series information
D) a statistical process for estimating the relationships among variables
421) What is optimization?
A) a statement about what will happen or might happen in the future, for example, predicting future sales or employee turnover
B) a statistical process that finds the way to make a design, system, or decision as effective as possible, for example, finding the values of controllable variables that determine maximal productivity or minimal waste
C) predictions based on time-series information
D) a statistical process for estimating the relationships among variables
422) What are forecasts?
A) a statement about what will happen or might happen in the future, for example, predicting future sales or employee turnover
B) a statistical process that finds the way to make a design, system, or decision as effective as possible, for example, finding the values of controllable variables that determine maximal productivity or minimal waste
C) predictions based on time-series information
D) a statistical process for estimating the relationships among variables
423) What is regression?
A) a statement about what will happen or might happen in the future, for example, predicting future sales or employee turnover
B) a statistical process that finds the way to make a design, system, or decision as effective as possible, for example, finding the values of controllable variables that determine maximal productivity or minimal waste
C) predictions based on time-series information
D) a statistical process for estimating the relationships among variables
424) What is a statement about what will happen or might happen in the future, for example, predicting future sales or employee turnover?
A) prediction
B) optimization
C) forecasting
D) regression
425) What is a statistical process that finds the way to make a design, system, or decision as effective as possible, for example, finding the values of controllable variables that determine maximal productivity or minimal waste?
A) prediction
B) optimization
C) forecasting
D) regression
426) What are predictions based on time-series information?
A) prediction
B) optimization
C) forecasting
D) regression
427) What is a statistical process for estimating the relationships among variables?
A) prediction
B) optimization
C) forecasting
D) regression
428) What is classification?
A) determines values for an unknown continuous variable behavior or estimated future value
B) determines which things go together
C) segments a heterogeneous population of more homogeneous subgroups
D) assigns records to one of a predefined set of classes
429) What is estimation?
A) determines values for an unknown continuous variable behavior or estimated future value
B) determines which things go together
C) segments a heterogeneous population of more homogeneous subgroups
D) assigns records to one of a predefined set of classes
430) What is affinity grouping?
A) determines values for an unknown continuous variable behavior or estimated future value
B) determines which things go together
C) segments a heterogeneous population of more homogeneous subgroups
D) assigns records to one of a predefined set of classes
431) What is clustering?
A) determines values for an unknown continuous variable behavior or estimated future value
B) determines which things go together
C) segments a heterogeneous population of more homogeneous subgroups
D) assigns records to one of a predefined set of classes
432) What assigns records to one of a predefined set of classes?
A) classification
B) estimation
C) affinity grouping
D) clustering
433) What determines values for an unknown continuous variable behavior or estimated future value?
A) classification
B) estimation
C) affinity grouping
D) clustering
434) What determines which things go together?
A) classification
B) estimation
C) affinity grouping
D) clustering
435) What segments a heterogeneous population of more homogeneous subgroups?
A) classification
B) estimation
C) affinity grouping
D) clustering
436) What is data mining?
A) the common term for the representation of multidimensional information
B) a particular attribute of information
C) uses a variety of techniques to find patterns and relationships in large volumes of information and infer rules from them that predict future behavior and guide decision making
D) process of analyzing data to extract information not offered by the raw data alone
437) What displays information graphically so it can be easily understood?
A) informing
B) infographics
C) data visualization
D) business intelligence dashboards
438) What can present the results of large data analysis looking for patterns and relationships that monitor changes in variables over time?
A) informing
B) infographics
C) data visualization
D) business intelligence dashboards
439) What describes technologies that allow users to "see" or visualize data to transform information into a business perspective?
A) informing
B) infographics
C) data visualization
D) business intelligence dashboards
440) What moves beyond Excel graphs and charts into sophisticated analysis techniques such as pie charts, controls, instruments, maps, time-series graphs, and more?
A) informing
B) infographics
C) data visualization tools
D) business intelligence dashboards
441) What can help uncover correlations and trends in data that would otherwise go unrecognized?
A) informing
B) infographics
C) data visualization tools
D) business intelligence dashboards
442) What tracks corporate metrics such as critical success factors and key performance indicators, and includes advanced capabilities such as interactive controls allowing users to manipulate data for analysis?
A) informing
B) infographics
C) data visualization tools
D) business intelligence dashboards
443) What is a data scientist?
A) a collection of large, complex data sets, including structured and unstructured data, which cannot be analyzed using traditional database methods and tools
B) processes and manages algorithms across many machines in a computing environment
C) focuses on forecasting future trends and producing insights using sophisticated quantitative methods, including statistics, descriptive and predictive data mining, simulation, and optimization
D) extracts knowledge from data by performing statistical analysis, data mining, and advanced analytics on big data to identify trends, market changes, and other relevant information
444) What processes and manages algorithms across many machines in a computing environment?
A) big data
B) distributed computing
C) advanced analytics
D) data scientist
445) What is social media analytics?
A) analyzes text flowing across the Internet, including unstructured text from blogs and messages
B) the process of analyzing recorded calls to gather information; brings structure to customer interactions and exposes information buried in customer contact center interactions with an enterprise
C) analyzes unstructured data to find trends and patterns in words and sentences
D) analyzes unstructured data associated with websites to identify consumer behavior and website navigation
446) What is speech analytics?
A) analyzes text flowing across the Internet, including unstructured text from blogs and messages
B) the process of analyzing recorded calls to gather information; brings structure to customer interactions and exposes information buried in customer contact center interactions with an enterprise
C) analyzes unstructured data to find trends and patterns in words and sentences
D) analyzes unstructured data associated with websites to identify consumer behavior and website navigation
447) What is text analytics?
A) analyzes text flowing across the Internet, including unstructured text from blogs and messages
B) the process of analyzing recorded calls to gather information; brings structure to customer interactions and exposes information buried in customer contact center interactions with an enterprise
C) analyzes unstructured data to find trends and patterns in words and sentences
D) analyzes unstructured data associated with websites to identify consumer behavior and website navigation
448) What is web analytics?
A) analyzes text flowing across the Internet, including unstructured text from blogs and messages
B) the process of analyzing recorded calls to gather information; brings structure to customer interactions and exposes information buried in customer contact center interactions with an enterprise
C) analyzes unstructured data to find trends and patterns in words and sentences
D) analyzes unstructured data associated with websites to identify consumer behavior and website navigation
449) What analyzes text flowing across the Internet, including unstructured text from blogs and messages?
A) social media analytics
B) speech analytics
C) text analytics
D) web analytics
450) What is the process of analyzing recorded calls to gather information; brings structure to customer interactions and exposes information buried in customer contact center interactions with an enterprise?
A) social media analytics
B) speech analytics
C) text analytics
D) web analytics
451) What analyzes unstructured data to find trends and patterns in words and sentences?
A) social media analytics
B) speech analytics
C) text analytics
D) web analytics
452) What analyzes unstructured data associated with websites to identify consumer behavior and website navigation?
A) social media analytics
B) speech analytics
C) text analytics
D) web analytics
453) What are advanced analytics?
A) processes and manages algorithms across many machines in a computing environment
B) focuses on forecasting future trends and producing insights using sophisticated quantitative methods, including statistics, descriptive and predictive data mining, simulation, and optimization
C) occurs when the user goes into an emotional state of over-analysis (or over-thinking) a situation so that a decision or action is never taken, in effect paralyzing the outcome
D) a business analytics specialist who uses visual tools to help people understand complex data
454) What is analysis paralysis?
A) processes and manages algorithms across many machines in a computing environment
B) focuses on forecasting future trends and producing insights using sophisticated quantitative methods, including statistics, descriptive and predictive data mining, simulation, and optimization
C) occurs when the user goes into an emotional state of over-analysis (or over-thinking) a situation so that a decision or action is never taken, in effect paralyzing the outcome
D) a business analytics specialist who uses visual tools to help people understand complex data
455) What is a data artist?
A) processes and manages algorithms across many machines in a computing environment
B) focuses on forecasting future trends and producing insights using sophisticated quantitative methods, including statistics, descriptive and predictive data mining, simulation, and optimization
C) occurs when the user goes into an emotional state of over-analysis (or over-thinking) a situation so that a decision or action is never taken, in effect paralyzing the outcome
D) a business analytics specialist who uses visual tools to help people understand complex data
456) What occurs when the user goes into an emotional state of over-analysis (or over-thinking) a situation so that a decision or action is never taken, in effect paralyzing the outcome?
A) distributed computing
B) advanced analytics
C) analysis paralysis
D) data artist
457) What is a business analytics specialist who uses visual tools to help people understand complex data?
A) distributed computing
B) advanced analytics
C) analysis paralysis
D) data artist
458) What occurs when the user goes into an emotional state of over-analysis (or over-thinking) a situation so that a decision or action is never taken, in effect paralyzing the outcome?
A) analytical paradox
B) analytical analysis
C) analysis paralysis
D) analysis paradox
459) What is fast data?
A) processes and manages algorithms across many machines in a computing environment
B) a data value that is numerically distant from most of the other data points in a set of data
C) occurs when the user goes into an emotional state of over-analysis (or over-thinking) a situation so that a decision or action is never taken, in effect paralyzing the outcome
D) the application of big data analytics to smaller data sets in near-real or real-time in order to solve a problem or create business value
460) What an outlier?
A) processes and manages algorithms across many machines in a computing environment
B) a data value that is numerically distant from most of the other data points in a set of data
C) occurs when the user goes into an emotional state of over-analysis (or over-thinking) a situation so that a decision or action is never taken, in effect paralyzing the outcome
D) the application of big data analytics to smaller data sets in near-real or real-time in order to solve a problem or create business value
461) What is a data value that is numerically distant from most of the other data points in a set of data?
A) fast data
B) outlier
C) analysis paralysis
D) cube
462) What is the application of big data analytics to smaller data sets in near-real or real-time in order to solve a problem or create business value?
A) fast data
B) outlier
C) analysis paralysis
D) cube
463) Explain the four primary traits that determine the value of information.
464) Describe a database, a database management system, and the relational database model.
465) Identify the business advantages of a relational database.
466) Explain the business benefits of a data-driven website.
467) Define a data warehouse, and provide a few reasons it can make a manager more effective.
468) Explain ETL and the role of a data mart in business.
469) Identify the advantages of using business intelligence to support managerial decision making.
470) Define data mining, and explain the three common forms for mining structured and unstructured data.
Document Information
Connected Book
M Information Systems 5th Edition | Test Bank with Answer Key by Paige Baltzan
By Paige Baltzan
Explore recommendations drawn directly from what you're reading
Chapter 4 Ethics + Information Security Mis Business Concerns
DOCX Ch. 4
Chapter 5 Infrastructures Sustainable Technologies
DOCX Ch. 5
Chapter 6 Data Business Intelligence
DOCX Ch. 6 Current
Chapter 7 Networks Mobile Business
DOCX Ch. 7
Chapter 8 Enterprise Applications Business Communications
DOCX Ch. 8