Databases - Upwork

Question: Which of the following would be the only similarity between a datawarehouse and OLTP system?
A
Purpose

B
Structure of data

C
Type of data

D
Condition of data

E
Data model

Note: Not available
1. Report
Question: Which of the following is not true regarding the process of Data Mining?
A
Software techniques are used for finding patterns and regularities in sets of data

B
It is the computer that is responsible for finding the patterns by identifying the underlying rules and features in the data

C
Data mining analysis tends to work from the data up

D
The best techniques are those developed with an orientation towards small volumes of data

E
The analysis process starts with a set of data, uses a methodology to develop an optimal representation of the structure of the data, during which time knowledge is acquired

Note: Not available
1. Report
Question: Data quality management refers to the fact that:
A
Ad-hoc analysis must not be slowed or inhibited by the performance of the data warehouse RDBMS

B
The warehouse must ensure local consistency, global consistency, and referential integrity

C
The RDBMS server must support hundreds, even thousands, of concurrent users while maintaining acceptable query performance

D
The server must include tools that co-ordinate the movement of subsets of data between warehouses

E
The RDBMS must provide a complete set of analytic operations including core sequential and statistical operations

Note: Not available
1. Report
Question: Which of the following stage is concerned with the extraction of patterns from the data?
A
Selection

B
Pre-processing

C
Transformation

D
Data Mining

E
Interpretation and Evaluation

Note: Not available
1. Report
Question: The Metadata of the data warehouse should at least contain:
A
The structure of the data

B
The algorithm used for summarisation

C
The mapping from the operational environment to the data warehouse and the algorithm used for summarisation

D
The structure of the data and the algorithm used for summarisation

E
The structure of the data, the algorithm used for summarisation and the mapping from the operational environment to the data warehouse and the algorithm used for summarisation

Note: Not available
1. Report
Question: Which of the following features are required by OLAP applications?
A
Multidimensional views of data

B
Calculation-intensive capabilities

C
Time intelligence

D
Multidimensional views of data and Calculation-intensive capabilities

E
Calculation-intensive capabilities and Time intelligence

Note: Not available
1. Report
Question: Data Mining is also known as
A
Data Extraction

B
Data Cleansing

C
Data Archiving

D
Knowledge Discovery in Databases (KDD)

E
Data Preservation

Note: Not available
1. Report
Question: Given the following steps between raw data and extracted knowledge, arrange them in the correct order: 1 Data mining 2 Transformation 3 Selection 4 Pre-processing 5 Interpretation and Evaluation
A
3,4,2,1,5

B
4,3,2,1,5

C
4,2,1,3,5

D
4,1,2,3,5

E
3,4,1,2,5

Note: Not available
1. Report
Question: The data warehouse is typically a large database on a high performance SMP system. Here SMP stands for:
A
Symmetric Multi-Processing

B
Superior Multi-Processing

C
Systematic Massive Processing

D
Symmetric Massive Processing

E
Systematic Multi-Processing

Note: Not available
1. Report
Question: The main impetus behind data warehousing was:
A
To discover means to reduce the data volumes

B
To make OLTP systems work faster

C
To reduce human interaction with database systems

D
To access corporate knowledge repositories based on huge databases to make sound business decisions

E
To standardise the database products used

Note: Not available
1. Report

First Prev 19 20 21 22 23 Next Last

Question: Which of the following would be the only similarity between a datawarehouse and OLTP system?

Question: Which of the following is not true regarding the process of Data Mining?

Question: Data quality management refers to the fact that:

Question: Which of the following stage is concerned with the extraction of patterns from the data?

Question: The Metadata of the data warehouse should at least contain:

Question: Which of the following features are required by OLAP applications?

Question: Data Mining is also known as

Question: Given the following steps between raw data and extracted knowledge, arrange them in the correct order: 1 Data mining 2 Transformation 3 Selection 4 Pre-processing 5 Interpretation and Evaluation

Question: The data warehouse is typically a large database on a high performance SMP system. Here SMP stands for:

Question: The main impetus behind data warehousing was: