Data Warehousing BS-CS 8th-term University Of Sargodha 2024.
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
University of Sargodha
BS gm Term Examination 2024
Subiect: Computer Sciencs
Paper: Data Warchousing (CSFC-496)
Time Allowed: 02:30 Hours
(For Regular & Retake. Students)
Maximum Marka: 60
Note: Objective part is compulsory. Attempt any three questions from subjective part.
atadni.com
Objective Part
(Compulsory)
(2°12)
iv.
vi.
vit.
viii.
iX.
X.
xi.
xii.
What is Data Staging?
Define ETL.
What is metadata?
What is multidimensional model?
What are glossary based requirements?
Differentiate between MIS and DWH.
What are views?
Define adhoc access.
Define Star Schema.
What are Fact tables?
Define Datamart.
Write name of any two DWH tools.
ustadni.com
Subjective Part*
(3*12)
Q.2.
Q.3.
Q.4.
Q.5.
Q.6.
Explain the situation where companies prefer to apply MOLAP architecture.
Explain data warehouse life cycle in detail.
Discuss the architecture of data warehouse along with its components in detail.
What is conceptual modeling? Explain dimensional fact model, event and aggregation in detail.
Explain physical design model. How splitting a database into table space is performed?
ustadni.com-
- LK-6445/20-12-24
ustadni.com
ustadni.com