TEST BANK FOR BUSINESS ANALYTICS,
5TH EDITION BY JEFFREY D. CAMM
In the Isle of Capri case, the only capability added by the new software was increased processing
speed of processing reports. (T/F) - (ANSWER)F
Data warehouse administrators (DWAs) do not need strong business insight since they only
handle the technical aspect of the infrastructure. (T/F) - (ANSWER)F
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. - (ANSWER)decision
makers have unfettered access to all data in the warehouse.
,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 - (ANSWER)independent data mart
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. - (ANSWER)three tier architecture.
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 - (ANSWER)federated architecture
, 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 - (ANSWER)enterprise application integration
In which stage of extraction, transformation, and load (ETL) into a data warehouse are data
aggregated?
A)
extraction
B)
cleanse
5TH EDITION BY JEFFREY D. CAMM
In the Isle of Capri case, the only capability added by the new software was increased processing
speed of processing reports. (T/F) - (ANSWER)F
Data warehouse administrators (DWAs) do not need strong business insight since they only
handle the technical aspect of the infrastructure. (T/F) - (ANSWER)F
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. - (ANSWER)decision
makers have unfettered access to all data in the warehouse.
,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 - (ANSWER)independent data mart
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. - (ANSWER)three tier architecture.
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 - (ANSWER)federated architecture
, 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 - (ANSWER)enterprise application integration
In which stage of extraction, transformation, and load (ETL) into a data warehouse are data
aggregated?
A)
extraction
B)
cleanse
