CS614 Midterm Past Paper Special 2005

CS614 Data Warehousing · Mid Term Examination – Special Semster 2005 · Time Allowed: 90 Minutes

a. If you think that there is something wrong with any of the questions, attempt it to the best of your understanding.

Total Questions: 8

Q1. Marks : 15

Briefly explain the following questions. (5 each)

Write a typical OLTP Query and explain why it is different from DWH Query. Briefly explain the Enrichment basic Data Transformation task?

What is the major transformation of Decoding of Fields?

Q2. Marks : 15

Give precise answer to the following questions. (5 each)

Define ETL. List three typical Operating Systems that are found while doing ETL?

Briefly explain the selection basic Data Transformation task?

What is meant by "grain" in the context of a data warehouse? Give at least three examples.

Q3. Marks :01

Every dimensional model is composed of one --------- · table · o

Central

o

Parallel

o

o

Horizontal Vertical

Q4. Marks : 01

In Online Data Extraction data is extracted directly from the ------ system itself.

o

Host

o

Destination

o

o

Terminal Source

Q5. Marks : 01

Triggers can be created in operational systems to keep track of recently --- records.

o

o

Updated Deleted

o

Inserted

Q6. Marks : 01

ETL stands for ---------------

o

Extract, transform and load

o

Extended transformation loading

o

Enhanced logical transformation

Q7. Marks : 01

There is a relationship between the grain and the · dimensions · o

True

o

False

Q8. Marks : 15

Write down the short notes on followings: (5 each)

Define data warehouse. Differentiate conventional RDBMS and Data warehouse system? Online Data Extraction? How does CDC (Change Data Capture) ensured using Triggers?