Exam 8: Data Warehousing

It is important to identify the right level of ________ that will be needed during the scoping of a data warehouse project.A low level of that will result in more data being stored in the warehouse.

Free

(Short Answer)

4.9/5

(38)

Question 1

Correct Answer:

Verified

granularity

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.

Free

(True/False)

4.8/5

(35)

Question 2

Correct Answer:

Verified

True

List 5 factors that potentially affect the architecture selection decision.

Free

(Essay)

4.8/5

(36)

Question 3

Correct Answer:

Verified

1.Information interdependence between organizational units
2.Upper management's information needs
3.Urgency of need for a data warehouse
4.Nature of end-user tasks
5.Constraints on resources
6.Strategic view of the data warehouse prior to implementation
7.Compatibility with existing systems
8.Perceived ability of the in-house IT staff 9.Technical Issues
10.Social/political factors

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 ________.

(Multiple Choice)

4.8/5

(34)

Question 4

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

(True/False)

4.8/5

(26)

Question 5

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?

(Multiple Choice)

4.7/5

(34)

Question 6

________ is a small data warehouse designed for a strategic business unit (SBU)or a department.

(Short Answer)

4.8/5

(39)

Question 7

Describe various issues that affect whether an organization will purchase data transformation tools or build the transformation process itself.

(Essay)

4.9/5

(39)

Question 8

The ________ is a concession to the natural forces that undermine the best plans for developing a perfect system.It uses all possible means to integrate analytical resources from multiple sources to meet changing needs or business conditions.

(Short Answer)

4.9/5

(36)

Question 9

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.

(True/False)

4.8/5

(30)

Question 10

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.

(True/False)

4.8/5

(32)

Question 11

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

(Multiple Choice)

4.9/5

(41)

Question 12

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

(True/False)

4.8/5

(34)

Question 13

During data modeling,expertise is required to determine what data are needed,define business rules associated with the data,and decide what ________ and other calculations may be necessary.

(Short Answer)

4.8/5

(27)

Question 14

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

(Multiple Choice)

4.8/5

(31)

Question 15

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

(True/False)

4.8/5

(37)

Question 16

List five benefits of a hosted data warehouse.

(Essay)

4.8/5

(36)

Question 17

Describe various integration technologies that enable data and metadata integration.

(Essay)

4.8/5

(41)

Question 18

An ________ is a large-scale data warehouse that is utilized across the enterprise for decision support.

(Short Answer)

4.8/5

(38)

Question 19

________ is a subset that is created directly from the data warehouse.It has the advantages of using a consistent data model and providing quality data.

(Short Answer)

4.9/5

(37)

Question 20

Showing 1 - 20 of 69

It is important to identify the right level of ________ that will be needed during the scoping of a data warehouse project.A low level of that will result in more data being stored in the warehouse.

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.

List 5 factors that potentially affect the architecture selection decision.

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 ________.

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

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?

________ is a small data warehouse designed for a strategic business unit (SBU)or a department.

Describe various issues that affect whether an organization will purchase data transformation tools or build the transformation process itself.

The ________ is a concession to the natural forces that undermine the best plans for developing a perfect system.It uses all possible means to integrate analytical resources from multiple sources to meet changing needs or business conditions.

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.

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.

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

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

During data modeling,expertise is required to determine what data are needed,define business rules associated with the data,and decide what ________ and other calculations may be necessary.

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

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

List five benefits of a hosted data warehouse.

Describe various integration technologies that enable data and metadata integration.

An ________ is a large-scale data warehouse that is utilized across the enterprise for decision support.

________ is a subset that is created directly from the data warehouse.It has the advantages of using a consistent data model and providing quality data.

Decision Support Systems and Business Intelligence

Decision Making, Systems, Modeling, and Support

Decision Support Systems Concepts, Methodologies, and Technologies:

Modeling and Analysis

Data Mining for Business Intelligence

Artificial Neural Networks for Data Mining

Text and Web Mining

Business Performance Management

Collaborative Computer-Supported Technologies and

Knowledge Management

Artificial Intelligence and Expert Systems

Advanced Intelligent Systems

Management Support Systems: Emerging Trends and Impacts

Filters