Question
160 ml of mixture A containing milk and water in the
ratio of 3:2 respectively is mixed with another 160 ml of mixture B containing milk and water in the ratio of 1:4 respectively. Find the ratio of milk to water in the resultant mixture.Solution
Quantity of milk in 160 ml of mixture A = 3/5 × 160 = 96 ml
Quantity of water in 160 ml of mixture A = 2/5 × 160 = 64 ml
Quantity of milk in 160 ml of mixture B = 1/5 × 160 = 32 ml
Quantity of water in 160 ml of mixture B = 4/5 × 160 = 128 ml
Desired Ratio = (96 + 32):(64 + 128) = 128:192 = 2:3
ETL stands for:
Fact constellation schema is best described as:
What is the primary function of ETL in a data warehouse environment?
Which SQL query will correctly calculate the average salary of employees in each department and group them by department in a table named 'employees'?
A snowflake schema differs from a star schema mainly because:
Which of the following is NOT a common OLAP operation?
Data cleansing is primarily concerned with:
In ETL pipelines, which step is primarily responsible for resolving inconsistencies and correcting data quality issues (e.g., missing values, inconsiste...
What is the main purpose of a data mart?
Which of the following best describes a Data Warehouse?