Question
Which of the following statements is
correct?Solution
The correct answer is C
Which OLAP operation involves focusing on a subset of dimensions (e.g., region=‘Asia’)?
Which OLAP operation allows drilling down into more detailed data?
ETL stands for:
Which of the following commands is part of the Transaction Control Language (TCL) in SQL?
A Fact Constellation Schema is also called:
In a data cube, what does "slice" operation do?
Surrogate keys are used in data warehouses because:
Which type of slowly changing dimension (SCD) preserves full history by adding a new row for each change and using effective date ranges?
In a snowflake schema of a data warehouse, which of the following consequences is most likely as a result of normalization of dimension tables?
Which operation in OLAP allows selecting a single dimension from a cube?
