Ch 1, 2, 3, 5
All of the following may be viewed as decision support systems except:
A retail sales system that processes customer sales transactions.
33) Business intelligence (BI) can be characterized as a transformation of A) data to information to decisions to actions. B) Big Data to data to information to decisions. C) actions to decisions to feedback to information. D) data to processing to information to actions.
A) data to information to decisions to actions.
33) What class of DSS incorporates simulation and optimization? A) model-driven DSS B) data-driven DSS C) communications-driven/Group DSS D) knowledge-driven DSS
A) model-driven DSS
35) The fact that many organizations share many similar problems means that in sourcing a DSS, it is often wiser to acquire a(n) A) ready-made DSS. B) custom-made DSS. C) offshored DSS. D) consultant-developed DSS.
A) ready-made DSS.
34) When a DSS is built, used successfully and integrated into the company's business processes, it was most likely built for a(n) A) recurrent decision. B) one-off decision. C) unimportant decision. D) ambiguous decision.
A) recurrent decision.
34) When representing data in a data warehouse, using several dimension tables that are each connected only to a fact table means you are using which warehouse structure? A) star schema B) snowflake schema C) relational schema D) dimensional schema
A) star schema
22) Operational or transaction databases are product oriented, handling transactions that update the database. In contrast, data warehouses are A) subject-oriented and nonvolatile. B) product-oriented and nonvolatile. C) product-oriented and volatile. D) subject-oriented and volatile.
A) subject-oriented and nonvolatile.
24) A search for alternatives occurs in which phase of the decision making/action model? A) the design phase B) the intelligence phase C) the choice phase D) the implementation phase
A) the design phase
30) In which stage of extraction, transformation, and load (ETL) into a data warehouse are data aggregated? A) transformation B) extraction C) load D) cleanse
A) transformation
1) Computerized support is only used for organizational decisions that are responses to external pressures, not for taking advantage of opportunities.
Answer: FALSE
1) When HP approaches problem-solving, the first step in solving business problems is building a model that enables decision makers to develop a good understanding of the problem.
Answer: FALSE
10) Due to the fact that organizations seek to store greater amounts of data than ever before, the cost per byte of computer-based data storage devices is rapidly rising.
Answer: FALSE
10) Qualitative elements of a problem cannot be incorporated into formal decision models, so one can only seek to minimize their impact.
Answer: FALSE
11) Computerized information systems help decision makers overcome human cognitive limitations in assembling and processing varied information. However, this is of little use in most analytical applications.
Answer: FALSE
11) Since the business environment involves considerable uncertainty, a manager cannot use modeling to estimate the risks resulting from specific actions.
Answer: FALSE
13) The term decision support system is a very specific term that implies the same tool, system, and development approach to most developers.
Answer: FALSE
14) Generating alternatives manually is often necessary in the model-building process. The best option for the decision makers is to generate as many of these alternatives as is conceivable.
Answer: FALSE
15) Generally speaking, people intuitively estimate risk quite accurately.
Answer: FALSE
15) One of the four components of BI systems, business performance management, is a collection of source data in the data warehouse.
Answer: FALSE
17) Business intelligence systems typically support solving a certain problem or evaluate an opportunity, while decision support systems monitor situations and identify problems and/or opportunities, using analytic methods.
Answer: FALSE
17) The use of dashboards and data visualizations is seldom effective in finding efficiencies in organizations, as demonstrated by the Seattle Children's Hospital Case Study.
Answer: FALSE
18) A well-designed data warehouse means that user requirements do not have to change as business needs change.
Answer: FALSE
18) Artificial intelligence-based DSS fall into this category of document-driven DSS.
Answer: FALSE
19) Data warehouse administrators (DWAs) do not need strong business insight since they only handle the technical aspect of the infrastructure.
Answer: FALSE
19) Pushing programming out to distributed data is achieved solely by using the Hadoop Distributed File System or HDFS.
Answer: FALSE
2) In a decision making environment, continuous change always validates the assumptions of the decision makers.
Answer: FALSE
2) The complexity of today's business environment creates many new challenges for organizations, such as global competition, but creates few new opportunities in return.
Answer: FALSE
3) The most important feature of management support systems is the computational efficiency involved in making a decision.
Answer: FALSE
5) Single decision makers rarely face decisions with multiple objectives in organizations and so are not the focus of data analytics tools.
Answer: FALSE
6) In today's business environment, creativity, intuition, and interpersonal skills are effective substitutes for analytical decision making.
Answer: FALSE
6) The design phase of decision making is where the decision maker examines reality and identifies and defines the problem.
Answer: FALSE
7) Only after the failed implementation of a decision can the decision maker return a prior stage of decision making.
Answer: FALSE
8) Due to the fact that business environments are now more complex than ever, trial-and-error is an effective means of arriving at acceptable solutions.
Answer: FALSE
9) Group collaboration software has proved generally ineffective at improving decision-making.
Answer: FALSE
12) A normative model examines all the possible alternatives in order to prove that the one selected is the best.
Answer: TRUE
12) In the Gorry and Scott-Morton framework of structured, semi-structured, and unstructured decisions, computerized decision support can bring benefits to unstructured decisions.
Answer: TRUE
13) Since a descriptive model checks the performance of the system for only a subset of all possible alternatives, there is no guarantee that a selected alternative will be optimal.
Answer: TRUE
14) The access to data and ability to manipulate data (frequently including real-time data) are key elements of business intelligence (BI) systems.
Answer: TRUE
16) A data warehouse can support the intelligence phase of decision making by continuously monitoring both internal and external information, looking for early signs of problems and opportunities through a Web-based enterprise information portal or dashboard.
Answer: TRUE
16) Actionable intelligence is the primary goal of modern-day Business Intelligence (BI) systems vs. historical reporting that characterized Management Information Systems (MIS).
Answer: TRUE
17) The data warehousing maturity model consists of six stages: prenatal, infant, child, teenager, adult, and sage.
Answer: TRUE
18) The use of statistics in baseball by the Oakland Athletics, as described in the Moneyball case study, is an example of the effectiveness of prescriptive analytics.
Answer: TRUE
19) The DSS component that includes the financial, statistical, management science, or other quantitative models is called the model management subsystem.
Answer: TRUE
20) Knowledge-based management subsystems provide intelligence to augment the decision maker's own intelligence.
Answer: TRUE
20) Volume, velocity, and variety of data characterize the Big Data paradigm.
Answer: TRUE
3) In addition to deploying business intelligence (BI) systems, companies may also perform other actions to counter business pressures, such as improving customer service and entering business alliances.
Answer: TRUE
4) The overwhelming majority of competitive actions taken by businesses today feature computerized information system support.
Answer: TRUE
4) Web-based decision support systems can provide support to both individuals and groups that act in a decision-making capacity.
Answer: TRUE
5) PCs and, increasingly, mobile devices are the most common means of providing managers with information to directly support decision making, instead of using IT staff intermediaries.
Answer: TRUE
7) In a four-step process for decision making, managers construct a model of the problem before they evaluate potential solutions.
Answer: TRUE
8) Web-based collaboration tools (e.g., GSS) can assist in multiple stages of decision making, not just the intelligence phase.
Answer: TRUE
9) Uncovering the existence of a problem can be achieved through monitoring and analyzing of the organization's productivity level. The derived measurements of productivity are based on real data
Answer: TRUE
21) The HP Case illustrates that after analytics are chosen to solve a problem, building a new decision model from scratch or purchasing one may not always be the best approach. Why is that? A) Decision models should never be purchased, only developed in house. B) A related tool requiring slight modification may already exist. C) CIOs are more likely to allocate funds to new development. D) Analytic models work better when they are built from scratch or purchased.
B) A related tool requiring slight modification may already exist.
39) How does the use of cloud computing affect the scalability of a data warehouse? A) Cloud computing vendors bring as much hardware as needed to users' offices. B) Hardware resources are dynamically allocated as use increases. C) Cloud vendors are mostly based overseas where the cost of labor is low. D) Cloud computing has little effect on a data warehouse's scalability.
B) Hardware resources are dynamically allocated as use increases.
36) Which of the following online analytical processing (OLAP) technologies does NOT require the precomputation and storage of information? A) MOLAP B) ROLAP C) HOLAP D) SQL
B) ROLAP
37) How are descriptive analytics methods different from the other two types? A) They answer "what-if?" queries, not "how many?" queries. B) They answer "what-is?" queries, not "what will be?" queries. C) They answer "what to do?" queries, not "what-if?" queries. D) They answer "what will be?" queries, not "what to do?" queries.
B) They answer "what-is?" queries, not "what will be?" queries.
39) What type of user interface has been recognized as an effective DSS GUI because it is familiar, user friendly, and a gateway to almost all sources of necessary information and data? A) ASP.net B) Web browsers C) visual basic interfaces D) mainframe interfaces
B) Web browsers
28) The deployment of large data warehouses with terabytes or even petabytes of data been crucial to the growth of decision support. All the following explain why EXCEPT A) data warehouses have enabled the affordable collection of data for analytics. B) data warehouses have enabled the collection of decision makers in one place. C) data warehouses have assisted the collection of data for data mining. D) data warehouses have assisted the collection of data from multiple sources.
B) data warehouses have enabled the collection of decision makers in one place.
23) All of the following statements about decision style are true EXCEPT A) autocratic styles are authority-based. B) decision styles are consistent among top managers. C) heuristic styles can also be democratic. D) decision styles may vary among lower-level managers.
B) decision styles are consistent among top managers.
31) All of the following statements about the decision implementation phases are true EXCEPT A) implementation is every bit as important as the decision itself. B) employees need only the decisions from the CEO, not the rationale. C) ERP, CRP, and BPM tools can all help track decision implementation. D) ES and KMS can help in training and support for decision implementation.
B) employees need only the decisions from the CEO, not the rationale.
29) Which approach to data warehouse integration focuses more on sharing process functionality than data across systems? A) extraction, transformation, and load B) enterprise application integration C) enterprise information integration D) enterprise function integration
B) enterprise application integration
27) What form of decision theory assumes that decision makers are rational beings who always seek to strictly maximize economic goals? A) the theory of bounded rationality B) normative decision theory C) satisficing decision theory D) human optimal decision theory
B) normative decision theory
26) Which of the following BEST enables a data warehouse to handle complex queries and scale up to handle many more requests? A) use of the web by users as a front-end B) parallel processing C) Microsoft Windows D) a larger IT staff
B) parallel processing
34) In answering the question "Which customers are most likely to click on my online ads and purchase my goods?", you are most likely to use which of the following analytic applications? A) customer profitability B) propensity to buy C) customer attrition D) channel optimization
B) propensity to buy
31) For the majority of organizations, a daily accounts receivable transaction is a(n) A) strategic decision. B) structured decision. C) unstructured decision. D) managerial control decision.
B) structured decision.
22) In the Magpie Sensing case study, the automated collection of temperature and humidity data on shipped goods helped with various types of analytics. Which of the following is an example of predictive analytics? A) real time reports of the shipment's temperature B) warning of an open shipment seal C) location of the shipment D) optimal temperature setting
B) warning of an open shipment seal
Why analytical decision making skills are now viewed as more important than interpersonal skills for an organization's managers?
Because analytical-oriented mangers produce better results over time
37) The model management subsystem provides the system's analytical capabilities and appropriate software management. Which of the following is NOT an element of the model management subsystem? A) model base B) MBMS C) DBMS D) model execution, integration, and command processor
C) DBMS
36) The software that manages the DSS database and enables relevant data to be accessed by DSS application programs is called A) KWS. B) ERP. C) DBMS. D) CRM.
C) DBMS.
26) Why are analytical decision making skills now viewed as more important than interpersonal skills for an organization's managers? A) because interpersonal skills are never important in organizations B) because personable and friendly managers are always the least effective C) because analytical-oriented managers produce better results over time D) because analytical-oriented managers tend to be flashier and less methodical
C) because analytical-oriented managers produce better results over time
23) Which of the following is NOT an example that falls within the four major categories of business environment factors for today's organizations? A) globalization B) increased pool of customers C) fewer government regulations D) increased competition
C) fewer government regulations
35) In answering the question "Which customers are likely to be using fake credit cards?", you are most likely to use which of the following analytic applications? A) channel optimization B) customer segmentation C) fraud detection D) customer profitability
C) fraud detection
33) All of the following are benefits of hosted data warehouses EXCEPT A) smaller upfront investment. B) better quality hardware. C) greater control of data. D) frees up in-house systems.
C) greater control of data.
22) Groupthink in a decision-making environment occurs when A) group members all use the same analytic tools without having a choice. B) group members accept the same timeframe for problem solving without complaining. C) group members all accept a course of action without thinking for themselves. D) group members are all working together for the firm's success.
C) group members all accept a course of action without thinking for themselves.
28) Which data warehouse architecture uses a normalized relational warehouse that feeds multiple data marts? A) independent data marts architecture B) centralized data warehouse architecture C) hub-and-spoke data warehouse architecture D) federated architecture
C) hub-and-spoke data warehouse architecture
23) Which kind of data warehouse is created separately from the enterprise data warehouse by a department and not reliant on it for updates? A) sectional data mart B) public data mart C) independent data mart D) volatile data mart
C) independent data mart
38) Which of the following statements is more descriptive of active data warehouses in contrast with traditional data warehouses? A) strategic decisions whose impacts are hard to measure B) detailed data available for strategic use only C) large numbers of users, including operational staffs D) restrictive reporting with daily and weekly data currency
C) large numbers of users, including operational staffs
38) Prescriptive BI capabilities are viewed as more powerful than predictive ones for all the following reasons EXCEPT A) prescriptive BI gives actual guidance as to actions. B) understanding the likelihood of certain events often leaves unclear remedies. C) only prescriptive BI capabilities have monetary value to top-level managers. D) prescriptive models generally build on (with some overlap) predictive ones.
C) only prescriptive BI capabilities have monetary value to top-level managers.
27) Business environments and government requirements are becoming more complex. All of the following actions to manage this complexity would be appropriate EXCEPT A) hiring more sophisticated and computer-savvy managers. B) deploying more sophisticated tools and technique. C) seeking new ways to avoid government compliance. D) avoiding expensive trial and error to find out what works.
C) seeking new ways to avoid government compliance.
37) Active data warehousing can be used to support the highest level of decision making sophistication and power. The major feature that enables this in relation to handling the data is A) country of (data) origin. B) nature of the data. C) speed of data transfer. D) source of the data.
C) speed of data transfer.
28) When an Accounts Payable department improves their information system resulting in faster payments to vendors, without the Accounts Receivable Department doing the same, leading to a cash flow crunch, what can we say happened in decision-theoretic terms? A) optimization B) profit minimization C) suboptimization D) cash flow problems
C) suboptimization
40) Big Data often involves a form of distributed storage and processing using Hadoop and MapReduce. One reason for this is A) centralized storage creates too many vulnerabilities. B) the "Big" in Big Data necessitates over 10,000 processing nodes. C) the processing power needed for the centralized model would overload a single computer. D) Big Data systems have to match the geographical spread of social media.
C) the processing power needed for the centralized model would overload a single computer.
25) A Web client that connects to a Web server, which is in turn connected to a BI application server, is reflective of a A) one tier architecture. B) two tier architecture. C) three tier architecture. D) four tier architecture.
C) three tier architecture.
25) All of the following are benefits of using models for decision support EXCEPT A) it is easier to manipulate a model than a real system. B) you can find out probable outcomes of an action before actually taking it. C) using well-designed models always guarantees you success in implementation. D) the cost of a model is usually much lower than manipulating the system in implementation.
C) using well-designed models always guarantees you success in implementation.
Which of the following analytic techniques is used to understand customer options are expressed on websites
Collaborative filtering
Which of the following analytics is not in the move lever of the supply chain
Cross-selling
29) Which of the following statements about cognitive limits of organizational decision makers is true? A) Only top managers make decisions where cognitive limits are strained. B) The most talented and effective managers do not have cognitive limitations. C) All organizational decision-making requires data beyond human cognitive limits. D) Cognitive limits affect both the recall and use of data by decision makers.
D) Cognitive limits affect both the recall and use of data by decision makers.
39) Which of the following statements about Big Data is true? A) Data chunks are stored in different locations on one computer. B) Hadoop is a type of processor used to process Big Data applications. C) MapReduce is a storage filing system. D) Pure Big Data systems do not involve fault tolerance.
D) Pure Big Data systems do not involve fault tolerance.
32) For DSS, why are semistructured or unstructured decisions the main focus of support? A) There are many more unstructured and semistructured decisions than structured in organizations. B) MIS staff prefer to work on solving unstructured and semistructured decisions. C) Unstructured and semistructured decisions are the easiest to solve. D) They include human judgment, which is incorporated into DSS.
D) They include human judgment, which is incorporated into DSS.
32) All of the following may be viewed as decision support systems EXCEPT A) an expert system to diagnose a medical condition. B) a knowledge management system to guide decision makers. C) a system that helps to manage the organization's supply chain management. D) a retail sales system that processes customer sales transactions.
D) a retail sales system that processes customer sales transactions.
31) In which stage of extraction, transformation, and load (ETL) into a data warehouse are anomalies detected and corrected? A) transformation B) extraction C) load D) cleanse
D) cleanse
21) The "single version of the truth" embodied in a data warehouse such as Capri Casinos' means all of the following EXCEPT A) decision makers get to see the same results to queries. B) decision makers have the same data available to support their decisions. C) decision makers get to use more dependable data for their decisions. D) decision makers have unfettered access to all data in the warehouse.
D) decision makers have unfettered access to all data in the warehouse.
25) Which of the following activities permeates nearly all managerial activity? A) planning B) controlling C) directing D) decision-making
D) decision-making
30) The Web can play a significant role in making large amounts of information available to decision makers. Decision makers must be careful that this glut of information does not A) increase their enthusiasm for data available on the web. B) take on the same credibility of internally-generated data. C) take on the same role as human intuition. D) detract from the quality and speed of decision making.
D) detract from the quality and speed of decision making.
35) When querying a dimensional database, a user went from summarized data to its underlying details. The function that served this purpose is A) dice. B) slice. C) roll-up. D) drill down.
D) drill down.
38) While Microsoft Excel can be an efficient tool for developing a DSS, compared to using a programming language like C++, a shortcoming of Excel is A) it cannot be used effectively for small or medium sized problems. B) Excel is not widely understood compared to a language like C++. C) it is not widely available for purchase. D) errors can creep into formulas somewhat easily.
D) errors can creep into formulas somewhat easily.
27) Which data warehouse architecture uses metadata from existing data warehouses to create a hybrid logical data warehouse comprised of data from the other warehouses? A) independent data marts architecture B) centralized data warehouse architecture C) hub-and-spoke data warehouse architecture D) federated architecture
D) federated architecture
24) All of the following statements about metadata are true EXCEPT A) metadata gives context to reported data. B) there may be ethical issues involved in the creation of metadata. C) metadata helps to describe the meaning and structure of data. D) for most organizations, data warehouse metadata are an unnecessary expense.
D) for most organizations, data warehouse metadata are an unnecessary expense.
32) Data warehouses provide direct and indirect benefits to using organizations. Which of the following is an indirect benefit of data warehouses? A) better and more timely information B) extensive new analyses performed by users C) simplified access to data D) improved customer service
D) improved customer service
40) All of the following are true about in-database processing technology EXCEPT A) it pushes the algorithms to where the data is. B) it makes the response to queries much faster than conventional databases. C) it is often used for apps like credit card fraud detection and investment risk management. D) it is the same as in-memory storage technology.
D) it is the same as in-memory storage technology.
30) For the majority of organizations, evaluating the credit rating of a potential business partner is a(n) A) strategic decision. B) structured decision. C) unstructured decision. D) managerial control decision.
D) managerial control decision.
29) All of the following statements about risk in decision making are correct EXCEPT A) all business decisions incorporate an element of risk. B) decision makers frequently measure risk and uncertainty incorrectly. C) methodologies are available for handling extreme uncertainty. D) most decision makers are pessimistic about decision outcomes.
D) most decision makers are pessimistic about decision outcomes.
21) In the Magpie Sensing case study, the automated collection of temperature and humidity data on shipped goods helped with various types of analytics. Which of the following is an example of prescriptive analytics? A) real time reports of the shipment's temperature B) warning of an open shipment seal C) location of the shipment D) optimal temperature setting
D) optimal temperature setting
26) In the design phase of decision making, selecting a principle of choice or criteria means that A) if an objective model is used with hard data, all decision makers will make the same choice. B) risk acceptability is a subjective concept and plays little part in modeling. C) using well-designed models guarantees you success in real life. D) optimality is not the only criterion for acceptable solutions.
D) optimality is not the only criterion for acceptable solutions.
24) Organizations counter the pressures they experience in their business environments in multiple ways. Which of the following is NOT an effective way to counter these pressures? A) reactive actions B) anticipative actions C) adaptive actions D) retroactive actions
D) retroactive actions
40) The user communicates with and commands the DSS through the user interface subsystem. Researchers assert that some of the unique contributions of DSS are derived from A) the Web browser. B) the user being considered part of the system. C) some DSS user interfaces utilizing natural-language input (i.e., text in a human language). D) the intensive interaction between the computer and the decision maker.
D) the intensive interaction between the computer and the decision maker.
36) When Sabre developed their Enterprise Data Warehouse, they chose to use near-real-time updating of their database. The main reason they did so was A) to provide a 360 degree view of the organization. B) to aggregate performance metrics in an understandable way. C) to be able to assess internal operations. D) to provide up-to-date executive insights.
D) to provide up-to-date executive insights.
The "single version of the truth" embodied in a data warehouse such as Capri Casinos' means all of the following except
Decision makers have unfretted access to all data in the warehouse
The web can play a significant role in making large amounts of information available to decision makers. Decision makers must be careful that this glut of information does not
Detract from the quality and speed of decision making
When querying a dimensional database a user went from summarized data to its underlying details. The function that served this purpose is
Drill down
While Microsoft excel can be an efficient tool for developing DSS compared to using a programming language like C++ a shortcoming of excel is
Errors can creep into formulas somewhat easily
A well designed data warehouse means that user requirements do not have to change as business needs change
False
Computerized information systems help decision makers overcome human cognitive limitations in assembling and processing varied information. However this is of little use in most analytical applications
False
GPS tags monitor inventory on shelves and in-transit coordinating with current stock levels for automatic order replenishment
False
Generally speaking people intuitively estimate risk quite accurately
False
Group collaboration software has proved generally ineffective at improving decision-making
False
Point-of-Sale (POS) is not a source for big data
False
T or F? In the Isle of Capri case the only capabilities added by the new software was increases processing speed of processing reports
False
T or F? Moving the data into a data warehouse is usually the easiest part of its creation
False
T or F? When HP approaches problem solving the first step in the solving business problems is building a model that enables decision makers to develop a good understanding of the problem
False
The "Make" side of the supply chain is essentially sourcing or purchasing
False
The "move" lever in the supply chain is responsible for all activities and processes required to purchase goods and services from suppliers.
False
The "sell" side of the supply chain - Marketing - lags behind other parts of the supply chain in embracing big data opportunities
False
The most important feature of management support system is the computational efficiency involved in making a decision.
False
The three characteristics of big data are volume velocity and viscosity.
False
Tools such as correlation and regression are not helpful in big data analytics
False
Organizations seldom devote a lot of effort to creating metadata because it is not important for the effective use of data warehouses.
False A DW contains metadata about how the data are organized and how to effectively use them.
Two-tier data warehouse/BI infrastructures offer organizations more flexibility but cost more than three-tier ones.
False In two-tier architecture, the DSS engine physically runs on the same hardware platform as the DW. Therefore, it is more economical than the three-tier structure.
Bill Inmon advocates the data mart bus architecture whereas Ralph Kimball promotes the hub-and-spoke architecture, a data mart bus architecture with conformed dimensions.
False Inmon advocates the hub-and-spoke architecture, whereas Kimball promotes the data mart bus architecture with conformed dimensions.
Large companies, especially those with revenue upwards of $500 million consistently reap substantial cost savings through the use of hosted data warehouses.
False Large companies with revenue upwards of $500 million could lose money if they already have underused internal infrastructure and IT staff.
Moving the data into a data warehouse is usually the easiest part of its creation.
False Moving data from an existing system into a DW is a tedious and laborious task.
Subject oriented databases for data warehousing are organized by detailed subjects such as disk drives, computers, and networks.
False Subject-oriented databases for DW are organized by detailed subject, such as sales, products, or customers, containing only information relevant for decision support.
The ETL process in data warehousing usually takes up a small portion of the time in a data-centric project.
False The ETL process typically consumes 70 percent of the time in a data-centric project.
In the Isle of Capri case, the only capability added by the new software was increased processing speed of processing reports.
False The new software increased processing speed of processing reports, reduced time needed to construct direct-mail campaigns, honed prcess of segmentation, enables management/employees to better understand customer behavior, enhanced Isle's customer hosting program, and allowed more accurate property-to-property analysis.
OLTP systems are designed to handle ad hoc analysis and complex queries that deal with many data items.
False The very design that makes an OLTP system efficient for transaction processing makes it inefficient for end-user ad hoc reports, queries, and analysis. An OLTP system automates daily business transactions and running real-time reports and routine analysis.
Data warehouses are subsets of data marts.
False. Data marts are subsets of data warehouses.
20) Because the recession has raised interest in low-cost open source software, it is now set to replace traditional enterprise software.
False. Open source software augments traditional enterprise software without replacing it.
Which data warehouse architecture uses metadata from exciting data warehouses to create a hybrid logical data warehouse comprised of data from the other warehouses?
Federated architecture
Which of the following is not an example that falls within the four major categories of business environment factors for today's organizations?
Fewer government regulations
All of the following statements about metadata are true except
For most organizations data warehouse metadata are an unnecessary expense
Groupthink in a decision making environment occurs when
Group members all accept a course of action without thinking for themselves
Data warehouses provide direct and indirect benefits to using organization. Which of the following is an indirect benefit of data warehouses?
Improved customer service
Which of the following approach requires warehouse is to be located close to the manufacturing facility and able and frequent deliveries of materials on a just in time basis
Lean manufacturing
All of the following statements about risk decision making are correct except
Most decision makers are pessimistic about decision outcomes
What form of decision theory assumes that decision makers are rational being who always seek to strictly maximize economic goals?
Normative decision theory
The fact that many organizations share many similar problems means that in sourcing a DSS it is often wiser to acquire an
Ready-made DSS.
Organizations counter the pressures they experience in their business environments in multiple ways. Which of the following is not an effective way to counter these pressures?
Retroactive actions
Blank is the process of moving products upstream from the customer back toward manufacturers and suppliers
Reverse logistics
Big data often involves a form of distributed storage and processing using Hadoop and MapReduce. One reason for this is:
The processing power needed for the centralized model would overload a single computer
A web client that connects to a web server which is in turn connected to BI application server is reflective of a
Three tier architecture
When Sabre developed their Enterprise Data Warehouse the chose to use near-real-time updating of their database. The main reason they did so was:
To provide up-to-date executing insights
A normative model examines all the possible alternatives in order to prove that the one selected is the best
True
Because of performance and data quality issues most experts agree that the federate architecture should supplement data warehouses not replace them
True
Because of performance and data quality issues, most experts agree that the federated architecture should supplement data warehouses, not replace them.
True
Big chain analytics helps organizations increase supply chain visibility
True
Big data analytics tools such as GPS enable logistic companies to keep track of disruptive events in order to optimize routes and control fuel consumption
True
Big data provides more granularity for customer segmentation.
True
Collaborative filtering refers to the recommendation algorithm for cross selling
True
In the Starwood Hotels case, up-to-date data and faster reporting helped hotel managers better manage their occupancy rates.
True
One way an operational data store differs from a data warehouse is the recency of their data.
True
RFID technology can help companies automate inventory replenishment decisions
True
Sentiment analysis is a merchandising approach that involves deciding which products to Carrie and which stores based on local demographics
True
T or F? A supply chain can be viewed as a system of cross-organizational business processes.
True
T or F? With use of big data and advanced analytics Amazon is able to predict purchases before they happen
True
The "islands of data" problem in the 1980s describes the phenomenon of unconnected data being stored in numerous locations within an organization.
True
The hub-and-spoke data warehouse model uses a centralized warehouse feeding dependent data marts.
True
The overwhelming majority of competitive actions taken by businesses today feature computerized information system support
True
Volume velocity and variety of data characterize the Big Data paradigm
True
Walmart uses big data analytics to link the entire chain from buy to sell
True
Without middleware, different BI programs cannot easily connect to the data warehouse.
True
