Data Warehousing, Databases

Question: Changing the view of the data to a higher level of aggregation is known as:
A
Implosion

B
Drill down

C
Drill up

D
Synchronisation

E
Summarisation

Note: Not available
1. Report
Question: The movement of data from one environment to another is known as:
A
Data Migration

B
Normalization

C
Replication

D
Data Mining

E
Data Cleansing

Note: Not available
1. Report
Question: In which component of the enterprise is the data re-organised for analysis and information extracted from the data?
A
The Data Warehouse

B
The Data Mart

C
The Data Mine

D
The operational RDBMS

E
Metadata

Note: Not available
1. Report
Question: A means of extending the data accessible to the end user beyond that which is stored in the OLAP server is know as :
A
Consolidation

B
Multi Dimensional Analysis

C
Drill Down

D
Navigation

E
Reach through

Note: Not available
1. Report
Question: The logical organisation of data in a database is called:
A
Normalisation

B
Schema

C
View

D
Fact table

E
Dimension

Note: Not available
1. Report
Question: Which of the following type of data is most likely to be stored on some form of mass storage ?Which of the following type of data is most likely to be stored on some form of mass storage ?
A
Metadata

B
Highly summarised data

C
Lightly summarised data

D
Current detail data

E
Older detail data

Note: Not available
1. Report
Question: The requirement that the datawarehouse RDBMS server must support hundreds and thousands of concurrent users while maintaining an acceptable query performance is known as:
A
Terabyte Scalability

B
Load Performance

C
Mass User Scalability

D
Data Quality Management

E
Query Performance

Note: Not available
1. Report
Question: Metadata does not include:
A
The actual data

B
A description of tables and fields in the warehouse, including data types and the range of acceptable values

C
A similar description of tables and fields in the source databases, with a mapping of fields from the source to the warehouse

D
A description of how the data has been transformed, including formulae, formatting, currency conversion, and time aggregation

E
Information that is needed to support and manage the operation of the data warehouse

Note: Not available
1. Report
Question: The main objective of Data Mining is:
A
The safe storage of data

B
Elimination of errors from the data

C
Deleting data that is no longer important to the organization

D
The extraction of implicit, previously unknown, and potentially useful information from data

E
To help in the generation of reports for the management

Note: Not available
1. Report
Question: In the Discovery model of Data Mining, the emphasis is on which of the following?
A
The system automatically discovering important information hidden in the data

B
The user who is responsible for formulating the hypothesis and issuing the query on the data to affirm or negate the hypothesis

C
Volume of the data being examined

D
Timeliness of the data

E
Speed with which the data is examined

Note: Not available
1. Report

First Prev 3 4 5 6 7 Next Last

Question: Changing the view of the data to a higher level of aggregation is known as:

Question: The movement of data from one environment to another is known as:

Question: In which component of the enterprise is the data re-organised for analysis and information extracted from the data?

Question: A means of extending the data accessible to the end user beyond that which is stored in the OLAP server is know as :

Question: The logical organisation of data in a database is called:

Question: Which of the following type of data is most likely to be stored on some form of mass storage ?Which of the following type of data is most likely to be stored on some form of mass storage ?

Question: The requirement that the datawarehouse RDBMS server must support hundreds and thousands of concurrent users while maintaining an acceptable query performance is known as:

Question: Metadata does not include:

Question: The main objective of Data Mining is:

Question: In the Discovery model of Data Mining, the emphasis is on which of the following?