Question
There are ten numbers such that the average of the first
three numbers is 15 and the average of the last five numbers is 22. If the average of the fourth and fifth number is 17, then find the average of all the numbers.Solution
ATQ,
Average of all the 10 numbers = {(3 × 15) + (5 × 22) + (2 × 17)/10}
= {(45 + 110 + 34)/10} = 189/10 = 18.9
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:
