Question 1

A corporate information factory (CIF)is a comprehensive view of organizational data in support of all user data requirements.

Accepted Answer

A) True 
 B)False

Question 2

The use of a set of graphical tools that provides users with multidimensional views of their data is called ________.

Accepted Answer

on-line an

Question 3

Discuss some of the characteristics of derived data.

Accepted Answer

Derived data have been selected,formatte

Question 4

Which of the following is true of data visualization?

Accepted Answer

A)  It is easier to observe trends and patterns in data. 
B)  Correlations and clusters in data can be easily identified. 
C)  It is often used in conjunction with data mining. 
D)  All of the above. 
A)  It is easier to observe trends and patterns in data. 
B)  Correlations and clusters in data can be easily identified. 
C)  It is often used in conjunction with data mining. 
D)  All of the above.

Question 5

A system that is used to run a business in real time,based on current data is called a(n)________ system.

Accepted Answer

The answer of A system that is used to run...

Question 6

The use of a set of graphical tools that provides users with multidimensional views of their data is called:

Accepted Answer

A)  on-line geometrical processing (OGP). 
B)  drill-down analysis. 
C)  on-line analytical processing (OLAP). 
D)  on-line datacube processing (ODP). 
A)  on-line geometrical processing (OGP). 
B)  drill-down analysis. 
C)  on-line analytical processing (OLAP). 
D)  on-line datacube processing (ODP).

Question 7

A separate data warehouse causes more contention for resources in an organization.

Accepted Answer

A) True 
 B)False

Question 8

Which of the following advances in information systems contributed to the emergence of data warehousing?

Accepted Answer

A)  Improvements in database technology, particularly the relational data model 
B)  Advances in computer hardware, especially affordable mass storage and parallel computer architectures 
C)  Advances in middleware products that enabled enterprise database connectivity across heterogeneous platforms 
D)  All of the above 
A)  Improvements in database technology, particularly the relational data model 
B)  Advances in computer hardware, especially affordable mass storage and parallel computer architectures 
C)  Advances in middleware products that enabled enterprise database connectivity across heterogeneous platforms 
D)  All of the above

Question 9

Discuss the history of data warehousing.

Accepted Answer

Several key advances in information syst

Question 10

Conformed dimensions allow users to do the following:

Accepted Answer

A)  share nonkey dimension data. 
B)  query across fact tables with consistency. 
C)  work on facts and business subjects for which all users have the same meaning. 
D)  all of the above. 
A)  share nonkey dimension data. 
B)  query across fact tables with consistency. 
C)  work on facts and business subjects for which all users have the same meaning. 
D)  all of the above.

Question 11

The status of data is the representation of the data after an event has occurred.

Accepted Answer

A) True 
 B)False

Question 12

When a dimension participates in a hierarchy,the database designer can normalize the dimension into a nested set of tables with 1:M relationships between them.

Accepted Answer

A) True 
 B)False

Question 13

A snowflake schema is usually heavily aggregated.

Accepted Answer

A) True 
 B)False

Question 14

An independent data mart is filled with data extracted from the operational environment without the benefit of a data warehouse.

Accepted Answer

A) True 
 B)False

Question 15

Drill-down involves analyzing a given set of data at a finer level of detail.

Accepted Answer

A) True 
 B)False

Question 16

Informational systems are designed for all of the following EXCEPT:

Accepted Answer

A)  running a business in real time. 
B)  supporting decision making. 
C)  complex queries. 
D)  data mining. 
A)  running a business in real time. 
B)  supporting decision making. 
C)  complex queries. 
D)  data mining.

Question 17

Data that have been selected,formatted,and aggregated for end users are called ________ data.

Accepted Answer

The answer of Data that have been selected,formatted,and aggregated for...

Question 18

Explain the difference between operational and informational systems as well as the primary factors that contribute to the need for separation.

Accepted Answer

An operational system is built to run a

Question 19

Logical data marts are physically separate databases from the enterprise data warehouse.

