Data Warehousing, Databases

Question: Data Volatility describes:
A
The degree to which data and data structures change over time

B
The redundancy of the data

C
The volume of the data

D
The compactness of the data

E
The validity of the data

Note: Not available
1. Report
Question: A data warehouse is a "subject-oriented, integrated, time-variant, non-volatile collection of data in support of management's decision-making process". The term non-volatile means that:
A
The data is refreshed often

B
The data is backed up often

C
The data is deleted often

D
The data is rarely changed

E
The data is of low volume

Note: Not available
1. Report
Question: Which of the following is not true regarding an OLTP system?
A
OLTP is generally regarded as unsuitable for data warehousing

B
OLTP systems can be repositories of facts and historical data for business analysis

C
The purpose of an OLTP system is to run day-to-day operations

D
The Data Model of an OLTP system is normalised

E
OLTP offers large amounts of raw data

Note: Not available
1. Report
Question: A data warehouse includes data from various sources including legacy systems. Legacy systems implies:
A
Systems that have been developed at different times by different people for a variety of purposes

B
Systems which are no longer useful

C
Systems whose data is outdated

D
Systems whose technology is outdated

E
Systems whose data is corrupt

Note: Not available
1. Report
Question: A multi-dimensional data set is sparse if:
A
The data to be analysed is less in volume

B
If a relatively high percentage of the possible combinations (intersections) of the members from the data set's dimensions contain missing data

C
If a relatively high percentage of the possible combinations (intersections) of the members from the data set's dimensions contain invalid data

D
If a relatively high percentage of the possible combinations (intersections) of the members from the data set's dimensions contain valid data

E
If a relatively high percentage of the possible combinations (intersections) of the members from the data set's dimensions contain outdated data

Note: Not available
1. Report
Question: A data warehouse is a "subject-oriented, integrated, time-variant, non-volatile collection of data in support of management's decision-making process". The data within the warehouse is integrated in that:
A
Users from all departments help to create the database

B
Data from various departments is collected into the warehouse

C
The final product is a fusion of various legacy system information into a cohesive set of information

D
Every user has access to the data in the warehouse

E
It contains the data of the enterprise in its entirety

Note: Not available
1. Report
Question: Normalization applied to the dimension tables of a star schema is known as:
A
Snowflaking

B
Synchronization

C
Slicing and Dicing

D
Replication

E
Data transformation

Note: Not available
1. Report
Question: Replication refers to the:
A
Physical copying of data from one database to another

B
Cleansing of the data

C
Integration of data from various sources into the data warehouse

D
Analysis of the data

E
Recovery of data

Note: Not available
1. Report
Question: ROLAP stands for:
A
Recyclic On-line Analytical Processing

B
Relational On-line Analytical Processing

C
Reduced On-line Analytical Processing

D
Rotated On-line Analytical Processing

E
Redundant On-line Analytical Processing

Note: Not available
1. Report
Question: In a star schema, a table which contains data about one of the dimensions is called a:
A
Fact table

B
Meta table

C
Data Dictionary

D
Pivot table

E
Dimension table

Note: Not available
1. Report

First Prev 1 2 3 4 Next Last

Question: Data Volatility describes:

Question: A data warehouse is a "subject-oriented, integrated, time-variant, non-volatile collection of data in support of management's decision-making process". The term non-volatile means that:

Question: Which of the following is not true regarding an OLTP system?

Question: A data warehouse includes data from various sources including legacy systems. Legacy systems implies:

Question: A multi-dimensional data set is sparse if:

Question: A data warehouse is a "subject-oriented, integrated, time-variant, non-volatile collection of data in support of management's decision-making process". The data within the warehouse is integrated in that:

Question: Normalization applied to the dimension tables of a star schema is known as:

Question: Replication refers to the:

Question: ROLAP stands for:

Question: In a star schema, a table which contains data about one of the dimensions is called a: