Solved MCQ of Data Warehouse set-3
OLAP Cube illustration (Photo credit: Wikipedia ) 1. Data warehouse architecture is based on ....................... A) DBMS B) RDBMS C) Sybase D) SQL Server 2. .......................... supports basic OLAP operations, including slice and dice, drill-down, roll-up and pivoting. A) Information processing B) Analytical processing C) Data mining D) Transaction processing 3. The core of the multidimensional model is the ....................... , which consists of a large set of facts and a number of dimensions. A) Multidimensional cube B) Dimensions cube C) Data cube D) Data model 4. The data from the operational environment enter ........................ of data warehouse. A) Current detail data B) Older detail data C) Lightly Summarized data D) Highly summarized data 5. A data warehouse is ...................... A) updated by end users. B) contains numerous naming conventions and formats C) organized around important subject areas D) contain only current data 6. Business Intelligence