Accepted Answer

A) True 
 B)False

Question 20

All of the following are some beneficial applications for real-time data warehousing EXCEPT:

Accepted Answer

A)  just-in-time transportation. 
B)  e-commerce. For example, an abandoned shopping cart can trigger an email promotional message. 
C)  fraud detection in credit card transactions. 
D)  data entry. 
A)  just-in-time transportation. 
B)  e-commerce. For example, an abandoned shopping cart can trigger an email promotional message. 
C)  fraud detection in credit card transactions. 
D)  data entry.

A corporate information factory (CIF)is a comprehensive view of organizational data in support of all user data requirements.

The use of a set of graphical tools that provides users with multidimensional views of their data is called ________.

Discuss some of the characteristics of derived data.

Which of the following is true of data visualization?

A system that is used to run a business in real time,based on current data is called a(n)________ system.

The use of a set of graphical tools that provides users with multidimensional views of their data is called:

A separate data warehouse causes more contention for resources in an organization.

Which of the following advances in information systems contributed to the emergence of data warehousing?

Discuss the history of data warehousing.

Conformed dimensions allow users to do the following:

The status of data is the representation of the data after an event has occurred.

When a dimension participates in a hierarchy,the database designer can normalize the dimension into a nested set of tables with 1:M relationships between them.

A snowflake schema is usually heavily aggregated.

An independent data mart is filled with data extracted from the operational environment without the benefit of a data warehouse.

Drill-down involves analyzing a given set of data at a finer level of detail.

Informational systems are designed for all of the following EXCEPT:

Data that have been selected,formatted,and aggregated for end users are called ________ data.

Explain the difference between operational and informational systems as well as the primary factors that contribute to the need for separation.

Logical data marts are physically separate databases from the enterprise data warehouse.

All of the following are some beneficial applications for real-time data warehousing EXCEPT:

The Database Environment and Development Process

Modeling Data in the Organization

The Enhanced E-R Model and Business Rules

Logical Database Design and the Relational Model

Physical Database Design and Performance

Introduction to SQL

Advanced SQL

Database Application Development

Data Quality and Integration

Data and Database Administration

Distributed Databases

Object-Oriented Data Modeling

Using Relational Databases to Provide Object Persistence

Filters

Exam 9: Data Warehousing

A corporate information factory (CIF)is a comprehensive view of organizational data in support of all user data requirements.

The use of a set of graphical tools that provides users with multidimensional views of their data is called ________.

Discuss some of the characteristics of derived data.

Which of the following is true of data visualization?

A system that is used to run a business in real time,based on current data is called a(n)________ system.

The use of a set of graphical tools that provides users with multidimensional views of their data is called:

A separate data warehouse causes more contention for resources in an organization.

Which of the following advances in information systems contributed to the emergence of data warehousing?

Discuss the history of data warehousing.

Conformed dimensions allow users to do the following:

The status of data is the representation of the data after an event has occurred.

When a dimension participates in a hierarchy,the database designer can normalize the dimension into a nested set of tables with 1:M relationships between them.

A snowflake schema is usually heavily aggregated.

An independent data mart is filled with data extracted from the operational environment without the benefit of a data warehouse.

Drill-down involves analyzing a given set of data at a finer level of detail.

Informational systems are designed for all of the following EXCEPT:

Data that have been selected,formatted,and aggregated for end users are called ________ data.

Explain the difference between operational and informational systems as well as the primary factors that contribute to the need for separation.

Logical data marts are physically separate databases from the enterprise data warehouse.

All of the following are some beneficial applications for real-time data warehousing EXCEPT:

The Database Environment and Development Process

Modeling Data in the Organization

The Enhanced E-R Model and Business Rules

Logical Database Design and the Relational Model

Physical Database Design and Performance

Introduction to SQL

Advanced SQL

Database Application Development

Data Quality and Integration

Data and Database Administration

Distributed Databases

Object-Oriented Data Modeling

Using Relational Databases to Provide Object Persistence

Filters