Question
A 65-litre mixture contains only water and oil in the
ratio 3:2, respectively. If 35 litres of the mixture is replaced with the same quantity of oil, then find the quantity of oil in the final mixture.Solution
Amount of oil in the mixture = 65 × (2/5) = 26 litres Amount of oil withdrawn = 35 × (2/5) = 14 litres Quantity of oil in the final mixture = 26 – 14 + 35 = 47 litres
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?
Relevant for Exams:
