Question 1

What is data mining and what are its goals?

Accepted Answer

Data mining is knowledge discovery using...

Question 2

An operational data store typically holds a history of snapshots of the state of an organization whereas an enterprise data warehouse does not typically contain history.

Accepted Answer

A) True 
 B)False

Question 3

A data warehouse of limited scope and size,fed by an enterprise data warehouse,is called a(n)________.

Accepted Answer

The answer of A data warehouse of limited scope and...

Question 4

What is the surrogate key rule for the Star schema and what are the main reasons for this rule?

Accepted Answer

Each and every key used to join the fact...

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

A system that is used to support decision making based on stable,point-in-time or historical data is called a(n)________ system.

Accepted Answer

informational

Question 7

Data visualization is the representation of data in ________ and ________ formats for human analysis.

Accepted Answer

graphical;...

Question 8

Discuss the three-layer data architecture.

Accepted Answer

The three-layer data architecture descri...

Question 9

Rule discovery searches for patterns and correlations in large data sets.

Accepted Answer

A) True 
 B)False

Question 10

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.E) All of the above
F) C) and D)

Question 11

An enterprise data warehouse that accepts near-real time feeds of transactional data and immediately transforms and loads the appropriate data is called a real-time data warehouse.

Accepted Answer

A) True 
 B)False  True

Question 12

A data mart is a data warehouse that contains data that can be used across the entire organization.

Accepted Answer

A) True 
 B)False

Question 13

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.E) A) and C)
F) A) and D)

Question 14

Discuss the difference between transient data and periodic data.

Accepted Answer

Transient data are data in whi...

Question 15

Explain a situation where multiple fact tables may be necessary.

Accepted Answer

Multiple fact tables are useful in situa...

Question 16

An operational data store is typically a relational database and normalized,but it is tuned for decision-making applications.

Accepted Answer

A) True 
 B)False

Question 17

All of the following are ways to handle changing dimensions EXCEPT:

Accepted Answer

A)   overwrite the current value with the new value.
B)   for each dimension attribute that changes, create a current value field and as many old value fields as we wish.
C)   create a new dimension table row each time the dimension object changes.
D)   create a snowflake schema.E) None of the above
F) A) and D)

Question 18

Rotating the view of a multidimensional database for a particular data point is called data:

Accepted Answer

A)   cubing.
B)   drill-down.
C)   dicing.
D)   pivoting.E) All of the above
F) A) and B)

Question 19

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)   none of the above.E) C) and D)
F) A) and B) B

Question 20

A(n)________ data mart is filled exclusively from the enterprise data warehouse and its reconciled data.

Accepted Answer

The answer of A(n)________ data mart is filled exclusively from...

Exam 9: Data Warehousing

What is data mining and what are its goals?

Correct AnswerverifiedData mining is knowledge discovery using...View AnswerShow Answer

An operational data store typically holds a history of snapshots of the state of an organization whereas an enterprise data warehouse does not typically contain history.

Correct AnswerverifiedShow Answer

A data warehouse of limited scope and size,fed by an enterprise data warehouse,is called a(n)________.

Correct AnswerverifiedShow Answer

What is the surrogate key rule for the Star schema and what are the main reasons for this rule?

Correct AnswerverifiedEach and every key used to join the fact...View AnswerShow Answer

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

Correct AnswerverifiedShow Answer

A system that is used to support decision making based on stable,point-in-time or historical data is called a(n)________ system.

Correct Answerverifiedinformational

Data visualization is the representation of data in ________ and ________ formats for human analysis.

Correct Answerverifiedgraphical;...View AnswerShow Answer

Discuss the three-layer data architecture.

Correct AnswerverifiedThe three-layer data architecture descri...View AnswerShow Answer

Rule discovery searches for patterns and correlations in large data sets.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

An enterprise data warehouse that accepts near-real time feeds of transactional data and immediately transforms and loads the appropriate data is called a real-time data warehouse.

Correct AnswerverifiedTrue

A data mart is a data warehouse that contains data that can be used across the entire organization.

Correct AnswerverifiedShow Answer

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:

Correct AnswerverifiedShow Answer

Discuss the difference between transient data and periodic data.

Correct AnswerverifiedTransient data are data in whi...View AnswerShow Answer

Explain a situation where multiple fact tables may be necessary.

Correct AnswerverifiedMultiple fact tables are useful in situa...View AnswerShow Answer

An operational data store is typically a relational database and normalized,but it is tuned for decision-making applications.

Correct AnswerverifiedShow Answer

All of the following are ways to handle changing dimensions EXCEPT:

Correct AnswerverifiedShow Answer

Rotating the view of a multidimensional database for a particular data point is called data:

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedB

A(n)________ data mart is filled exclusively from the enterprise data warehouse and its reconciled data.

Correct AnswerverifiedShow Answer

Correct Answer
verified
Data mining is knowledge discovery using...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
Each and every key used to join the fact...
View Answer

Correct Answer
verified

Correct Answer
verified
informational

Data visualization is the representation of data in and formats for human analysis.

Correct Answer
verified
graphical;...
View Answer

Correct Answer
verified
The three-layer data architecture descri...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
True

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
Transient data are data in whi...
View Answer

Correct Answer
verified
Multiple fact tables are useful in situa...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
B

Correct Answer
verified