CS614 Quiz No. 2 Solution and Discussion

Implementation of a data warehouse requires ________ activities

  • Highly integrated
  • Loosely integrated
  • Tightly decoupled
  • None of the given
    67697861-a7a4-40c3-8598-3603fe6b6f11-image.png

A ______ index, if fits in the memory, costs only one disk I/O access to locate a record given a key.
9845bbb1-88d1-4237-b3bd-af994ceed479-image.png

Mining multi dimensional databases allow users to:

  • Categorize the data

  • Analyze the data (Answer)

  • Summarize the data

  • All of the given options

In context of data parallelism, to get a speed-up of N with N partitions, it must be ensured that:

  • There are enough computing resources

  • Query-coordinator is very fast as compared to query servers

  • Work done in each partition almost same

  • All of the given options

@zareen

  • NULL value to make the leaf terminal node

  • Every indexed data value and a corresponding ROWID

  • Every indexed data value and pointer to next level block

  • Every indexed data value and pointer to root block

In B-tree index, the lowest level index blocks are called leaf blocks, and these blocks contain:0fb75827-b031-4cbe-9386-136e7c0fd395-image.png

@zareen
Prototype (Correct)

In ______ phase of a fundamental data warehouse life cycle model, a working model of data warehouse is deployed for a selective set of users
bba4a37f-7565-46d5-a407-6c24b64e314e-image.png

Log in to reply