logo

CuriousTab

CuriousTab

Discussion


Home Database Data Warehousing Comments

  • Question
  • Most operational systems are based on the use of transient data.


  • Options
  • A. True
  • B. False

  • Correct Answer
  • True 


  • Data Warehousing problems


    Search Results


    • 1. Joining is the process of partitioning data according to predefined criteria.

    • Options
    • A. True
    • B. False
    • Discuss
    • 2. Both status data and event data can be stored in a database.

    • Options
    • A. True
    • B. False
    • Discuss
    • 3. Every key used to join the fact table with a dimensional table should be a surrogate key.

    • Options
    • A. True
    • B. False
    • Discuss
    • 4. Data in the data warehouse are loaded and refreshed from operational systems.

    • Options
    • A. True
    • B. False
    • Discuss
    • 5. Derived data are detailed, current data intended to be the single, authoritative source for all decision support applications.

    • Options
    • A. True
    • B. False
    • Discuss
    • 6. Data scrubbing can help upgrade data quality; it is not a long-term solution to the data quality problem.

    • Options
    • A. True
    • B. False
    • Discuss
    • 7. Independent data marts are often created because an organization focuses on a series of short-term business objectives.

    • Options
    • A. True
    • B. False
    • Discuss
    • 8. Static extract is used for ongoing warehouse maintenance.

    • Options
    • A. True
    • B. False
    • Discuss
    • 9. Periodic data are data that are physically altered once added to the store.

    • Options
    • A. True
    • B. False
    • Discuss
    • 10. Synchronization for pull replication is less disruptive and occurs only when needed by each site, not when a central master site thinks it is best to update.

    • Options
    • A. True
    • B. False
    • Discuss


    Comments

    There are no comments.

Enter a new Comment