logo

CuriousTab

CuriousTab

Discussion


Home Database Data Warehousing Comments

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

  • Correct Answer
  • All of the above. 


  • Data Warehousing problems


    Search Results


    • 1. An operational system is which of the following?

    • Options
    • A. A system that is used to run the business in real time and is based on historical data.
    • B. A system that is used to run the business in real time and is based on current data.
    • C. A system that is used to support decision making and is based on current data.
    • D. A system that is used to support decision making and is based on historical data.
    • Discuss
    • 2. Fact tables are which of the following?

    • Options
    • A. Completely denoralized
    • B. Partially denoralized
    • C. Completely normalized
    • D. Partially normalized
    • Discuss
    • 3. A snowflake schema is which of the following types of tables?

    • Options
    • A. Fact
    • B. Dimension
    • C. Helper
    • D. All of the above
    • Discuss
    • 4. Which of the following items are not necessary for client/server?

    • Options
    • A. Assure that tools will connect with middleware.
    • B. Understand the requirements.
    • C. Determine network bandwidth capabilities.
    • D. Include the use of a file server.
    • Discuss
    • 5. Which of the following statements is true about symmetric multiprocessing?

    • Options
    • A. A single copy of the operating system resides in each processor.
    • B. Useful for situations where data must remain in memory to process.
    • C. Bottlenecks increase with uniprocessor systems because tasks are not shared.
    • D. The problems of memory contention are unlikely.
    • Discuss
    • 6. 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
    • 7. 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
    • 8. 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
    • 9. 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
    • 10. 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.
    • Discuss


    Comments

    There are no comments.

Enter a new Comment