DBMS Exam: Questions & Solutions (Guaranteed Pass!)
Advances in computer hardware, particularly the emergence of affordable
mass storage and parallel computer architectures, was one of the key
advances that led to the emergence of data warehousing. Right Ans - True
The development of the relational data model did not contribute to the
emergence of data warehousing. Right Ans - False
The need for data warehousing in an organization is driven by its need for an
integrated view of high-quality data. Right Ans - True
When multiple systems in an organization are synchronized, the need for data
warehousing increases. Right Ans - False
Informational systems are designed to support decision making based on
historical point-in-time and prediction data. Right Ans - True
A separate data warehouse causes more contention for resources in an
organization. Right Ans - False
Organizations adopt data mart architectures because it is easier to have
separate, small data warehouses than to get all organizational parties to agree
to one view of the organization in a central data warehouse. Right Ans -
True
An independent data mart is filled with data extracted from the operational
environment without the benefit of a data warehouse. Right Ans - True
A data mart is a data warehouse that contains data that can be used across the
entire organization. Right Ans - False
Independent data marts do not generally lead to redundant data and efforts.
Right Ans - False
An enterprise data warehouse is the control point and single source of all data
made available to end users for decision support applications. Right Ans -
True
Advances in computer hardware, particularly the emergence of affordable
mass storage and parallel computer architectures, was one of the key
advances that led to the emergence of data warehousing. Right Ans - True
The development of the relational data model did not contribute to the
emergence of data warehousing. Right Ans - False
The need for data warehousing in an organization is driven by its need for an
integrated view of high-quality data. Right Ans - True
When multiple systems in an organization are synchronized, the need for data
warehousing increases. Right Ans - False
Informational systems are designed to support decision making based on
historical point-in-time and prediction data. Right Ans - True
A separate data warehouse causes more contention for resources in an
organization. Right Ans - False
Organizations adopt data mart architectures because it is easier to have
separate, small data warehouses than to get all organizational parties to agree
to one view of the organization in a central data warehouse. Right Ans -
True
An independent data mart is filled with data extracted from the operational
environment without the benefit of a data warehouse. Right Ans - True
A data mart is a data warehouse that contains data that can be used across the
entire organization. Right Ans - False
Independent data marts do not generally lead to redundant data and efforts.
Right Ans - False
An enterprise data warehouse is the control point and single source of all data
made available to end users for decision support applications. Right Ans -
True
