Question
Preeti spends 35% of her monthly income on consumable
items. Her annual income is Rs. 5.4 lac. What is the total amount that Preeti spends on consumable items in 8 months together?Solution
Preeti’s monthly income = 540000/12 = 45000 1 month’s expenses = 35% of 45000 So, 8 months’ Expense = 8 x 35 x 45000/100 = 126000
Surrogate keys are used in data warehouses because:
Which SQL clause is used to filter records after aggregation?
ETL stands for:
Which of these is not a typical data warehouse characteristic?
In a star schema, what is the main advantage of using surrogate keys in fact tables?
Which analytics type is focused on predicting future outcomes?
What is the result of SELECT COALESCE(NULL, NULL, 5, 10);?
Which SQL clause is used to summarize data?
Which OLAP operation allows drilling down into more detailed data?
Which OLAP operation summarizes data along a dimension?