Test Bank for Business Intelligence 2 E
2nd Edition- 2022- 2023
Before implementing an active data warehouse solution, DirecTV pulled data from the
server
every night in batch mode, a process that was taking too long and straining the system.
- Answer-True
A data warehouse differs from an operational database in that most data warehouses
have a
product orientation and are designed to handle transactions that update the database. -
Answer-False
A real-time data warehouse together with a decision support system that leverages
integrated data can provide significant financial benefits for an organization. - Answer-
True
A data warehouse maintains historical data that do not necessarily provide current
status,
except in real-time systems - Answer-True
Once the data are entered into the data warehouse, users cannot change or update the
data - Answer-True
There are three main types of data warehouses, which are data marts, operational data
stores,
and enterprise data warehouses. - Answer-True
An independent data mart is a small warehouse designed for a strategic business unit
(SBU) or
a department whose source is an EDW. - Answer-False
Operational data store is used for the medium- and long-term decisions associated with
the
enterprise data warehouse (EDW). - Answer-False
The data for an oper mart come from an ODS. - Answer-True
Effectiveness, extensibility, reusability, interoperability, efficiency and performance,
evolution, entitlement, flexibility, segregation, user interface, versioning, versatility, and
low
maintenance cost are some of the key requirements for building a successful metadata-
driven
, enterprise - Answer-True
There are several levels of metadata management maturity that describe where an
organization is in terms of how and how well it uses its metadata. - Answer-True
There are ethical considerations involved in the collection and ownership of the
information
contained in metadata, including privacy and intellectual property issues. - Answer-True
There are many metaware tools that business users can use to access data stored in
the data
repositories, including data mining, reporting tools, and data visualization. - Answer-
False
In a three-tier architecture, operational systems contain the data and the software for
data
acquisition in the first tier, the data warehouse is a second tier, and the third tier
includes the
DSS/BI/BA engine. - Answer-True
The centralized data warehouse helps to simplify data management and administration
and reduce data redundancy. - Answer-False
Because of performance and data quality issues, most experts agree that federated
approaches work well to replace data warehouses. - Answer-False
According to conventional wisdom, independent data marts are a poor architectural
solution. - Answer-True
ETL tools transport data between sources and targets, document how data elements
change
as they move between source and target, exchange metadata with other applications,
and
administer all runtime processes and operations. - Answer-True
A hosted data warehouse has less functionality than an onsite data warehouse, but it
does not
consume computer resources on client premises for computer upgrades, software
licenses, in-house development, and in-house support and maintenance. - Answer-
False
A data warehouse needs to support scalability, which pertains to the amount of data in
the
warehouse, how quickly the warehouse is expected to grow, the number of concurrent
users, and the complexity of user queries. - Answer-True
2nd Edition- 2022- 2023
Before implementing an active data warehouse solution, DirecTV pulled data from the
server
every night in batch mode, a process that was taking too long and straining the system.
- Answer-True
A data warehouse differs from an operational database in that most data warehouses
have a
product orientation and are designed to handle transactions that update the database. -
Answer-False
A real-time data warehouse together with a decision support system that leverages
integrated data can provide significant financial benefits for an organization. - Answer-
True
A data warehouse maintains historical data that do not necessarily provide current
status,
except in real-time systems - Answer-True
Once the data are entered into the data warehouse, users cannot change or update the
data - Answer-True
There are three main types of data warehouses, which are data marts, operational data
stores,
and enterprise data warehouses. - Answer-True
An independent data mart is a small warehouse designed for a strategic business unit
(SBU) or
a department whose source is an EDW. - Answer-False
Operational data store is used for the medium- and long-term decisions associated with
the
enterprise data warehouse (EDW). - Answer-False
The data for an oper mart come from an ODS. - Answer-True
Effectiveness, extensibility, reusability, interoperability, efficiency and performance,
evolution, entitlement, flexibility, segregation, user interface, versioning, versatility, and
low
maintenance cost are some of the key requirements for building a successful metadata-
driven
, enterprise - Answer-True
There are several levels of metadata management maturity that describe where an
organization is in terms of how and how well it uses its metadata. - Answer-True
There are ethical considerations involved in the collection and ownership of the
information
contained in metadata, including privacy and intellectual property issues. - Answer-True
There are many metaware tools that business users can use to access data stored in
the data
repositories, including data mining, reporting tools, and data visualization. - Answer-
False
In a three-tier architecture, operational systems contain the data and the software for
data
acquisition in the first tier, the data warehouse is a second tier, and the third tier
includes the
DSS/BI/BA engine. - Answer-True
The centralized data warehouse helps to simplify data management and administration
and reduce data redundancy. - Answer-False
Because of performance and data quality issues, most experts agree that federated
approaches work well to replace data warehouses. - Answer-False
According to conventional wisdom, independent data marts are a poor architectural
solution. - Answer-True
ETL tools transport data between sources and targets, document how data elements
change
as they move between source and target, exchange metadata with other applications,
and
administer all runtime processes and operations. - Answer-True
A hosted data warehouse has less functionality than an onsite data warehouse, but it
does not
consume computer resources on client premises for computer upgrades, software
licenses, in-house development, and in-house support and maintenance. - Answer-
False
A data warehouse needs to support scalability, which pertains to the amount of data in
the
warehouse, how quickly the warehouse is expected to grow, the number of concurrent
users, and the complexity of user queries. - Answer-True
