Data Warehousing and Data Mining mcq questions

Data Warehousing and Data Mining 

Questions 1 To 10

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. (B) Data access tools to be used when deciding on the data structure of a data mart. 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. (C) The process of removing the deficiencies and loopholes in the data is called as cleaning up 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. (B) Online Analytical Processing (OLAP) manages both current and historic transactions. 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. (C) Cluster is the collection of data objects that are similar to one another within the same group. 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. (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. 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. (A) KDD Process includes data cleaning, data integration, data selection, data transformation, data mining, pattern evolution, and knowledge presentation. 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. (B) Dimensional models can be created at Architecture models level. 8. Which of the following is not related to dimension table attributes? (a) Verbose (b) Descriptive (c) Equally unavailable (d) Complete (e) Indexed. (C) Equally unavailable is not related to dimension table attributes. 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. (A) Data warehouse bus matrix is a combination of Dimensions and data marts. 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. (E) Ensure that the transaction edit flat is used for analysis is not the managing issue in the modeling process.