Correct! The incorrect statement is number 3. Data must be integrated
so that a complete view of the business is visible.
No, this statement is False. Data must be integrated so that a complete
view of the business is visible.
Correct! Although this model delivers a tremendous amount of flexibility
to the individual department that owns a data mart, it risks the development
of conflicting, or at least inconsistent, definitions.
No, this statement is False. Although this model delivers a tremendous
amount of flexibility to the individual department that owns a data mart, it
risks the development of conflicting, or at least inconsistent, data definitions.
Correct! In warehouse development, keep in mind that your database
must be:
Scaleable: Data warehouses are capable of storing and managing enormous
volumes of transactional and summarized data. A data warehouse may grow by
an order of magnitude over time through the need to add new types of data
or because historical data must be retained on-line for long periods.
Manageable: The warehouse needs products that enable easy management,
such as Oracle Universal Server.
Available: The server must be robust, to ensure that the warehouse
is available whenever needed.
Extensible: It must be possible to add new types of transactional
data and introduce new aggregations and summarized data to a warehouse as
information requirements evolve through usage.
Flexible: The data access paths to detailed and summarized data must
be flexible to support multidimensional analysis, drill-down and true ad-hoc
querying.
Integrated: A data warehouse must be fully integrated with the existing
systems and operational environment so that data from multiple sources can
be loaded efficiently.
Incorrect. JAD sessions are used during requirements gathering and the
data discovery process.
|
In designing your data warehouse, keep in mind that it should
be:
Scaleable: Data warehouses are capable of storing and
managing enormous volumes of transactional and summarized data.
A data warehouse may grow by an order of magnitude over time through
the need to add new types of data or because historical data must
be retained online for long periods.
Manageable: The warehouse needs products that enable easy
management, such as Oracle Universal Server.
Available: The server must be robust, to ensure that the
warehouse is available whenever needed.
Extensible: It must be possible to add new types of transactional
data and introduce new aggregations and summarized data to a warehouse
as information requirements evolve through usage.
Flexible: The data access paths to detailed and summarized
data must be flexible to support multi-dimensional analysis, drill
down and true ad-hoc querying.
Integrated: A data warehouse must be fully integrated
with the existing systems and operational environment so that
data from multiple sources can be loaded efficiently.
|
|