A) What are the basic building blocks of Data Warehouse?
B) The college wants to record the marks for the courses completed by the students using the dimensions: a) Course, b) student, c) time and a measure aggregate marks. Create a cube and describe following operations: i) Roll up, ii) Drill down, jii) Slice and iv) Dice.
C) Explain ETL process in detail
D) Short note on Fact Constellation Schema
E) Every data structure in the data warehouse contains the time element. Why?
F) For a supermarket chain, consider the following dimensions namely product, store, time and promotion. The schema contains a central fact table for sales with three measures unit_ sales, dollars_sales and dollar_cost.
G) Explain Updates to dimensional table in detail
H) Differentiate between ER modeling vs Dimensional modeling
I) llustrate major steps in ETL proces
J) A social media platform wants to analyze user engagement data to improve content recommendations and user experience. The INTERACTIONS fact table contains information about user interactions, including interaction details, user information, content details, and time periods. The dimension tables provide additional context about users, content, categories, and time periods. Design a star schema and snowflake schema for the same.
K) What are the basic building blocks of Data warehouse?
L) Compare OLTP and OLAP
M) Differentiate between top-down and bottom-up approaches for building data warehouse3. Discuss the merits and limitations of each approach4. Also explain the practical approach for designing a data warehouse
N) Differentiate between Star schema and Snowflake schema. Design Star schema for company sales with three dimensions such as Location, Item and Time.
O) Compare OLTP vs OLAP systems
P) The college wants to record the Marks for the courses completed by students using the dimensions: I) Course, II)Student, III) Time & a measure Aggregate marks . Create a cube and describe following OLAP operations : I) Slice II) Dice III) Roll up IV) Drill Down V)Pivot
Q) What is dimensional modeling? Design the data warehouse dimensional model for a wholesale furniture Company. The data warehouse has to analyze the company’s situation at least with respect to the Furniture, Customer and Time. Moreover, the company needs to analyze: The furniture with respect to its type, category and material. The customer with respect to their spatial location, by considering at least cities, regions and states. The company is interested in learning the quantity, income and discount of its sales.