FINALTERM EXAMINATION
Spring 2009
CS614- Data Warehousing

Marks: 70

Question No: 1 ( Marks: 1 ) - Please choose one
It is observed that every year the amount of data recorded in an organization is
  • Doubles
  • Triples
  • Quartiles
  • Remains same as previous year


Question No: 2 ( Marks: 1 ) - Please choose one
Multidimensional databases typically use proprietary __________ format to store
pre-summarized cube structures.
  • File
  • Application
  • Aggregate
  • Database


Sponsored Links

Question No: 3 ( Marks: 1 ) - Please choose one
Pre-computed _______ can solve performance problems
  • Aggregates
  • Facts
  • Dimensions


Question No: 4 ( Marks: 1 ) - Please choose one
_______________, if fits into memory, costs only one disk I/O access to locate a
record by given key.
  • A Dense Index
  • A Sparse Index
  • An Inverted Index
  • None of These


Question No: 5 ( Marks: 1 ) - Please choose one
The degree of similarity between two records, often measured by a numerical
value between _______, usually depends on application characteristics.
  • 0 and 1
  • 0 and 10
  • 0 and 100
  • 0 and 99


Question No: 6 ( Marks: 1 ) - Please choose one
The purpose of the House of Quality technique is to reduce ______ types of risk.
  • Two
  • Three
  • Four
  • All


Question No: 7 ( Marks: 1 ) - Please choose one
NUMA stands for __________
  • Non-uniform Memory Access
  • Non-updateable Memory Architecture
  • New Universal Memory Architecture


Question No: 8 ( Marks: 1 ) - Please choose one
Which is the least appropriate join operation for Pipeline parallelism?
  • Hash Join
  • Inner Join
  • Outer Join
  • Sort-Merge Join


Question No: 9 ( Marks: 1 ) - Please choose one
There are many variants of the traditional nested-loop join. If the index is built as
part of the query plan and subsequently dropped, it is called
  • Naive nested-loop join
  • Index nested-loop join
  • Temporary index nested-loop join
  • None of these

Question No: 10 ( Marks: 1 ) - Please choose one
Data mining derives its name from the similarities between searching for valuable
business information in a large database, for example, finding linked products in
gigabytes of store scanner data, and mining a mountain for a _________ of
valuable ore.
  • Furrow
  • Streak
  • Trough
  • Vein


Question No: 11 ( Marks: 1 ) - Please choose one
With data mining, the best way to accomplish this is by setting aside some of
your data in a ________ to isolate it from the mining process; once the mining is
complete, the results can be tested against the isolated data to confirm the
model's validity.
  • Cell
  • Disk
  • Folder
  • Vault


Question No: 12 ( Marks: 1 ) - Please choose one
The Kimball s iterative data warehouse development approach drew on decades
of experience to develop the _____________.
  • Business Dimensional Lifecycle
  • Data Warehouse Dimension
  • Business Definition Lifecycle
  • OLAP Dimension


Question No: 13 ( Marks: 1 ) - Please choose one
We must try to find the one access tool that will handle all the needs of their
users.
  • True
  • False


Question No: 14 ( Marks: 1 ) - Please choose one
For a smooth DWH implementation we must be a technologist.
  • True
  • False


Question No: 15 ( Marks: 1 ) - Please choose one
During the application specification activity, we also must give consideration to
the organization of the applications.
  • True
  • False


Question No: 16 ( Marks: 1 ) - Please choose one
Investing years in architecture and forgetting the primary purpose of solving
business problems, results in inefficient application. This is the example of
_________ mistake.
  • Extreme Technology Design
  • Extreme Architecture Design
  • None of these


Question No: 17 ( Marks: 1 ) - Please choose one
The most recent attack is the ________ attack on the cotton crop during 2003-
04, resulting in a loss of nearly 0.5 million bales.
  • Boll Worm
  • Purple Worm
  • Blue Worm
  • Cotton Worm


Question No: 18 ( Marks: 1 ) - Please choose one
The users of data warehouse are knowledge workers in other words they are
_________ in the organization.
  • Decision maker
  • Manager
  • Database Administrator
  • DWH Analyst


Question No: 19 ( Marks: 1 ) - Please choose one
_________ breaks a table into multiple tables based upon common column
values.
  • Horizontal splitting
  • Vertical splitting


Question No: 20 ( Marks: 1 ) - Please choose one
Execution can be completed successfully or it may be stopped due to some
error. In case of successful completion of execution all the transactions will be
___________
  • Committed to the database
  • Rolled back


Question No: 21 ( Marks: 2 )
What is meant by the statement Be a diplomat NOT a technologist in the
context of a data warehouse development project?

Question No: 22 ( Marks: 2 )
Elaborate the concept of data parallelism.

Question No: 23 ( Marks: 2 )
What will be the effect if we program a package by using DTS object model?

Question No: 24 ( Marks: 3 )
What is meant by the classification process? How we measure the accuracy of
classifiers?

Question No: 25 ( Marks: 3 )
How page dimension captures the static and dynamic nature of different web
pages?
Question No: 26 ( Marks: 3 )
Write down the limitations of pipelining parallelism?

Question No: 27 ( Marks: 5 )
For a maximum performance of Bitmapped index, what characteristics a query
should have?

Question No: 28 ( Marks: 5 )
How the three parallel tracks capture the user requirements in the Kimball s data
warehouse life cycle Road Map?

Question No: 29 ( Marks: 5 )
How time contiguous log entries and HTTP secure socket layer are used for user
session identification? What are the limitations of these techniques?

Question No: 30 ( Marks: 10 )
What are the issues regarding the record management tools at campuses where
text files are used to store data?

Question No: 31 ( Marks: 10 )
Shared RDBMS architecture requires a static partitioning. How do you perform the
partitioning.