Question
An owner of a business has invested Rs 10,00,000 in
business. He wants a 15% ROI on his money. From an analysis of recent cost figures, he finds that his variable cost of operating is 50% of sales; his fixed costs are ₹ 250,000 per year. You need to calculate the sales volume that must be obtained to break even?Solution
Variable Cost Ratio = 50% P/V Ratio = 1 – Variable Cost Ratio = 1 – 50% = 50% (a) Break Even Point (in ₹) = Fixed Cost / PV Ratio = 250,000 / 50% = 500000
A Fact Constellation Schema is also called:
In a data cube, what does "slice" operation do?
Which schema in data warehousing uses a central fact table connected to dimension tables?
Which of the following commands is part of the Transaction Control Language (TCL) in SQL?
Which type of OLAP allows analysis of multidimensional data stored in relational databases?
A surrogate key is:
Which OLAP operation involves focusing on a subset of dimensions (e.g., region=‘Asia’)?
What is the primary function of ETL in a data warehouse environment?
Which OLAP operation summarizes data along a dimension?
In a snowflake schema of a data warehouse, which of the following consequences is most likely as a result of normalization of dimension tables?
