logo

CuriousTab

CuriousTab

Discussion


Home Database Data Warehousing Comments

  • Question
  • A snowflake schema is which of the following types of tables?


  • Options
  • A. Fact
  • B. Dimension
  • C. Helper
  • D. All of the above

  • Correct Answer
  • All of the above 


  • Data Warehousing problems


    Search Results


    • 1. 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
    • 2. 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
    • 3. Which of the following is true concerning QBE?

    • Options
    • A. An official standard has been defined for QBE.
    • B. QBE cannot be used for client/server systems.
    • C. QBE does not give the programmer a visual programming environment.
    • D. Complete applications can be written using QBE.
    • Discuss
    • 4. Which of the following is true concerning the mainframe?

    • Options
    • A. It is the same thing as client/server.
    • B. Requires someone to decide which code should be on the workstation or the server.
    • C. Mission-critical systems have tended to remain there.
    • D. All of the above.
    • Discuss
    • 5. Three-tier architecture includes which of the following?

    • Options
    • A. Three server layers
    • B. A client layer and two server layers
    • C. Two client layers and one server layer
    • D. Three client layers
    • Discuss
    • 6. Fact tables are which of the following?

    • Options
    • A. Completely denoralized
    • B. Partially denoralized
    • C. Completely normalized
    • D. Partially normalized
    • Discuss
    • 7. 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
    • 8. 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
    • 9. 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
    • 10. 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


    Comments

    There are no comments.

Enter a new Comment