Data Warehousing and Data Mining Set 1

Data Warehousing and Data Mining 

Questions 1 to 10




Set 1

Set 2

Set 3
1. Which of the following is the most important when deciding on the data structure of a data mart?
(a) XML data exchange standards
(b) Data access tools to be used
(c) Metadata naming conventions
(d) Extract, Transform, and Load (ETL) tool to be used
(e) All (a), (b), (c) and (d) above.

2. The process of removing the deficiencies and loopholes in the data is called as
(a) Aggregation of data
(b) Extracting of data
(c) Cleaning up of data.
(d) Loading of data
(e) Compression of data.

3. Which one manages both current and historic transactions?
(a) OLTP
(b) OLAP
(c) Spread sheet
(d) XML
(e) All (a), (b), (c) and (d) above.

4. Which of the following is the collection of data objects that are similar to one another within the same group?
(a) Partitioning
(b) Grid
(c) Cluster
(d) Table
(e) Data source.

5. 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?
(a) Iceberg query method
(b) Data analyzer
(c) Intelligent query answering 
(d) DBA
(e) Query parser.

6. Which of the following process includes data cleaning, data integration, data selection, data transformation, data mining, pattern evolution and knowledge presentation?
(a) KDD process
(b) ETL process
(c) KTL process
(d) MDX process
(e) None of the above.

7. At which level we can create dimensional models?
(a) Business requirements level
(b) Architecture models level
(c) Detailed models level
(d) Implementation level
(e) Testing level.

8. Which of the following is not related to dimension table attributes?
(a) Verbose
(b) Descriptive
(c) Equally unavailable
(d) Complete
(e) Indexed.

9. Data warehouse bus matrix is a combination of
(a) Dimensions and data marts
(b) Dimensions and facts
(c) Facts and data marts
(d) Dimensions and detailed facts
(e) All (a), (b), (c) and (d) above.

10. Which of the following is not the managing issue in the modeling process?
(a) Content of primary units column 
(b) Document each candidate data source
(c) Do regions report to zones
(d) Walk through business scenarios
(e) Ensure that the transaction edit flat is used for analysis.

Answers 


       Ans Reason
1. B Data access tools to be used when deciding on the data structure of a data mart.

2. C The process of removing the deficiencies and loopholes in the data is called as cleaning up of data.

3. B Online Analytical Processing (OLAP) manages both current and historic transactions.

4. C Cluster is the collection of data objects that are similar to one another within the same group.

5. C Intelligent Query Answering    employee’s data mining techniques to analyze the intent of a user query provided additional generalized or associated information relevant to the query.

6. A KDD Process includes data cleaning, data integration, data selection, data transformation, data mining, pattern evolution, and knowledge presentation.

7. B Dimensional models can be created at Architecture models level.

8. C Equally unavailable is not related to dimension table attributes.

9. A Data warehouse bus matrix is a combination of Dimensions and data marts.

10. E Ensure that the transaction edit flat is used for analysis is not the managing issue in the modeling process.





6 comments :