Question 1

ETL process consists of extract, transform, and load. Transformation occurs by using ________ or lookup tables or by combining the data with other data.
A) rules
B) policies
C) strategies
D) procedures

Accepted Answer

Transformation in ETL process is done using rules or transformation rules which are defined based on the business logic or requirements. The rules are applied to the extracted data for converting it into the desired form before loading it into the target system. Lookup tables and data concatenation are also examples of rule-based transformations. Policies, strategies, and procedures are not typically used in ETL transformation process.

Question 2

Once data are entered into the warehouse, users cannot change or update the data. Obsolete data are discarded, and changes are recorded as new data. This ________ characteristic is one of the characteristics of data warehousing.
A) changeable
B) nonvolatile
C) nonperishable
D) static

Accepted Answer

The nonvolatile characteristic of data warehousing means that once data is entered, it cannot be changed or updated. Instead, any changes are recorded as new data, and obsolete data is discarded. This ensures the accuracy and consistency of the data in the warehouse.

Question 3

Which of the following are created when operational data need to be analyzed multidimensionally?
A) Oper marts
B) Customer information file
C) Dependent data marts
D) Independent data marts

Accepted Answer

Operational data marts (oper marts) are created when operational data needs to be analyzed multidimensionally. They typically focus on a specific business process or functional area and support operational decision-making. The other options, customer information file, dependent data marts, and independent data marts, are not necessarily created specifically for multidimensional analysis of operational data.

Question 4

The advantage of three-tier architecture for data warehousing is its separation of the functions of the data warehouse, which eliminates resource constraints and makes it possible to easily create data ________.
A) banks
B) cubes
C) bases
D) marts

Accepted Answer

Three-tier architecture separates the functions of the data warehouse into three layers: the data storage layer, the data access layer, and the data presentation layer. This separation makes it possible to easily create data marts, which are specialized subsets of the data warehouse that are designed to serve a specific business function or department. Therefore, the best choice is D (marts).

Question 5

Which of the following is one of the components of data warehousing process that enables users to access the data warehouse?
A) Middleware tools
B) Users interface
C) Query tools
D) OLAP

Accepted Answer

The answer of Which of the following is one of...

Question 6

Karacsony indicates that there is a direct correlation between the extent of ________ data and the amount of ETL processes. When data are managed correctly as an enterprise asset, ETL efforts are significantly reduced.
A) enormous
B) bad
C) redundant
D) wrong

Accepted Answer

When there is redundant data, meaning there are duplicates or unnecessary data, it can lead to more ETL (Extract, Transform, Load) processes to clean and organize the data. When data is managed correctly and duplicates are eliminated, ETL efforts are reduced. Therefore, the answer is C, redundant.

Question 7

When DirectTV decided to implement an active data warehouse solution, the goal of the new system was to send fresh data to the call center at least daily. Once the capabilities of the solutions became apparent, that goal:
A) dropped to fresh data of less than 15 minutes to improve responsiveness.
B) dropped to fresh data every 12 hours to improve responsiveness.
C) increased to every 2 days to reduce maintenance costs.
D) increased to every 5 days to reduce maintenance costs.

Accepted Answer

Once the capabilities of the active data warehouse solution became apparent, the goal of sending fresh data to the call center at least daily was increased to fresh data of less than 15 minutes to improve responsiveness. This indicates that the new system is capable of providing real-time data updates and can support more frequent updates.

Question 8

The ________ have inconsistent data definitions and different dimensions and measures, making it difficult to analyze data across those marts.
A) enterprise data marts
B) operational data marts
C) dependent data marts
D) independent data marts

Accepted Answer

Independent data marts often have inconsistent data definitions and different dimensions and measures because they are developed by different departments or units within an organization without central coordination, making it difficult to analyze data across those marts.

Question 9

Users demanding access via PDAs and through speech recognition and synthesis is becoming more commonplace, further complicating ________ issues.
A) data extraction
B) data load
C) data integration
D) OLAP

Accepted Answer

The increasing demand for access via PDAs and through speech recognition and synthesis creates challenges in integrating these diverse data sources into a single system. This is known as data integration, which involves combining data from different sources and formats to provide users with a unified view of the data. Data extraction refers to the process of retrieving data from different sources, while data load involves loading the data into a database or other system. OLAP (Online Analytical Processing) refers to software designed to help users analyze data and identify trends and patterns. While OLAP may be affected by the increased demand for access via PDAs and speech recognition, it is not as directly impacted as the process of integrating diverse data sources.

Question 10

A data warehouse contains ________ about how data are organized and how to use them effectively.
A) a data directory
B) a data index
C) data fields
D) metadata

Accepted Answer

Metadata is the data about the data in a data warehouse, including information about how the data are organized, their structure and relationships, and how to use them effectively. A data directory and a data index are specific types of metadata, while data fields refer to the individual pieces of data within the warehouse.

Question 11

Which of the following is not a direct benefit of a data warehouse?
A) End users can perform extensive analysis in numerous ways.
B) A consolidated view of the data provides a single version of the truth.
C) Simplified data access
D) Improved customer service and satisfaction

Accepted Answer

Improved customer service and satisfaction is not a direct benefit of a data warehouse. While a data warehouse can certainly contribute to improved customer service and satisfaction indirectly by providing better data for decision-making, it is not a direct benefit in and of itself. The other options listed are direct benefits of a data warehouse.

Question 12

Which of the following is not one of the failure factors in data warehousing?
A) Cultural issues are ignored.
B) inappropriate architecture
C) unrealistic expectations
D) high levels of data summarization

Accepted Answer

