CS614 Data Warehouse Solved MCQs Lecture 23-45
10 Questions
0 Views

Choose a study mode

Play Quiz
Study Flashcards
Spaced Repetition
Chat to lesson

Podcast

Play an AI-generated podcast conversation about this lesson

Questions and Answers

According to Bill Inmon, when are requirements well understood?

  • After all the schemas are defined
  • After they are extracted and verified (correct)
  • After they are documented
  • After they are reviewed by the users
  • What is one of the drawbacks of the waterfall model?

  • It defines project timelines too rigidly
  • It allows for constant changes during development
  • Customers cannot review the product during development (correct)
  • It only works with unlimited resources
  • In a data warehouse, how is the approach different according to Bill Inmon?

  • Technology driven
  • Requirement driven (correct)
  • Time sensitive
  • Resource driven
  • What does 'horizontally wide data' refer to?

    <p>A dataset with large number of records</p> Signup and view all the answers

    In the lifecycle data track, what comes after translating the requirements into a dimensional model?

    <p>Physical structure</p> Signup and view all the answers

    What type of architecture design supports communication about technical requirements within the team, upward to management, and outward to vendors?

    <p>(I), (II) and (III)</p> Signup and view all the answers

    What is a common pitfall in Data Warehouse Life Cycle & Development?

    <p>Frequent backups</p> Signup and view all the answers

    Who is credited with the goal-driven approach to data warehouse development?

    <p>Westerman</p> Signup and view all the answers

    Which step is NOT included in the list of Top-7 key steps for smooth Data Warehouse implementation?

    <p>Follow strict timelines</p> Signup and view all the answers

    What comes after the development phase in the typical cycle of implementing change in Data Warehouse?

    <p>Production -&gt; Development -&gt; QA</p> Signup and view all the answers

    More Like This

    Use Quizgecko on...
    Browser
    Browser