Fundamentals Of Data Warehousing Quiz!

30 Questions | Total Attempts: 66

SettingsSettingsSettings
Please wait...
Fundamentals Of Data Warehousing Quiz!

In the world of computers, a data warehouse is a system used for reporting and data testing, and it plays a role in business intelligence. It is uploaded from the operational plan, such as marketing or sales. The data may go through the operational data storage and may require data cleansing. The data is cleansed and made available for professional use. Don’t neglect to retrieve your certificate when you have completed this quiz.


Questions and Answers
  • 1. 
    What type of schema?
    • A. 

      Star Schema

    • B. 

      Snowflakes Schema

    • C. 

      Skyflakes schema

  • 2. 
    On Table 2, what type of table?
    • A. 

      Fact Table

    • B. 

      Dimension Table

    • C. 

      Factual Table

    • D. 

      Dimensional Table

  • 3. 
    On Table 1, what type of table?
    • A. 

      Fact Table

    • B. 

      Dimension Table

    • C. 

      Factual Table

    • D. 

      Dimensional Table

  • 4. 
    What does the lines mean?
    • A. 

      Relationship

    • B. 

      Connectors

    • C. 

      Process

    • D. 

      Network

  • 5. 
    When does ETL happens?
    • A. 

      2,3,4,5

    • B. 

      6, 7, 8

    • C. 

      11

    • D. 

      12

  • 6. 
    Where is the datawarehouse?
    • A. 

      2

    • B. 

      8

    • C. 

      11

    • D. 

      14

  • 7. 
    Where are the source data?
    • A. 

      4

    • B. 

      2

    • C. 

      7

    • D. 

      13

  • 8. 
    What is item 12?
    • A. 

      Prescriptive Analytics

    • B. 

      ETL

    • C. 

      Source Data

  • 9. 
    Involves historical processing of information.      
    • A. 

      OLTP

    • B. 

      OLAP

  • 10. 
    Involves day-to-day processing. 
    • A. 

      OLTP

    • B. 

      OLAP

  • 11. 
    Used by clerks, DBAs, or database professionals. 
    • A. 

      OLTP

    • B. 

      OLAP

  • 12. 
    Useful in running the business. 
    • A. 

      OLTP

    • B. 

      OLAP

  • 13. 
    Useful in analyzing the business. 
    • A. 

      OLAP

    • B. 

      OLTP

  • 14. 
    Where does cube and marts created?
    • A. 

      11

    • B. 

      1

    • C. 

      12

    • D. 

      2

  • 15. 
    It focuses on Information out. 
    • A. 

      OLTP

    • B. 

      OLAP

  • 16. 
    It focuses on Data in. 
    • A. 

      OLTP

    • B. 

      OLAP

  • 17. 
    Based on Star Schema, Snowflake, Schema and Fact Constellation Schema. 
    • A. 

      OLTP

    • B. 

      OLAP

  • 18. 
    Data mart are not flexible.
    • A. 

      True

    • B. 

      False

  • 19. 
    A data warehouse also helps in bringing down the costs by tracking trends, patterns over a long period in a consistent and reliable manner.
    • A. 

      True

    • B. 

      False

  • 20. 
    Data extraction takes data from the source systems.
    • A. 

      True

    • B. 

      False

  • 21. 
    Is a subject-oriented, integrated, time-variant, and non-volatile collection of data. This data helps analysts to take informed decisions in an organization.
    • A. 

      Data Marts

    • B. 

      Data Warehouse

    • C. 

      Data Cubes

    • D. 

      Data Analytics

  • 22. 
    Is constructed by integrating data from multiple heterogeneous sources. It supports analytical reporting, structured and/or ad hoc queries, and decision making. This tutorial adopts a step-by-step approach to explain all the necessary concepts of data warehousing.
    • A. 

      Data Marts

    • B. 

      Data Warehouse

    • C. 

      Data Cubes

    • D. 

      Data Science

  • 23. 
    Data warehouse systems help in the integration of a diversity of application systems.
    • A. 

      True

    • B. 

      False

  • 24. 
    There is no frequent updating done in a data warehouse.
    • A. 

      True

    • B. 

      False

  • 25. 
    Data smarts help executives to organize, understand, and use their data to make strategic decisions.
    • A. 

      True

    • B. 

      False

Back to Top Back to top