Question
Which of the following is NOT a direct benefit of
encapsulation?Solution
While encapsulation contributes to good design, reducing code duplication is more directly addressed by principles like inheritance or composition, and by using well-designed functions/methods. Encapsulation primarily focuses on data protection and controlled access within a single class.
Surrogate keys are used in data warehouses because:
Which SQL clause is used to filter records after aggregation?
ETL stands for:
Which of these is not a typical data warehouse characteristic?
In a star schema, what is the main advantage of using surrogate keys in fact tables?
Which analytics type is focused on predicting future outcomes?
What is the result of SELECT COALESCE(NULL, NULL, 5, 10);?
Which SQL clause is used to summarize data?
Which OLAP operation allows drilling down into more detailed data?
Which OLAP operation summarizes data along a dimension?