Trivia Quiz: What Do You Know About Data Mining And Data Warehousing?

52 Questions | Total Attempts: 261

SettingsSettingsSettings
Please wait...
Trivia Quiz: What Do You Know About Data Mining And Data Warehousing?

What do you know about data mining and data warehousing? When it comes to storage of data you may store data haphazardly or may use data warehousing where you can store the same type of data under the same file. Take up the quiz below and get to see how much more you can learn the two data retrieval processing.


Related Topics
Questions and Answers
  • 1. 
    ETL is abbreviated as 
    • A. 

      A) Except, Transformation,Load

    • B. 

      B) Extract,Transform,Load

    • C. 

      C) Exact,Transission,Load

    • D. 

      D) None of the above

  • 2. 
    Arrange the following sequence 1.Data 2.Knowledge 3.Information 4.Insight
    • A. 

      A) 3,1,4,2

    • B. 

      B) 1,3,2,4

    • C. 

      C) 4,1,2,3

    • D. 

      D) 1,2,3,4

  • 3. 
    OLTP systems are
    • A. 

      A) Operating Systems

    • B. 

      B) Purely Decision Support systems

    • C. 

      C) Analytical Systems

    • D. 

      D) Security systems

  • 4. 
    Operational Databases are 
    • A. 

      Highly de normalized databases

    • B. 

      Performance is always slow

    • C. 

      Contains historical data

    • D. 

      None of the above

  • 5. 
    Top Down approach is suggested by 
    • A. 

      A) Ralph Kimball

    • B. 

      B) Bill Inmon

    • C. 

      C) Barry Williams

    • D. 

      D) Ted Code

  • 6. 
    It is an automated process of building a data warehouse which involves taking the data from disparate source systems, converting them into a consistent form that can be loaded into the warehouse and performing quality checks while building the data ware house. It typically accounts for 70-80% of the effort in a data warehousing initiative. 
    • A. 

      Data Staging

    • B. 

      Data Loading

    • C. 

      Data Transaction

    • D. 

      None of the above

  • 7. 
    Analytical Systems are
    • A. 

      A) Contain Historic data

    • B. 

      B) Used for Decision making

    • C. 

      C) Used for Analysis purpose

    • D. 

      D) All of the above

  • 8. 
    Which of the following does not describe Data warehouse
    • A. 

      A) Subject-oriented

    • B. 

      B) Integrated

    • C. 

      C) Time-variant

    • D. 

      D) Updateable

  • 9. 
    DWM bus concept is there in which concept
    • A. 

      A) Ralph Kimball

    • B. 

      B) Bill Inmon

    • C. 

      C) Ted Code

    • D. 

      D) John Inmon

  • 10. 
    Which of the following is/are functions of warehouse manager of data warehouse 1.Transforming and managing data 2.Back ups and archiving data warehouse 3.Directing and managing queries
    • A. 

      Only 1

    • B. 

      Only 2

    • C. 

      Only 3

    • D. 

      Both 2 and 3

  • 11. 
    In organization the relation b/n projects and employees
    • A. 

      A) Many-to-many

    • B. 

      B) Many-to-one

    • C. 

      C) One-to-one

    • D. 

      D) One-to-many

  • 12. 
    In star schema surrounding referencing tables around central factual dimension tables are
    • A. 

      Dimensional tables

    • B. 

      Fact tables

    • C. 

      Relational tables

    • D. 

      Temporary tables

  • 13. 
    Arrange the following steps in the correct sequence 1. Look for essential transactions. 2. Check if the fact is a dimension. 3. Check if dimension is the fact. 4. Determine key dimensions.
    • A. 

      A) 1,3,2,4

    • B. 

      B) 4,1,3,2

    • C. 

      C) 1,4,2,3

    • D. 

      D) 1,2,3,4

  • 14. 
    Which of the following statements is/are true about fact data and dimensional data 1. Fact data represents a physical transaction that has occurred at the point in time and as such is unlikely change during ongoing basis during the life of data warehouse 2. In general dimensional data in a star schema or snowflake schema is designed to minimize the cost of change and is typically very low volume data (i.e. under 5 GB) 3. Fact data will have only one foreign key whereas reference data will have one primary key.
    • A. 

      A) Only 1

    • B. 

      B) Only 2

    • C. 

      C) Only 3

    • D. 

      D) Both 1 and 2

  • 15. 
    • A. 

      A) Only 1

    • B. 

      B) Only 3

    • C. 

      C) Both 1 and 2

    • D. 

      D) Both 2 and 3

  • 16. 
    Arrange the following 1. Staging Data 2. Persistent staging 3. History staging 4. ODS 5. Data warehouse 6. Datamart
    • A. 

      A) 1,2,3,4,5,6

    • B. 

      B) 1,2,4,3,6,5

    • C. 

      C) 1,3,2,4,5,6

    • D. 

      D) None of the above

  • 17. 
    What is Business Intelligence?
    • A. 

      A) Process

    • B. 

      B) Tool

    • C. 

      C) Technique

    • D. 

      D) Software

  • 18. 
    Who invented the top-down approach?
    • A. 

      A) Inmon

    • B. 

      B) Ralph Kimball

    • C. 

      C) Loney

    • D. 

      D) None of the above

  • 19. 
    Which of the following data modeling?
    • A. 

      OLAP

    • B. 

      OLTP

    • C. 

      HOLAP

    • D. 

      MOLAP

  • 20. 
    The process of examining the data available in existing data source and collecting statistics and information about the data
    • A. 

      Data Cleansing

    • B. 

      Data Mining

    • C. 

      Data Profiling

    • D. 

      Data Presentation

  • 21. 
    OLTP data is the combination of master data and 
    • A. 

      Dimensional data

    • B. 

      Aggregated data

    • C. 

      Details data

    • D. 

      None of the above

  • 22. 
    What does fact less fact table contains
    • A. 

      Measure only

    • B. 

      Multipart key only

    • C. 

      Both

    • D. 

      None

  • 23. 
    Full form of ODS
    • A. 

      Operational data storage

    • B. 

      Operational data system

    • C. 

      Online data storage

    • D. 

      None

  • 24. 
    The key which is substitution for natural primary key in data warehouse
    • A. 

      Unique key

    • B. 

      Natural key

    • C. 

      Foreign key

    • D. 

      Surrogate key

  • 25. 
    What is dimensional modeling?
    • A. 

      Equivalent of physical data design in DWH

    • B. 

      Equivalent of logical data design in DWH

    • C. 

      Equivalent of data base design in DWH

    • D. 

      Equivalent of conceptual data design in DWH