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

52 Questions

Settings
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.


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. 
    • 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. 
    • 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. 
    • 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. 
    • A. 

      A) Inmon

    • B. 

      B) Ralph Kimball

    • C. 

      C) Loney

    • D. 

      D) None of the above

  • 19. 
    • 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. 
    • 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. 
    • 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

  • 26. 
    Dimension used in multiple schemas is called
    • A. 

      Conformed dimension

    • B. 

      Confirmed dimension

    • C. 

      Shared dimension

    • D. 

      None of the above

  • 27. 
    Arrange the following 1.Presentation Layer 2.ODS Layer 3.Replica Layer 4.DWH Layer
    • A. 

      3,1,4,2

    • B. 

      3,2,4,1

    • C. 

      1,2,3,4

    • D. 

      None of the above

  • 28. 
    A good ETL tool must be able to communicate with many different
    • A. 

      Relational Databases

    • B. 

      Sources

    • C. 

      Targets

    • D. 

      Flat files

  • 29. 
    Types of schemas in DWH
    • A. 

      Star schema, Snowflake schema, 3NF

    • B. 

      Snowflake schema, 2NF

    • C. 

      Snowflake schema, Star schema

    • D. 

      Star schema

  • 30. 
    • A. 

      Degenerate dimension

    • B. 

      Junk dimension

    • C. 

      Time dimension

    • D. 

      Mystery dimension

  • 31. 
    • A. 

      Degenerate dimension

    • B. 

      Junk dimension

    • C. 

      Time dimension

    • D. 

      Mystery dimension

  • 32. 
    • A. 

      Extract, Transform, Load

    • B. 

      Transform, Extract, Load

    • C. 

      Load, Transform, Extract

    • D. 

      None of the above

  • 33. 
    • Star schema stores data in form of
    • A. 

      1NF

    • B. 

      2NF

    • C. 

      3NF

    • D. 

      4NF

  • 34. 
    Fact tables are normalized
    • A. 

      True

    • B. 

      False

  • 35. 
    Static extract is used for ongoing warehouse maintenance
    • A. 

      True

    • B. 

      False

  • 36. 
    For “point in time” concept in DWH, history staging is must
    • A. 

      True

    • B. 

      False

  • 37. 
    A conditional report is based on data gathered, then analyzed during report generation, which reports out the results of analysis in report’s output
    • A. 

      True

    • B. 

      False

  • 38. 
    Can we use single dimension in multi schema
    • A. 

      True

    • B. 

      False

  • 39. 
    Data warehouse must be de-normalized
    • A. 

      True

    • B. 

      False

  • 40. 
    ODS is used for day to day decision
    • A. 

      True

    • B. 

      False

  • 41. 
    Dimension are normalized
    • A. 

      True

    • B. 

      False

  • 42. 
    In warehouse data is stored with bitmap index
    • A. 

      True

    • B. 

      False

  • 43. 
    All data bases must be in third normal form
    • A. 

      True

    • B. 

      False

  • 44. 
    Derived data are detailed, current data that are intended to be single, authoritative data for all decision support applications
    • A. 

      True

    • B. 

      False

  • 45. 
    Every key used to join fact table with dimensional table should be a surrogate key
    • A. 

      True

    • B. 

      False

  • 46. 
    Periodic data are data that are physically altered once added to the store
    • A. 

      True

    • B. 

      False

  • 47. 
    Star schema is generally suited to online transaction processing and therefore is generally used in operational systems, operational data stores and EDW
    • A. 

      True

    • B. 

      False

  • 48. 
    Data in data warehouse are retrieved and loaded from operational systems
    • A. 

      True

    • B. 

      False

  • 49. 
    In snow flake we don’t have any flake
    • A. 

      True

    • B. 

      False

  • 50. 
    In star schema dimensional tables are usually not in BCNF form
    • A. 

      True

    • B. 

      False

  • 51. 
    ER modeling is design form in which we store data in de-normalized form while dimensional modeling is for storing data in highly normalized form
    • A. 

      True

    • B. 

      False

  • 52. 
    Data mart is a subset of DWM
    • A. 

      True

    • B. 

      False