Which SQL query will correctly calculate the average salary of employees in each department and group them by department in a table named 'employees'?
In the context of a relational database, which of the following is NOT a characteristic of a candidate key ?
Which OLAP operation allows users to view data at different levels of granularity?
Which OLAP operation summarizes data along a dimension?
Which of the following best describes the primary function of a database index?
In a snowflake schema of a data warehouse, which of the following consequences is most likely as a result of normalization of dimension tables?
A snowflake schema is different from a star schema because:
A Fact Constellation Schema is also called:
In a star schema, what is the main advantage of using surrogate keys in fact tables?
Which process ensures data in a data warehouse is consistent and clean?
Relevant for Exams:
