CS614 Data Warehousing Spring 2009 Final Term Paper

[viki]

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
  

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.