Exam Details
| Subject | data warehousing | |
| Paper | ||
| Exam / Course | mca | |
| Department | ||
| Organization | Gujarat Technological University | |
| Position | ||
| Exam Date | November, 2018 | |
| City, State | gujarat, ahmedabad |
Question Paper
1
Seat No.: Enrolment
GUJARAT TECHNOLOGICAL UNIVERSITY
MCA Integrated SEMESTER- VII- EXAMINATION WINTER 2018
Subject Code: 4470622 Date: 22-11-2018
Subject Name: Data Warehousing
Time: 10.30 am to 1.00 pm Total Marks: 70
Instructions:
1. Attempt all questions.
2. Make suitable assumptions wherever necessary.
3. Figures to the right indicate full marks.
Q.1
Answer the following
1. ETL stands
2. Define metadata.
3. What is Exploration Warehouse?
4. Define term: de-normalization
5. Explain concept hierarchy
6. Define the structure data.
7. ODS stands
07
Draw and explain the data warehouse architecture
07
Q.2
Differences between operational database systems and data warehouses.
07
Define data warehouse and explain the different data models.
07
OR
Why we need to build data mart? List the advantages and disadvantages of data mart
07
Q.3
What is the difference between ER Modeling and Dimensional Modeling?
07
What is a snapshot? Explain various triggers of a snapshot in brief.
07
OR
Q.3
What is meta data? How to manage reference tables in a data warehouse?
07
Explain in brief the feedback loop techniques for deciding the levels of granularity in a data warehouse.
07
Q.4
Explain the relation between EIS and data warehouse in detail.
07
What do you mean by contextual information? Explain its types and state their importance in the context of data warehousing environment.
07
OR
Q.4
Explain the different OLAP operation with suitable examples.
07
Explain the process of relating the structured and unstructured environments of data warehouse.
07
Q.5
What are the parameters to be consider while moving data from the web to the data warehouse?
07
Explain Data Driven Development Methodology.
07
OR
Q.5
How is unstructured data organized in a data warehouse? Explain the process of managing the volume of data in an unstructured data warehouse.
07
What do you mean by independent data mart? State its advantages and disadvantages.
07
Seat No.: Enrolment
GUJARAT TECHNOLOGICAL UNIVERSITY
MCA Integrated SEMESTER- VII- EXAMINATION WINTER 2018
Subject Code: 4470622 Date: 22-11-2018
Subject Name: Data Warehousing
Time: 10.30 am to 1.00 pm Total Marks: 70
Instructions:
1. Attempt all questions.
2. Make suitable assumptions wherever necessary.
3. Figures to the right indicate full marks.
Q.1
Answer the following
1. ETL stands
2. Define metadata.
3. What is Exploration Warehouse?
4. Define term: de-normalization
5. Explain concept hierarchy
6. Define the structure data.
7. ODS stands
07
Draw and explain the data warehouse architecture
07
Q.2
Differences between operational database systems and data warehouses.
07
Define data warehouse and explain the different data models.
07
OR
Why we need to build data mart? List the advantages and disadvantages of data mart
07
Q.3
What is the difference between ER Modeling and Dimensional Modeling?
07
What is a snapshot? Explain various triggers of a snapshot in brief.
07
OR
Q.3
What is meta data? How to manage reference tables in a data warehouse?
07
Explain in brief the feedback loop techniques for deciding the levels of granularity in a data warehouse.
07
Q.4
Explain the relation between EIS and data warehouse in detail.
07
What do you mean by contextual information? Explain its types and state their importance in the context of data warehousing environment.
07
OR
Q.4
Explain the different OLAP operation with suitable examples.
07
Explain the process of relating the structured and unstructured environments of data warehouse.
07
Q.5
What are the parameters to be consider while moving data from the web to the data warehouse?
07
Explain Data Driven Development Methodology.
07
OR
Q.5
How is unstructured data organized in a data warehouse? Explain the process of managing the volume of data in an unstructured data warehouse.
07
What do you mean by independent data mart? State its advantages and disadvantages.
07
Other Question Papers
Subjects
- advance database management system
- advanced biopharmaceutics & pharmacokinetics
- advanced medicinal chemistry
- advanced networking (an)
- advanced organic chemistry -i
- advanced pharmaceutical analysis
- advanced pharmacognosy-1
- advanced python
- android programming
- artificial intelligence (ai)
- basic computer science-1(applications of data structures and applications of sql)
- basic computer science-2(applications of operating systems and applications of systems software)
- basic computer science-3(computer networking)
- basic computer science-4(software engineering)
- basic mathematics
- basic statistics
- big data analytics (bda)
- big data tools (bdt)
- chemistry of natural products
- cloud computing (cc)
- communications skills (cs)
- computer aided drug delivery system
- computer graphics (cg)
- computer-oriented numerical methods (conm)
- cyber security & forensics (csf)
- data analytics with r
- data mining
- data structures (ds)
- data visualization (dv)
- data warehousing
- data warehousing & data mining
- database administration
- database management system (dbms)
- design & analysis of algorithms(daa)
- digital technology trends ( dtt)
- discrete mathematics for computer science (dmcs)
- distributed computing (dc1)
- drug delivery system
- dynamic html
- enterprise resource planning (erp)
- food analysis
- function programming with java
- fundamentals of computer organization (fco)
- fundamentals of java programming
- fundamentals of networking
- fundamentals of programming (fop)
- geographical information system
- image processing
- industrial pharmacognostical technology
- information retrieving (ir)
- information security
- java web technologies (jwt)
- language processing (lp)
- machine learning (ml)
- management information systems (mis)
- mobile computing
- molecular pharmaceutics(nano tech and targeted dds)
- network security
- object-oriented programming concepts & programmingoocp)
- object-oriented unified modelling
- operating systems
- operation research
- operations research (or)
- pharmaceutical validation
- phytochemistry
- procedure programming in sql
- programming skills-i (ps-i-fop)
- programming skills-ii (ps-oocp)
- programming with c++
- programming with java
- programming with linux, apache,mysql, and php (lamp)
- programming with python
- search engine techniques (set)
- soft computing
- software development for embedded systems
- software engineering
- software lab (dbms: sql & pl/sql)
- software project in c (sp-c)
- software project in c++ (sp-cpp)
- software quality and assurance (sqa)
- statistical methods
- structured & object oriented analysis& design methodology
- system software
- virtualization and application of cloud
- web commerce (wc)
- web data management (wdm)
- web searching technology and search engine optimization
- web technology & application development
- wireless communication & mobile computing (wcmc)
- wireless sensor network (wsn)