Question
Anjali sold 50% of her apples and was left with 25 less
than 60% of what she originally had. Find the number of apples sold by Anjali.Solution
ATQ,
Let the total number of apples Anjali had be ‘x’
According to the question,
0.5x = 0.6x – 25
Or, x = 25 / 0.1 = 250
Therefore, number of apples sold by Anjali = 0.5x = 125
Which schema uses multiple fact tables sharing dimension tables?
What is the main purpose of a data mart?
Which SQL clause is used to summarize data?
In OLAP, “Slice and Dice” means:
Which OLAP operation rotates the data axes to provide an alternative presentation?
Which of these is not a typical data warehouse characteristic?
Which type of slowly changing dimension (SCD) preserves full history by adding a new row for each change and using effective date ranges?
In a data warehouse, a fact table typically contains:
A snowflake schema differs from a star schema mainly because:
Which of the following is a key process in ETL?