Question 1

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.

Accepted Answer

This is a correct statement about the three-tier architecture. The first tier contains operational systems, the second tier contains the data warehouse, and the third tier includes the DSS/BI/BA engine.

Question 2

Operational data store is used for the medium- and long-term decisions associated with the enterprise data warehouse (EDW).

Accepted Answer

An Operational Data Store (ODS) is used for operational reporting and as an interim area for data before it is sent to the Enterprise Data Warehouse (EDW) for longer-term storage and analysis. The EDW is what supports medium- and long-term decisions.

Question 3

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.

Accepted Answer

A data warehouse is designed to support business intelligence activities, such as analyzing trends and patterns in large amounts of data. It is not focused on handling transactions that update the database, which is the primary function of an operational database. Additionally, while an operational database typically contains current and up-to-date information, a data warehouse often stores historical data for analysis purposes.

Question 4

An operational data store (ODS)provides a fairly recent form of a customer information file (CIF),which is often used as an interim staging area for a data warehouse.

Accepted Answer

An operational data store (ODS) is a type of database that is often used as an interim staging area for a data warehouse. It serves as a repository for near real-time operational data that is used for various reporting and analysis purposes. In many ways, an ODS can be considered a form of a customer information file (CIF), as it stores detailed information about customers, products, and transactions.

Question 5

Because of performance and data quality issues,most experts agree that federated approaches work well to replace data warehouses.

Accepted Answer

While there are some advantages to federated approaches, they are not considered a replacement for data warehouses. Data warehouses are still essential for storing, organizing and analyzing large amounts of structured data. Federated approaches can complement data warehouses, allowing organizations to access data from distributed sources in real-time without compromising on data quality or performance.

Question 6

The centralized data warehouse helps to simplify data management and administration.

Accepted Answer

A centralized data warehouse can help to simplify data management and administration as it allows for all data to be stored in one place, making it easier to access, update, and manage. It also provides a single source of truth for the organization's data, reducing the risk of errors and inconsistencies.

Question 7

According to conventional wisdom,independent data marts are a poor architectural solution.

Accepted Answer

Independent data marts can lead to data inconsistency, redundancy, and increased maintenance effort. A better approach would be to have a centralized data warehouse that serves as the single source of truth for the organization's data needs.

Question 8

The design,creation,and use of metadata and its accompanying standards may involve ethical issues,including privacy and intellectual property issues.

Accepted Answer

Metadata and standards can contain personal information, leading to privacy concerns. Additionally, the use of metadata may involve intellectual property rights, which can raise ethical issues. These issues must be carefully considered when designing, creating, and using metadata and standards.

Question 9

An independent data mart is a small warehouse designed for a strategic business unit (SBU)or a department whose source is an EDW.

Accepted Answer

An independent data mart is designed for a specific department or business unit but it sources its data directly from internal or external data sources, not from an Enterprise Data Warehouse (EDW).

Question 10

A data warehouse maintains historical data that do not necessarily provide current status,except in real-time systems.

Accepted Answer

A data warehouse is designed to store historical data, often for analysis and reporting purposes, and may not be updated in real-time. Real-time systems, on the other hand, provide current status and timely access to data.

Question 11

An advantage of the hub-and-spoke data warehouse architecture is that they are easy to build.

Accepted Answer

Hub-and-spoke architectures are complex to design and implement, requiring careful planning and integration between the central hub and the various spokes.

Question 12

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.

Accepted Answer

A hosted data warehouse can offer comparable functionality to an onsite data warehouse, and its main advantage is indeed that it does not consume resources on client premises for upgrades, licenses, development, and support.

Question 13

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.

Accepted Answer

Scalability is an important requirement for a data warehouse to support the increasing amount of data, number of users, and complexity of queries. The warehouse should be able to expand as the data grows without affecting performance or functionality.

Question 14

There are five levels of metadata management maturity that can be used to describe where an organization is in terms of how and how well it utilizes its metadata.

Accepted Answer

This statement is true. The five levels of metadata management maturity model are: Initial, Managed, Defined, Quantitatively Managed, and Optimizing. These levels represent a progression from ad hoc management of metadata to using metadata as a strategic asset for the organization.

Question 15

There are many middleware tools that business users can use to access data stored in the data repositories,including data mining,reporting tools,and data visualization.

Accepted Answer

Middleware tools such as data mining, reporting tools, and data visualization enable business users to access data stored in data repositories.

Question 16

Data warehouses contain vast amounts of internal data but are limited because they do not contain external data.

Accepted Answer

Data warehouses can contain both internal and external data, depending on how they are set up and what data sources they are connected to. They are designed to consolidate data from various sources for reporting and analysis.

Question 17

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.

Accepted Answer

This is a correct statement about ETL tools.

Question 18

There are three main types of data warehouses,which are data marts,operational data stores,and enterprise data warehouses.

Accepted Answer

This statement is true. There are three main types of data warehouses, which are data marts, operational data stores, and enterprise data warehouses.

Question 19

Once the data are entered into the data warehouse,users cannot change or update the data.

Accepted Answer

Data in a data warehouse is typically in a format that is optimized for reporting and analysis, and is not meant to be changed or updated by users. Instead, users interact with the data through reporting and analysis tools that provide access to the data in the warehouse.

Question 20

A real-time data warehouse together with a decision support strategy that leverages the integrated data can provide significant financial benefits for an organization.

Accepted Answer

A real-time data warehouse allows for timely access to integrated data, and combining this with a decision support strategy can enable better decision-making and ultimately result in financial benefits for the organization.

Quiz 8: Data Warehousing