Question 1

The representation of data in a graphical format is called data mining.

Accepted Answer

A) True 
 B)False

Question 2

Which of the following data-mining techniques identifies clusters of observations with similar characteristics?

Accepted Answer

A)  Case reasoning 
B)  Rule discovery 
C)  Clustering and signal processing 
D)  Neural nets 
A)  Case reasoning 
B)  Rule discovery 
C)  Clustering and signal processing 
D)  Neural nets

Question 3

Discuss the limitations of the independent data mart architecture.

Accepted Answer

There are several limitations to the ind

Question 4

All of the following are limitations of the independent data mart EXCEPT:

Accepted Answer

A)  separate extraction, transformation, and loading processes are developed for each data mart. 
B)  data marts may not be consistent with one another. 
C)  there is no capability to drill down into greater detail in other data marts. 
D)  it is often more expedient to build a data mart than a data warehouse. 
A)  separate extraction, transformation, and loading processes are developed for each data mart. 
B)  data marts may not be consistent with one another. 
C)  there is no capability to drill down into greater detail in other data marts. 
D)  it is often more expedient to build a data mart than a data warehouse.

Question 5

Operational metadata are derived from the enterprise data model.

Accepted Answer

A) True 
 B)False

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

Grain and duration have a direct impact on the size of fact tables.

Accepted Answer

A) True 
 B)False

Question 8

An event is a database action that results from a transaction.

Accepted Answer

A) True 
 B)False

Question 9

What is the role of metadata in the three-layer data architecture?

Accepted Answer

Metadata describe other data. There are

Question 10

Grain and duration have a direct impact on the size of ________ tables.

Accepted Answer

A)  selection 
B)  grain 
C)  fact 
D)  figure 
A)  selection 
B)  grain 
C)  fact 
D)  figure

Question 11

Why are data mining applications growing rapidly?

Accepted Answer

Data mining applications are g

Question 12

Data that are detailed, current, and intended to be the single, authoritative source of all decision support applications are called ________ data.

Accepted Answer

A)  reconciled 
B)  subject 
C)  derived 
D)  detailed 
A)  reconciled 
B)  subject 
C)  derived 
D)  detailed

Question 13

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

Accepted Answer

A)  Increase in viruses and other computer threats. 
B)  Improvements in monitor technologies. 
C)  Advances in middleware products that enabled enterprise database connectivity across heterogeneous platforms. 
D)  The invention of the iPad. 
A)  Increase in viruses and other computer threats. 
B)  Improvements in monitor technologies. 
C)  Advances in middleware products that enabled enterprise database connectivity across heterogeneous platforms. 
D)  The invention of the iPad.

Question 14

An operational data store (ODS) is not designed for use by operational users.

Accepted Answer

A) True 
 B)False

Question 15

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.

Question 16

One characteristic of independent data marts is complexity for end users when they need to access data in separate data marts. This complexity is caused by not only having to access data from separate databases, but also from:

Accepted Answer

A)  the possibility of a new generation of inconsistent data systems, the data marts themselves. 
B)  lack of user training. 
C)  denormalized data. 
D)  incongruent data formats. 
A)  the possibility of a new generation of inconsistent data systems, the data marts themselves. 
B)  lack of user training. 
C)  denormalized data. 
D)  incongruent data formats.

Question 17

When we consider data in the data warehouse to be time-variant, we mean:

Accepted Answer

A)  that the time of storage varies. 
B)  data in the warehouse contain a time dimension so that they may be used to study trends and changes. 
C)  that there is a time delay between when data are posted and when we report on the data. 
D)  that time is relative. 
A)  that the time of storage varies. 
B)  data in the warehouse contain a time dimension so that they may be used to study trends and changes. 
C)  that there is a time delay between when data are posted and when we report on the data. 
D)  that time is relative.

Question 18

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 19

Transient data are never changed.

Accepted Answer

A) True 
 B)False

Question 20

The level of detail in a fact table determined by the intersection of all the components of the primary key, including all foreign keys and any other primary key elements, is called the:

Accepted Answer

A)  span. 
B)  grain. 
C)  selection. 
D)  aggregation. 
A)  span. 
B)  grain. 
C)  selection. 
D)  aggregation.

The representation of data in a graphical format is called data mining.

Which of the following data-mining techniques identifies clusters of observations with similar characteristics?

Discuss the limitations of the independent data mart architecture.

All of the following are limitations of the independent data mart EXCEPT:

Operational metadata are derived from the enterprise data model.

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

Grain and duration have a direct impact on the size of fact tables.

An event is a database action that results from a transaction.

What is the role of metadata in the three-layer data architecture?

Grain and duration have a direct impact on the size of ________ tables.

Why are data mining applications growing rapidly?

Data that are detailed, current, and intended to be the single, authoritative source of all decision support applications are called ________ data.

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

An operational data store (ODS) is not designed for use by operational users.

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

One characteristic of independent data marts is complexity for end users when they need to access data in separate data marts. This complexity is caused by not only having to access data from separate databases, but also from:

When we consider data in the data warehouse to be time-variant, we mean:

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

Transient data are never changed.

The level of detail in a fact table determined by the intersection of all the components of the primary key, including all foreign keys and any other primary key elements, is called the:

The Database Environment and Development Process

Modeling Data in the Organization

The Enhanced E-R Model

Logical Database Design and the Relational Model

Physical Database Design and Performance

Introduction to SQL

Advanced SQL

Database Application Development

Data Quality and Integration

Big Data and Analytics

Data and Database Administration

Distributed Databases

Object-Oriented Data Modeling

Filters

Exam 9: Data Warehousing

The representation of data in a graphical format is called data mining.

Which of the following data-mining techniques identifies clusters of observations with similar characteristics?

Discuss the limitations of the independent data mart architecture.

All of the following are limitations of the independent data mart EXCEPT:

Operational metadata are derived from the enterprise data model.

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

Grain and duration have a direct impact on the size of fact tables.

An event is a database action that results from a transaction.

What is the role of metadata in the three-layer data architecture?

Grain and duration have a direct impact on the size of ________ tables.

Why are data mining applications growing rapidly?

Data that are detailed, current, and intended to be the single, authoritative source of all decision support applications are called ________ data.

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

An operational data store (ODS) is not designed for use by operational users.

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

One characteristic of independent data marts is complexity for end users when they need to access data in separate data marts. This complexity is caused by not only having to access data from separate databases, but also from:

When we consider data in the data warehouse to be time-variant, we mean:

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

Transient data are never changed.

The level of detail in a fact table determined by the intersection of all the components of the primary key, including all foreign keys and any other primary key elements, is called the:

The Database Environment and Development Process

Modeling Data in the Organization

The Enhanced E-R Model

Logical Database Design and the Relational Model

Physical Database Design and Performance

Introduction to SQL

Advanced SQL

Database Application Development

Data Quality and Integration

Big Data and Analytics

Data and Database Administration

Distributed Databases

Object-Oriented Data Modeling

Filters