Exam 3: Descriptive Analytics II: Business Intelligence and Data Warehousing

Real-time 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

The ________ data warehouse architecture involves integrating disparate systems and analytical resources from multiple sources to meet changing needs or business conditions.

Properly integrating data from various databases and other disparate sources is a trivial process.

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

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

Mehra (2005)indicated that few organizations really understand metadata,and fewer understand how to design and implement a metadata strategy.How would you describe metadata?

Which kind of data warehouse is created separately from the enterprise data warehouse by a department and not reliant on it for updates?

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

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

Oper marts are created when operational data needs to be analyzed

What is Six Sigma?

The BPM development cycle is essentially a one-shot process where the requirement is to get it right the first time.

Which data warehouse architecture uses metadata from existing data warehouses to create a hybrid logical data warehouse comprised of data from the other warehouses?

________,or "The Extended ASP Model," is a creative way of deploying information system applications where the provider licenses its applications to customers for use as a service on demand (usually over the Internet).

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

What is the definition of a data mart?

Which of the following BEST enables a data warehouse to handle complex queries and scale up to handle many more requests?

User-initiated navigation of data through disaggregation is referred to as "drill up."

________ (also called in-database analytics)refers to the integration of the algorithmic extent of data analytics into data warehouse.

________ is a mechanism that integrates application functionality and shares functionality (rather than data)across systems,thereby enabling flexibility and reuse.