Data Warehousing MCQ

Below Data Warehousing quiz are Multiple Choice Questions (MCQs) type Quiz. These Data Warehousing MCQ Questions helps you to refresh your Data Warehousing, you can see the correct option by clicking on it. .
  • 1. The role of the ETL process is to identify erroneous data and to fix them.

    • True
    • False
  • 2. Choose which data mining task is suitable for the following scenario: first buy digital camera, then buy large SD memory cards

    • Classification
    • Sequential pattern analysis
    • Association rule
    • Prediction
  • 3. What is NOT slowly changed dimension? You may answer multiple correct answers

    • Address
    • Body Mass Index
    • Last Name
    • Date of Birth
  • 4. Choose which data mining task is the most suitable for the following scenario: detecting the dosage of medicine for a certain treatment

    • Prediction
    • Classification
    • Association rules
    • Sequential pattern analysis
  • 5. The output of KDD is

    • Data
    • Information
    • Query
    • Useful information
  • 6. What is true of the multidimensional model?

    • It typically requires less disk storage
    • It typically requires more disk storage
    • Typical business queries requiring aggregate functions take more time
    • Increasing the size of a dimension is difficult
  • 7. Which of the following tools can be for DATA MINING

    • weka
    • R
    • both a& b
    • none
  • 8. Which one come first to build data warehouse

    • Data Cleansing
    • Business questions
    • Data Acquisition
    • Data Profiling
  • 9. Which of the following is not example of ordinal attributes

    • Zip code
    • Ordered no
    • Movie rating
    • Military rank
  • 10. Why aggregate is used in dimensional model of data warehouse?

    • To store data in one operational system
    • To retrieve data from an operational system
    • To combine data from heterogeneous sources
    • To take the dimension and change its granularity
  • 11. Which of these is NOT discrete data:

    • Height of a sunflower as measured each day
    • How many students are absent from school each day
    • How many widgets a business sell each day
    • The number of people who drive through a red light each hour during rush hour
  • 12. Identifying the examples of sequence data

    • Datamatrix
    • Weather forecast
    • Market basket data
    • Genomic data
  • 13. The data is stored, retrieved and updated in ………………..

    • OLAP
    • OLTP
    • SMTP
    • FTP
  • 14. …………………… is a good alternative to the star schema.

    • Star schema
    • Snowflake schema
    • Fact constellation
    • Star-snowflake schema
  • 15. { (item name, color, clothes size), (item name, color), (item name, clothes size), (color, clothes size), (item name), (color), (clothes size), () }This can be achieved by using which of the following ?

    • group by rollup
    • group by cube
    • group by
    • none of the mentioned
  • 16. Data transformation includes which of the following?

    • A process to change data from a detailed level to a summary level
    • A process to change data from a summary level to a detailed level
    • Joining data from one source into various sources of data
    • Separating data from one source into various sources of data
  • 17. Which is not a property of data warehouse?

    • subject oriented
    • time variant
    • collection from heterogeneous sources
    • volatile
  • 18. The task of inferring a model from as set of labeled data is called as

    • supervised learning
    • unsupervised learning
    • reinforcement learning
    • semi supervised learning
  • 19. The problem of finding the hidden structure in unlabeled data is called as

    • supervised learning
    • unsupervised learning
    • reinforcement learning
    • none of these