Data Warehouse Quiz Questions And Answers

15 Questions | Total Attempts: 5621

SettingsSettingsSettings
Data Warehouse Quiz Questions And Answers - Quiz

How much do you know about data warehouses? Here are some data warehouse quiz questions and answers for you. Check them out. A data warehouse (DW or DWH), also known as an enterprise data warehouse (EDW), is a system that is considered a core component of business intelligence. They store current and historical data in one single place. How much do you know about this topic? Find out by taking this quiz. Best of luck to you.


Questions and Answers
  • 1. 
    What is the system of Data Warehousing mostly used for?
    • A. 

      Data Integration and Data Mining

    • B. 

      Data Mining and Data Storage

    • C. 

      Reporting and Data Analysis

    • D. 

      Data Cleaning and Data Storage

  • 2. 
    What does the typical Extract, Transform, Load (ETL)-based data warehouse use to house its key Functions?
    • A. 

      Staging

    • B. 

      Access Layers

    • C. 

      Data Integration

    • D. 

      All of the above

  • 3. 
    What is the combination of facts and dimensions sometimes called?
    • A. 

      Physical Schema

    • B. 

      Star Schema

    • C. 

      Dimension Model

    • D. 

      Denormalizing Modeling

  • 4. 
    What does the access layer help users to do?
    • A. 

      Store Data

    • B. 

      Analyse Data

    • C. 

      Clean Data

    • D. 

      Retrieve Data

  • 5. 
    What type of data formats do conventional database systems use?
    • A. 

      Highly Denormalized

    • B. 

      Highly Normalized

    • C. 

      A and B

    • D. 

      None of the above

  • 6. 
    What is computing in data warehouses often referred to as?
    • A. 

      OLAP

    • B. 

      OLAT

    • C. 

      OLTP

    • D. 

      OLTA

  • 7. 
    When does data staging occur in data warehousing?
    • A. 

      A periodic process reads data from sources.

    • B. 

      A periodic process stores data gotten from sources.

    • C. 

      A periodic process mines data from sources

    • D. 

      None of the above

  • 8. 
    Which small logical units do data warehouses keep large amounts of information in?
    • A. 

      Data Storage

    • B. 

      Data Marts

    • C. 

      Access Layer

    • D. 

      Data Miners

  • 9. 
    When are dimensions conformed?
    • A. 

      When they can be compared mathematically

    • B. 

      When they are either the same or one is a subset of another.

    • C. 

      When they have different values

    • D. 

      When they are labeled differently

  • 10. 
    What is reconciled data?
    • A. 

      Data stored in one operational system

    • B. 

      Data stored in the various operational systems available in the organization

    • C. 

      Current data intended to be the single source for all decision support systems

    • D. 

      Data that has been selected for end-user applications

  • 11. 
    Which of the following does the active data warehouse architecture include?
    • A. 

      At least 1 data mart

    • B. 

      Data that can be extracted from internal and external sources

    • C. 

      Real-time updates

    • D. 

      All of these

  • 12. 
    A data warehouse is
    • A. 

      Contains the world's data

    • B. 

      Ready to be updated by the end-users

    • C. 

      Organized around important subject areas

    • D. 

      None of these

  • 13. 
    The main purpose of a data warehouse is to research different data.
    • A. 

      True

    • B. 

      False

  • 14. 
    A data mart is designed for the optimization of the performance for well-defined and predicable uses.
    • A. 

      True

    • B. 

      False

  • 15. 
    Successful data warehousing needs a formal program in total quality management (TQM) to be implemented.
    • A. 

      True

    • B. 

      False

Related Topics
Back to Top Back to top