Question
A and B started a retail store with initial investments
in the ratio 5:6 and their annual profits were in the ratio 2:3. If A invested the money for 4 months, then for how many months did B invest his money?ÂSolution
Suppose A invested Rs. 5x for 4 months and B invested 6x for y months then, ⇒  (5x × 4)/(6x × y) = 2/3 ⇒  y = (20x × 3)/(6x × 2) ⇒  y = 60x/12x ⇒  y = 5
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:
