On This Page
This set of Data Warehouse Multiple Choice Questions & Answers (MCQs) focuses on Data Warehouse Set 3
Q1 | ________________ is an expensive process in building an expert system.
- Analysis.
- Study.
- Design.
- Information collection.
Q2 | The full form of KDD is _________.
- Knowledge database.
- Knowledge discovery in database.
- Knowledge data house.
- Knowledge data definition.
Q3 | The first International conference on KDD was held in the year _____________.
- 1996.
- 1997.
- 1995.
- 1994.
Q4 | Removing duplicate records is a process called _____________.
- recovery.
- data cleaning.
- data cleansing.
- data pruning.
Q5 | ____________ contains information that gives users an easy-to-understand perspective of the information stored in the data warehouse.
- Business metadata.
- Technical metadata.
- Operational metadata.
- Financial metadata.
Q6 | _______________ helps to integrate, maintain and view the contents of the datawarehousing system.
- Business directory.
- Information directory.
- Data dictionary.
- Database.
Q7 | Discovery of cross-sales opportunities is called ________________.
- segmentation.
- visualization.
- correction.
- association.
Q8 | Data marts that incorporate data mining tools to extract sets of data are called______.
- independent data mart.
- dependent data marts.
- intra-entry data mart.
- inter-entry data mart.
Q9 | ____________ can generate programs itself, enabling it to carry out new tasks.
- Automated system.
- Decision making system.
- Self-learning system.
- Productivity system.
Q10 | The power of self-learning system lies in __________.
- cost.
- speed.
- accuracy.
- simplicity.
Q11 | Building the informational database is done with the help of _______.
- transformation or propagation tools.
- transformation tools only.
- propagation tools only.
- extraction tools.
Q12 | How many components are there in a data warehouse?
- two.
- three.
- four.
- five.
Q13 | Which of the following is not a component of a data warehouse?
- Metadata.
- Current detail data.
- Lightly summarized data.
- Component Key.
Q14 | ________ is data that is distilled from the low level of detail found at the currentdetailed leve.
- Highly summarized data.
- Lightly summarized data.
- Metadata.
- Older detail data.
Q15 | Highly summarized data is _______.
- compact and easily accessible.
- compact and expensive.
- compact and hardly accessible.
- compact.
Q16 | A directory to help the DSS analyst locate the contents of the data warehouse is seenin ______.
- Current detail data.
- Lightly summarized data.
- Metadata.
- Older detail data.
Q17 | Metadata contains atleast _________.
- the structure of the data.
- the algorithms used for summarization.
- the mapping from the operational environment to the data warehouse.
- all of the above.
Q18 | Which of the following is not a old detail storage medium?
- Phot Optical Storage.
- RAID.
- Microfinche.
- Pen drive.
Q19 | The data from the operational environment enter _______ of data warehouse.
- Current detail data.
- Older detail data.
- Lightly summarized data.
- Highly summarized data.
Q20 | The data in current detail level resides till ________ event occurs.
- purge.
- summarization.
- archieved.
- all of the above.
Q21 | The dimension tables describe the _________.
- entities.
- facts.
- keys.
- units of measures.
Q22 | The granularity of the fact is the _____ of detail at which it is recorded.
- transformation.
- summarization.
- level.
- tr
Q23 | Which of the following is not a primary grain in analytical modeling?
- Transaction.
- Periodic snapshot.
- Accumulating snapshot.
- All of the above.
Q24 | Granularity is determined by ______.
- number of parts to a key.
- granularity of those parts.
- both A and B.
- none of the above.
Q25 | ___________ of data means that the attributes within a given entity are fully dependent on the entire primary key of the entity.
- Additivity.
- Granularity.
- Functional dependency.
- Dimensionality.