Data Warehousing & Mining MCQs

 1. ________________ is a subject oriented, integrated, time-variant, and non-volatile collection of data.
a) Data Mining            b) data warehouse      c) data Processing      d) Database
Ans: data warehouse

2. ______________ supports knowledge discovery by finding hidden patterns and associations, constructing analytical models, performing classification and prediction.
a) Data Mining            b) data warehouse      c) Analytical Processing         d) Information Processing
Ans: Data Mining

3. Metadata repository is an ___________ part of a data warehouse system.
a) formal         b) directory      c) integral        d) All of these
Ans: integral

4. A data warehouse is never___________.
a) dynamic      b) static           c) both a & b   d) none of these
Ans: static

5. Which of these processes that contribute to a data warehouse.
a) Extract and load the data   b) Cleaning and transforming the data
c) Backup and archive the data          d) All of these
e) none of these
Ans: All of these

6. business analysis framework has following views.
a) The top-down view             b) The data source view         c) data warehouse view
d) business query view           e) All of these
Ans: All of these

7. ______________ servers are placed between relational back-end server and client front-end tools.
a) ROLAP       b) OLAP          c) MOLAP       d) HOLAP
Ans: ROLAP

8. Each dimension in a _____________ is represented with only one-dimension table.
a) snowflake schema              b) star schema            c) Fact Constellation Schema
d) none of these
Ans: star schema

9. Metadata can be broadly categorized into.
a) Business Metadata             b) Technical Metadata            c) Operational Metadata
d) all of these
Ans: All of these

10. below are the reasons to create a data mart-
a) To partition data      b) To speed up the queries     c) To segment data     d) To structure data    e) All of these
Ans: All of these

11. Following activities get affected by security measure-   
a) User access            b) Data load    c) both a & b   d) none of these
Ans: Both a & b

12. Which is not types of process managers.
a) Load manager        b) Warehouse manager          c) Query manager       d) field Manager
Ans: Field Manager

13. ______________ is defined as the procedure of extracting information from huge sets of data.
a) Data Mining            b) data warehouse      c) Analytical Processing         d) Information Processing
Ans: Data Mining

14. Data Mining can be used for any of the following applications −
a) Market Analysis      b) Fraud Detection      c) Customer Retention            d) Production Control              e) All of these
Ans: All of these

15. ______________ refers to the mapping or classification of a class with some predefined group or class.
a) Data Characterization         b) Data Discrimination            c) both a & b   d) none of these
Ans: Data Discrimination

16. _____________ refers to a group of similar kind of objects.
a) Correlations            b) Association             c) Clusters       d) all of these
Ans: Clusters

17. Steps involved in the knowledge discovery process −
a) Data Cleaning         b) Data Integration      c) Data Selection        d) all of these
Ans: All of these

18. In _____________ the data mining system is smoothly integrated into the database or data warehouse system.
a) No Coupling            b) Loose Coupling       c) Semi−tight Coupling           d) Tight coupling
Ans: Tight coupling

19. ______________ can be designed to support ad hoc and interactive data mining.
a) DMQL         b) SQL            c) both a & b   d) none of these
Ans: DMQL

20. ____________ involves removing the noise and treatment of missing values.
a) Relevance Analysis            b) Data Transformation          c) Data Cleaning         d) reduction
Ans: Data Cleaning

21. A ____________ is a structure that includes a root node, branches, and leaf nodes.
a) Tree prunning         b) decision tree           c) both a& b    d) none of these
Ans: decision tree

22. ______________ classification is based on Bayes' Theorem.   
a) Bayesian     b) Rule Based             c) decision tree           d) all of these
Ans: Bayesian

23. _______________ is to extract the semantic structure of a web page based on its visual presentation.
a) DOM           b) DOC           c) VIPS            d) none of these
Ans: VIPS

24. The selection of a data mining system depends on the following features-
a) Data Types             b) Data Sources          c) System Issues         d) All of these
Ans: All of these

25. Data Mining has following issues-
a) Mining Methodology           b) User Interaction      c) Performance Issue             d) All of these
Ans: All of These

26. _____________ can be well tuned by repositioning the products and managing the product portfolios by comparing the sales quarterly or yearly.
a) Customer Analysis             b) The product strategies       
c) Operation Analysis             d) Loading Strategies
Ans: The product strategies

27. ___________ acts as a directory.
a) Metadata                 b) data             c) dimention                d) schema
Ans: Metadata

28. ___________ includes dimension algorithms, data on granularity, aggregation, summarizing, etc.
a) Business metadata             b) operational metadata
c) data for mapping                 d) algorithm for summarization
Ans: algorithm for summarization

29. A ____________ helps us represent data in multiple dimensions.
a) data cube                b) metadata     c) data square             d) data mart
Ans: datacube

30. Data marts contain a subset of organization-wide data that is valuable to specific groups of people in an organization.
a) data cube                b) metadata     c) data square             d) data mart
Ans: datamart

31. A data warehouse is never ___________.
a) dynamic                  b) static           c) both a & b               d) none of these.
Ans: static

32. four major processes that contribute to a data warehouse -
a) Extract and load the data.              B) Cleaning and transforming the data.
c) Backup and archive the data.         D) Managing queries
e) All of these
Ans: All of these