Data Warehousing Past Papers Exam Questions

By: Prof. Fazal Rehman Shamil

Guess Paper 1:Data Warehousing Fall – 2020 Past Papers

Time Allowed: 3 hours

Total Marks:    70, Passing Marks (35)

Q.1) (a) What is Data Warehouse? Discuss the difference between warehouse and database? (14)
(b) What is warehouse schema? Discuss about star schema?Q.2) (a) Discuss about the phases of warehouse architecture? (7,7)
(b) Explain indexing techniques used to organize the data in the data warehouse?Q.3) (a) What is data parallelism explain with example? (7,7)
(b) Under what condition an operation can be execute in parallel?Q.4) What are the two extremes for technical architecture design? Which one is better? (14)(14)
Q.5) What is mean by click stream? How it can be usefully in a web Data Warehouse environment?(14)
Q.6) You are manager of Data Warehouse, how you keep the data validate in term of secure data of validation?

Q.7) Write note on any two of the following: (7,7)
1. Business Data Warehousing (BDW)
2. Principles of Data Warehousing
3. Purposes of Data profiling

Guess Paper 2:Data Warehousing Spring – 2020 Past Papers

Time Allowed: 3 hours

Total Marks:    70, Passing Marks (35)

Q1. Define the following terms:

i. Data and Information
ii. Data dictionary
iii. Internal and External data
iv. Data warehousing
v. Unidirectional data flows

Q2. Explain the era of information based system in detail.

Q3. Discuss the principles of data warehousing in detail.

Q4. Write a comprehensive note on Data architecture of metadata.

Q5. Explain single, two and three -layer data architectures in detail.

Q6. Explain in detail the concept of modeling the Business Data Warehousing (BDW)

Q7. Write short notes on the following.
i. Historical Data
ii. Logical Architecture

Prof. Fazal Rehman Shamil