Question
The speed of the stream is 10 km/h. Boat βAβ covers
110 km distance against the stream in 11 hours and boat βBβ covers 65 km distance against the stream in 2 hours. The speed of boat βBβ in still water is how much percent of the speed of boat βAβ in still water?Solution
Speed of boat βAβ upstream = 110/11 = 10 km/h Speed of boat βBβ upstream = 65/2 = 32.5 km/h Speed of the boat βAβ in still water = 10 + 10 = 20 km/h Speed of the boat βBβ in still water = 32.5 + 10 = 42.5 km/h Required percentage = (42.5/20) Γ 100 = 212.5%
'Data modelling' means:
In a data warehouse, a fact table typically contains:
In a data cube, what does "slice" operation do?
Which OLAP operation involves focusing on a subset of dimensions (e.g., region=βAsiaβ)?
Which OLAP operation allows drilling down into more detailed data?
Which of the following is a key process in ETL?
Which type of data warehouse is focused on specific business lines or departments?
Which type of OLAP allows analysis of multidimensional data stored in relational databases?
A star schema in a data warehouse consists of:
Which OLAP operation allows users to view data at different levels of granularity?