Data Warehousing Mining Questions & Answers: part1



Software Programming : Data Warehousing Mining QUESTIONS AND ANSWERS :: part1 : 1 to 5

Following Software Programming language Entrance Multiple choice objective type questions and answers will help you in Software Programming 2015 examinations :

1.Which of the following process includes data cleaning, data integration, data selection, data transformation, data mining, pattern evolution and knowledge presentation?

KDD process
ETL process
KTL process
MDX process
None of the above.

2.A warehouse architect is trying to determine what data must be included in the warehouse. A meeting has been arranged with a business analyst to understand the data requirements, which of the following should be included in the agenda?

Number of users
Corporate objectives
Database design
Routine reporting
Budget.

3.Data modeling technique used for data marts is

Dimensional modeling
ER ? model
Extended ER ? model
Physical model
Logical model.

4.Which of the following employees data mining techniques to analyze the intent of a user query, provided additional generalized or associated information relevant to the query?

Iceberg query method
Data analyzer
Intelligent query answering
DBA
Query parser.

5.Which of the following statements is true?

A fact table describes the transactions stored in a DWH
A fact table describes the granularity of data held in a DWH
The fact table of a data warehouse is the main store of descriptions of the transactions stored in a DWH
The fact table of a data warehouse is the main store of all of the recorded transactions over time
A fact table maintains the old records of the database.

More Data Warehousing Mining QUESTIONS AND ANSWERS available in next pages

    Health is the greatest gift, contentment is the greatest wealth -Buddha