data warehousing 8th-term BSCS-BSIT UOS 2023
Discussion
Ask a question about this paper, or help someone else with theirs. Answers are emailed to whoever asked.
No questions yet — be the first to ask.
More Data Ware House papers
See all
Paper text
Subject: CS/IT
Time Allowed: 02:30 Hours
University of Sargodha
BS 8i Term Examination 2023
Paper: Data Warehousing (CSEC-406/1TFC-420)
Maximum Marks: 80
Note:
Objective part is compulsory. Attempt any three questions from subjective part.
ustadni.com
Objective Part
(Compulsory)
.conY
Q.1.
i.
ii.
iii.
iv.
V.
vi.
vii.
vili.
ix.
X.
xi:
xii.
xiii•
xiv.
XV.
xvi.
Define data warehousing.
Write short answers of the fallowing in 3,d Thes cach on your answer sheet.
(2*16)
What do you mean by operational tabase?
Explain term metadata.
Differentiate between OLAP and MOLAP.
What do you mean by semantic conflict?
ustadni.com
Briefly explain the term minimility.
Explain the term HOLAP
Explain the purpose of analysis and reconciliation of data sources.
What is the purpose of optional Arcs?
How can data be accessed in a data warehouse?
What are the risk factors associated with the data warehouse system lifecycle?
Compare and contrast the top-down and bottom-up approaches in data warehousing.
What are the key phases in data mart design, and how are data marts tested?
How do you inspect and normalize schemata in the analysis and reconciliation of data sources?
What are the different approaches to conceptual design in data warehousing?
What factors are considered in workload and data volume analysis in data warehousing?
Subjective Part
(3*16)
Q.2.
Explore the process of analysis and reconciliation of data sources in data warehousing. How schema
inspections and normalization carried out? provide examples to illustrate these concepts.
Q.3/
User requirement analysis is a critical step in data warehousing. Explain the methods used,
including interviews, glossary-based requirement analysis, and addressing additional requirements.
Q.4.
What do you mean by architecture of data warehouse? Explain its types in details.
Q.5.
Write a detail riote on data driven approach and requirement driven approach.
Q.6.
ustac
Write,a detail note on data mart design phase.
ustadni.com
ustadni.com
LK-6445,6446/28-12-23