Q1. Why monitoring of data in the Data Warehouse is needed?
Q2. Describe the given terms:
a) Efficient Index Utilization of data
b) Compaction of Data
c) Compound Keys
d) Lock Management
Q3. Validate ‘The mapping of local data to global data is the hardest aspect of building the global data warehouse’.
Q4. Describe Redundancy or overlap of data with respect to the global data warehouse and its supporting local data warehouses.
Q5. Describe with the help of an illustration the building and operation of totally unrelated warehouses.
Q6. Who must be in the Data Warehouse design review?
Q7. Illustrate the technological challenges in bringing the system-of-record data to the data warehouse?
Q8. Write detail notes on any two of the given terms:
a) Factless Fact Table
b) Fact Table is deep not wide
c) Drill Down Analysis
d) Event mapping in EIS processing