logo

CuriousTab

CuriousTab

Discussion


Home Database Data Warehousing Comments

  • Question
  • The generic two-level data warehouse architecture includes which of the following?


  • Options
  • A. At least one data mart
  • B. Data that can extracted from numerous internal and external sources
  • C. Near real-time updates
  • D. All of the above.

  • Correct Answer
  • Data that can extracted from numerous internal and external sources 


  • Data Warehousing problems


    Search Results


    • 1. Data transformation includes which of the following?

    • Options
    • A. A process to change data from a detailed level to a summary level
    • B. A process to change data from a summary level to a detailed level
    • C. Joining data from one source into various sources of data
    • D. Separating data from one source into various sources of data
    • Discuss
    • 2. A data warehouse is which of the following?

    • Options
    • A. Can be updated by end users.
    • B. Contains numerous naming conventions and formats.
    • C. Organized around important subject areas.
    • D. Contains only current data.
    • Discuss
    • 3. The extract process is which of the following?

    • Options
    • A. Capturing all of the data contained in various operational systems
    • B. Capturing a subset of the data contained in various operational systems
    • C. Capturing all of the data contained in various decision support systems
    • D. Capturing a subset of the data contained in various decision support systems
    • Discuss
    • 4. A goal of data mining includes which of the following?

    • Options
    • A. To explain some observed event or condition
    • B. To confirm that data exists
    • C. To analyze data for expected relationships
    • D. To create a new data warehouse
    • Discuss
    • 5. The @active data warehouse architecture includes which of the following?

    • Options
    • A. At least one data mart
    • B. Data that can extracted from numerous internal and external sources
    • C. Near real-time updates
    • D. All of the above.
    • Discuss
    • 6. Data scrubbing is which of the following?

    • Options
    • A. A process to reject data from the data warehouse and to create the necessary indexes
    • B. A process to load the data in the data warehouse and to create the necessary indexes
    • C. A process to upgrade the quality of data after it is moved into a data warehouse
    • D. A process to upgrade the quality of data before it is moved into a data warehouse
    • Discuss
    • 7. A star schema has what type of relationship between a dimension and fact table?

    • Options
    • A. Many-to-many
    • B. One-to-one
    • C. One-to-many
    • D. All of the above.
    • Discuss
    • 8. Transient data is which of the following?

    • Options
    • A. Data in which changes to existing records cause the previous version of the records to be eliminated
    • B. Data in which changes to existing records do not cause the previous version of the records to be eliminated
    • C. Data that are never altered or deleted once they have been added
    • D. Data that are never deleted once they have been added
    • Discuss
    • 9. Reconciled data is which of the following?

    • Options
    • A. Data stored in the various operational systems throughout the organization.
    • B. Current data intended to be the single source for all decision support systems.
    • C. Data stored in one operational system in the organization.
    • D. Data that has been selected and formatted for end-user support applications.
    • Discuss
    • 10. The load and index is which of the following?

    • Options
    • A. A process to reject data from the data warehouse and to create the necessary indexes
    • B. A process to load the data in the data warehouse and to create the necessary indexes
    • C. A process to upgrade the quality of data after it is moved into a data warehouse
    • D. A process to upgrade the quality of data before it is moved into a data warehouse
    • Discuss


    Comments

    There are no comments.

Enter a new Comment