Business analytics exam 2
Why is a performance management system superior to a performance measurement system?
because measurement alone has little use without action
A large storage location that can hold vast quantities of data (mostly unstructured) in its native/raw format for future/potential analytics consumption is referred to as a(n).
data lake
The three main types of data warehouses are?
data marts, operational Data stores, and enterprise data warehouses.
_____________ modeling is a retrieval based system that supports high volume query access.
dimesional
an _________________ data store (ODS) provides a fairly recent form of customer information file.
operational
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 .
speed of data transfer
BSC Performance Management System has a heavy emphasis on maximizing profitability. T or F?
False
Because the recession has raised interest in low-cost open source software, it is now set to replace traditional enterprise software. T or F?
False
Moving the data into a data warehouse is usually the easiest part of its creation? T or F?
False
OLTP systems are designed to handle ad hoc analysis and complex queries that deal with many data items T or F?
False
Properly integrating data from various databases and other disparate sources is a trivial process. T or F?
False
Subject oriented databases for data warehousing are organized by detailed subjects such as disk drives, computers, and networks. T or F?
False
User-initiated navigation of data through disaggregation is referred to as "drill up." T or F?
False
With the balanced scorecard approach, the entire focus is on measuring and managing specific financial goals based on the organization's strategy. T or F?
False
All of the following are benefits of hosted data warehouses EXCEPT
Greater control of data
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
KPIs have all of the following distinguish criteria, EXCEPT
Limits
The DMAIC performance improvement model all of the following steps, EXCEPT
Monitor
Operational or transaction databases are product oriented, handling transactions that update the database. In contrast, data warehouses are?
Subject originated and non volatile
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 arctachture
The "islands of data" problem in the 1980s describes the phenomenon of unconnected data being stored in numerous locations within an organization. T or F?
True
With key performance indicators, driver KPIs have a significant effect on outcome KPIs, but the reverse is not necessarily? T or F ?
True
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?
EAI
________ is an evolving tool space that promises real-time data integration from a variety of sources, such as relational databases, Web services, and multidimensional databases
EII
What is Six Sigma?
a methodology aimed at reducing the number of defects in a business process