Question
Which of the following is NOT a characteristic of OLAP
systems?Solution
OLAP is for analytical processing of historical data; OLTP handles real-time transactions.
Which OLAP operation summarizes data along a dimension?
Which analytics type is focused on predicting future outcomes?
Which of the following best describes a fact constellation schema in a data warehouse?
In a data cube, what does "slice" operation do?
Which type of schema normalizes dimension tables into multiple related tables?
ETL stands for:
What does "drill-down" operation in OLAP do?
What is the primary function of ETL in a data warehouse environment?
Which process loads data from multiple sources into a data warehouse?
A snowflake schema is different from a star schema because: