Test Bank for Business Intelligence 2 E 2nd Edition-

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