MIS 523 - Ch. 3
How does the use of cloud computing affect the scalability of a data warehouse?
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?
ROLAP
The "single version of the truth" embodied in a data warehouse such as Capri Casinos' means all of the following EXCEPT
decision makers have unfettered access to all data in the warehouse.
Which data warehouse architecture uses metadata from existing data warehouses to create a hybrid logical data warehouse comprised of data from the other warehouses?
federated architecture
All of the following statements about metadata are true EXCEPT
for most organizations, data warehouse metadata are an unnecessary expense.
All of the following are benefits of hosted data warehouses EXCEPT
greater control of data
Which data warehouse architecture uses a normalized relational warehouse that feeds multiple data marts?
hub-and-spoke data warehouse architecture
Data warehouses provide direct and indirect benefits to using organizations. Which of the following is an indirect benefit of data warehouses?
improved customer care
Which kind of data warehouse is created separately from the enterprise data warehouse by a department and not reliant on it for updates?
independent data mart
All of the following are true about in-database processing technology EXCEPT
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?
large numbers of users, including operational staffs
Which of the following BEST enables a data warehouse to handle complex queries and scale up to handle many more requests?
parallel processing
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
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?
star schema
Operational or transaction databases are product oriented, handling transactions that update the database. In contrast, data warehouses are
subject-oriented and nonvolatile
A Web client that connects to a Web server, which is in turn connected to a BI application server, is reflective of a
three tier architecture
In which stage of extraction, transformation, and load (ETL) into a data warehouse are data aggregated?
transformation
In which stage of extraction, transformation, and load (ETL) into a data warehouse are anomalies detected and corrected?
cleanse
When querying a dimensional database, a user went from summarized data to its underlying details. The function that served this purpose is
drill down
Which approach to data warehouse integration focuses more on sharing process functionality than data across systems?
enterprise application integration