CS614 Data Warehouse Solved MCQs Lecture 23-45

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 (B)</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 (B)</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) (D)</p> Signup and view all the answers

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

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

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

<p>Westerman (C)</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 (A)</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 (C)</p> Signup and view all the answers

Flashcards are hidden until you start studying

More Like This

Use Quizgecko on...
Browser
Browser