Data Warehouses Quiz

What is a good fit for OLAP and decision-support technologies?

• Network data model

• Multidimensional data model

• Relational data model

• Hierarchical data model

What is the main difference between data warehouses and transactional databases?

• Transactional databases support decision-support technologies

• Data warehouses support real-time data processing

• Transactional databases are nonvolatile

• Data warehouses are nonvolatile

What process handles warehouse insertions by doing a large amount of preprocessing?

• Data mining process

• Metadata process

• Backflushing process

• ETL (extract, transform, load) process

What is the main goal of data warehousing technologies?

• Enabling the knowledge worker to make better decisions

• Enabling real-time data processing

• Enabling transactional databases

• Enabling data mining processes

What is the term commonly used for intermediate form of databases before they are transformed into a data warehouse?

• Data mart

• Analytical data store (ADS)

• Operational data store (ODS)

• Data mining

What is the main characteristic of data warehouses that allows for unlimited dimensions and aggregation levels?

• Multidimensional conceptual view

• Client/server architecture

• Transparency

• Accessibility

What type of data warehouses are generally targeted to a subset of the organization, such as a department?

• Logical data warehouses

• Virtual data warehouses

• Enterprise-wide data warehouses

• Data marts

What is the term used for databases built for the purpose of conducting data analysis?

• Analytical data store (ADS)

• Operational data store (ODS)

• Data mart

• Data mining

What is the process of providing views of operational databases that are materialized for efficient access?

• Virtual data warehouses

• Enterprise-wide data warehouses

• Logical data warehouses

• Data marts

What is the main issue that has been dealt with through enterprise-wide data warehouses, virtual data warehouses, logical data warehouses, and data marts?

• Volume of data

• Data security

• Real-time processing

• Data mining techniques