1. Warehousing and ____ are substitutes for each other.
2. During ETL load we generally have
3. You need to create an index on the SALES table, which is 10 GB in size. You want your index to be spread across many tablespaces, decreasing contention for index lookup, and increasing scalability and manageability.
4. Which type of table is usually created to enable the building of scalable applications, and is useful for large tables that can be queried or manipulated using several processes concurrently?
5. In Star Schema Dimension tables are:
6. Centipede fact table means:
7. Dimensions are Confirmed when:
8. In 4 step dimensional process, declaring grain of business process is:
9. In datamarts stovepipe means:
10. In which type of SCD(Slowly changing dimensions) do we preserve history of data:
11. In general data in Data Warehousing is:
Business Warehousing MCQ
QUIZACK
