Q1. Describe at least four advantages of granularity of data in the warehouse design.
Q2. Distinguish between the Data cleaning, data transformation and refresh.
Q3. Describe the four levels of data in architectural environment.
Q4. Explain how is the dimensional modeling tool well suited for a data warehousing as compared to the semantic data model similar to ER model?
Q5. Describe the benefits of a star schema.
Q6. Describe primary and secondary data in the context of snapshots in data warehouse.
Q7. Describe the terms Index Only Processing and Fast Restore.