1. The ‘Slice’ operation deals with?
2. A data warehouse is built as a separate repository of data, different from the operational data of an enterprise because?
3. Which of the following is TRUE about MOLAP?
4. Which of the following is true about Snowflake schema?
5. Which MDX operation returns all possible combinations of one or more sets?
6. Which of the following is a method for delta detection during the ETL process?
7. Which of the following is true about 'Dice' operation?
8. In which of the data storing approaches does transaction data get partitioned into facts?
9. ‘ROLAP’ is preferred over ‘MOLAP’ in which of the following cases?
10. Which of the following is not a valid context for the MDX From clause?
11. An ETL Joiner Transformation is performed on Source A with 10,000 rows and Source B with 25,000 rows. Which source should be the master?
12. What are the following is not a requirement of First Normal Form?
13. A data warehouse is an ‘integrated’ collection of data because?
Data Warehousing MCQs | Topic-wise