Business Intelligence (CH3)

Data warehouse administrators (DWAs) do not need strong business insight since they only handle the technical aspect of the infrastructure. (T/F)

F

In the Isle of Capri case, the only capability added by the new software was increased processing speed of processing reports. (T/F)

F

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) Cloud vendors are mostly based overseas where the cost of labor is low. C) Cloud computing has little effect on a data warehouse's scalability. D) Hardware resources are dynamically allocated as use increases.

Hardware resources are dynamically allocated as use increases.

Which of the following online analytical processing (OLAP) technologies does NOT require the precomputation and storage of information? A) SQL B) HOLAP C) MOLAP D) ROLAP

ROLAP

The three main types of data warehouses are data marts, operational ________, and enterprise data warehouses.

data stores

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) hub-and-spoke data warehouse architecture C) centralized data warehouse architecture D) federated architecture

federated architecture

All of the following are benefits of hosted data warehouses EXCEPT A) greater control of data. B) smaller upfront investment. C) better quality hardware. D) frees up in-house systems.

greater control of data.

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

improved customer service

Which kind of data warehouse is created separately from the enterprise data warehouse by a department and not reliant on it for updates? A) independent data mart B) sectional data mart C) volatile data mart D) public data mart

independent data mart

All of the following are true about in-database processing technology EXCEPT A) it is the same as in-memory storage technology. B) it is often used for apps like credit card fraud detection and investment risk management. C) it makes the response to queries much faster than conventional databases. D) it pushes the algorithms to where the data is.

it is the same as in-memory storage technology.

Which of the following statements is more descriptive of active data warehouses in contrast with traditional data warehouses? A) restrictive reporting with daily and weekly data currency B) large numbers of users, including operational staffs C) detailed data available for strategic use only D) strategic decisions whose impacts are hard to measure

large numbers of users, including operational staffs

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) nature of the data. B) speed of data transfer. C) country of (data) origin. D) source of the data.

speed of data transfer.

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

star schema

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.

three tier architecture.

In which stage of extraction, transformation, and load (ETL) into a data warehouse are data aggregated? A) extraction B) cleanse C) transformation D) load

transformation

In which stage of extraction, transformation, and load (ETL) into a data warehouse are anomalies detected and corrected? A) cleanse B) transformation C) load D) extraction

cleanse

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 get to use more dependable data for their decisions. C) decision makers have unfettered access to all data in the warehouse. D) decision makers have the same data available to support their decisions.

decision makers have unfettered access to all data in the warehouse.

________ Analytics answers questions like "what happened" or "Why did it happen".

descriptive

When querying a dimensional database, a user went from summarized data to its underlying details. The function that served this purpose is A) slice. B) dice. C) drill down. D) roll-up.

drill down.

Which approach to data warehouse integration focuses more on sharing process functionality than data across systems? A) extraction, transformation, and load B) enterprise function integration C) enterprise information integration D) enterprise application integration

enterprise application integration