CIS 4093 Chapter 3

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.

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.

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

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.

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) In the Isle of Capri case, the only capability added by the new software was increased processing speed of processing reports.

Answer: FALSE

12) 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.

Answer: FALSE

13) The ETL process in data warehousing usually takes up a small portion of the time in a data-centric project.

Answer: FALSE

15) Large companies, especially those with revenue upwards of $500 million consistently reap substantial cost savings through the use of hosted data warehouses.

Answer: FALSE

16) OLTP systems are designed to handle ad hoc analysis and complex queries that deal with many data items.

Answer: FALSE

18) A well-designed data warehouse means that user requirements do not have to change as business needs change.

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

20) Because the recession has raised interest in low-cost open source software, it is now set to replace traditional enterprise software.

Answer: FALSE

3) Subject oriented databases for data warehousing are organized by detailed subjects such as disk drives, computers, and networks.

Answer: FALSE

4) Data warehouses are subsets of data marts.

Answer: FALSE

6) Organizations seldom devote a lot of effort to creating metadata because it is not important for the effective use of data warehouses.

Answer: FALSE

8) Two-tier data warehouse/BI infrastructures offer organizations more flexibility but cost more than three-tier ones.

Answer: FALSE

9) Moving the data into a data warehouse is usually the easiest part of its creation.

Answer: FALSE

10) The hub-and-spoke data warehouse model uses a centralized warehouse feeding dependent data marts.

Answer: TRUE

11) Because of performance and data quality issues, most experts agree that the federated architecture should supplement data warehouses, not replace them.

Answer: TRUE

14) In the Starwood Hotels case, up-to-date data and faster reporting helped hotel managers better manage their occupancy rates.

Answer: TRUE

17) The data warehousing maturity model consists of six stages: prenatal, infant, child, teenager, adult, and sage.

Answer: TRUE

2) The "islands of data" problem in the 1980s describes the phenomenon of unconnected data being stored in numerous locations within an organization.

Answer: TRUE

5) One way an operational data store differs from a data warehouse is the recency of their data.

Answer: TRUE

7) Without middleware, different BI programs cannot easily connect to the data warehouse.

Answer: TRUE

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

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

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

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.

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

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.

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.

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

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

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.