High levels of data summarization is not one of the failure factors in data warehousing. Cultural issues, inappropriate architecture, and unrealistic expectations all contribute to the potential failure of a data warehousing project.

Question 13

A star schema contains a central ________ surrounded by several dimension tables.
A) database
B) fact table
C) data tree
D) data table

Accepted Answer

A star schema is a type of data organization within a data warehouse. It includes a central fact table that contains the quantitative data to be analyzed and several dimension tables that provide context for the analysis. The fact table is therefore the central component of the schema.

Question 14

________ is a critical aspect of data warehousing that includes reconciling conflicting data definitions and formats organization-wide.
A) Data modification
B) Fact refinement
C) Data purification
D) Data cleansing

Accepted Answer

Data cleansing is the process of detecting and correcting or removing corrupt or inaccurate records from a database, and it is a critical aspect of data warehousing. This process includes reconciling conflicting data definitions and formats organization-wide to ensure that data is consistent, complete, and accurate.

Question 15

Guidelines that need to be considered when developing a vendor list include all of the following except:
A) financial strength
B) trade shows
C) ERP linkages
D) market share

Accepted Answer

Trade shows are not a typical consideration when developing a vendor list. Financial strength, ERP linkages, and market share are all important factors to consider when selecting vendors.

Question 16

The high cost of data warehouses limits their use to large companies. As an alternative, many firms use a lower-cost, scaled-down version of a data warehouse referred to as (an) ________.
A) data mart
B) operational data store
C) dependent data mart
D) independent data mart

Accepted Answer

The answer of The high cost of data warehouses limits...

Question 17

Which of the following is not a data source to a data warehouse?
A) ERP
B) Legacy
C) POS
D) ETL

Accepted Answer

ETL stands for extract, transform, and load, which is the process of retrieving data from a variety of sources, transforming it into a suitable format, and loading it into a data warehouse. Therefore, ETL is not a data source but a method used to transfer data into a data warehouse. ERP (Enterprise Resource Planning), Legacy (existing systems), and POS (Point of Sale) are all data sources that can provide data to a data warehouse.

Question 18

Which of the following is needed to determine how data are to be retrieved from a data warehouse, and will assist in the physical definition of the warehouse by helping to define which data require indexing?
A) Indexing modeling
B) Retrieval modeling
C) Access modeling
D) Tactic modeling

Accepted Answer

Access modeling is crucial for determining how data are to be retrieved from a data warehouse. It helps in the physical definition of the warehouse by identifying which data need indexing to optimize access and retrieval times.

Question 19

Data warehouse is a(n) ________, integrated, time-variant, nonvolatile collection of data in support of management's decision making process.
A) analysis-oriented
B) object-oriented
C) subject-oriented
D) model-oriented

Accepted Answer

Data warehouse is subject-oriented, meaning it focuses on a specific theme or subject area, rather than being organized around the operational requirements of an organization. The other options, namely analysis-oriented, object-oriented and model-oriented, do not accurately describe the nature of a data warehouse.

Question 20

Which of the following is an evolving tool space that promises real-time data integration from a variety of sources, such as relational databases, Web services, and multidimensional databases?
A) Information integration
B) Data management integration
C) SQL data integration
D) Enterprise information integration (EII)

Accepted Answer

Enterprise information integration (EII) is an evolving tool space that promises real-time data integration from a variety of sources, such as relational databases, Web services, and multidimensional databases. The other options are not accurate or comprehensive enough to be the correct answer.

Quiz 2: Data Warehousing

ETL process consists of extract, transform, and load. Transformation occurs by using ________ or lookup tables or by combining the data with other data.

Once data are entered into the warehouse, users cannot change or update the data. Obsolete data are discarded, and changes are recorded as new data. This ________ characteristic is one of the characteristics of data warehousing.

Which of the following are created when operational data need to be analyzed multidimensionally?

The advantage of three-tier architecture for data warehousing is its separation of the functions of the data warehouse, which eliminates resource constraints and makes it possible to easily create data ________.

Which of the following is one of the components of data warehousing process that enables users to access the data warehouse?

Karacsony indicates that there is a direct correlation between the extent of ________ data and the amount of ETL processes. When data are managed correctly as an enterprise asset, ETL efforts are significantly reduced.

When DirectTV decided to implement an active data warehouse solution, the goal of the new system was to send fresh data to the call center at least daily. Once the capabilities of the solutions became apparent, that goal:

The ________ have inconsistent data definitions and different dimensions and measures, making it difficult to analyze data across those marts.

Users demanding access via PDAs and through speech recognition and synthesis is becoming more commonplace, further complicating ________ issues.

A data warehouse contains ________ about how data are organized and how to use them effectively.

Which of the following is not a direct benefit of a data warehouse?

Which of the following is not one of the failure factors in data warehousing?

A star schema contains a central ________ surrounded by several dimension tables.

________ is a critical aspect of data warehousing that includes reconciling conflicting data definitions and formats organization-wide.

Guidelines that need to be considered when developing a vendor list include all of the following except:

The high cost of data warehouses limits their use to large companies. As an alternative, many firms use a lower-cost, scaled-down version of a data warehouse referred to as (an) ________.

Which of the following is not a data source to a data warehouse?

Which of the following is needed to determine how data are to be retrieved from a data warehouse, and will assist in the physical definition of the warehouse by helping to define which data require indexing?

Data warehouse is a(n) ________, integrated, time-variant, nonvolatile collection of data in support of management's decision making process.

Which of the following is an evolving tool space that promises real-time data integration from a variety of sources, such as relational databases, Web services, and multidimensional databases?