isds 415 ch 3
Data warehouse administrators (DWAs) do not need strong business insight since they only handle the technical aspect of the infrastructure
false
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
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
What is the definition of a data warehouse (DW) in simple terms?
a pool of data produced to support decision making; it is also a repository of current and historical data of potential interest to managers throughout the organization.
What is the definition of a data mart?
a subset of a data warehouse, typically consisting of a single subject area (e.g., marketing, operations). Whereas a data warehouse combines databases across an entire enterprise, a data mart is usually smaller and focuses on a particular subject or department.
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
Oper marts are created when operational data needs to be analyzed A) linearly. B) in a dashboard. C) unidimensionally. D) multidimensionally.
d
Why is a performance management system superior to a performance measurement system? A) because performance measurement systems are only in their infancy B) because measurement automatically leads to problem solution C) because performance management systems cost more D) because measurement alone has little use without action
d
The three main types of data warehouses are data marts, operational ________, and enterprise data warehouses.
data stores
Performing extensive ________ to move data to the data warehouse may be a sign of poorly managed data and a fundamental lack of a coherent data management strategy.
extraction, transformation, and load (ETL)
Data warehouses are subsets of data marts.
false
Moving the data into a data warehouse is usually the easiest part of its creation.
false
OLTP systems are designed to handle ad hoc analysis and complex queries that deal with many data items.
false
Organizations seldom devote a lot of effort to creating metadata because it is not important for the effective use of data warehouses.
false
Most data warehouses are built using ________ database management systems to control and manage the data.
relational
Given that the size of data warehouses is expanding at an exponential rate, ________ is an important issue.
scalability
Online ________ is a term used for a transaction system that is primarily responsible for capturing and storing data related to day-to-day business functions such as ERP, CRM, SCM, and point of sale.
transaction processing
One way an operational data store differs from a data warehouse is the recency of their data.
true
With key performance indicators, driver KPIs have a significant effect on outcome KPIs, but the reverse is not necessarily true.
true
Without middleware, different BI programs cannot easily connect to the data warehouse
true
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
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) A) extended ASP. B) data cloud. C) data lake. D) relational database.
c
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
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 A) country of (data) origin. B) nature of the data. C) speed of data transfer. D) source of the data.
c
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
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
Data warehouses provide direct and indirect benefits to 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
________ modeling is a retrieval-based system that supports high-volume query access.
dimensional
