Solved MCQ of Data Warehouse set-3

OLAP Cube illustration (Photo credit: Wikipedia)1. Data warehouse architecture is based on .......................A) DBMSB) RDBMSC) SybaseD) SQL Server 2. .......................... supports basic OLAP operations, including slice and dice, drill-down, roll-up and pivoting.A) Information processingB) Analytical processing C) Data miningD) Transaction processing3. The core of the multidimensional model is the ....................... , which consists of a large set of facts and a number of dimensions.A) Multidimensional cubeB) Dimensions cubeC) Data cubeD) Data model4. The data from the operational environment enter ........................ of...

Read more »

MCQ on Data Warehouse with Answers set-2

Data Warehouse Overview (Photo credit: Wikipedia)1. The full form of OLAP isA) Online Analytical ProcessingB) Online Advanced ProcessingC) Online Advanced PreparationD) Online Analytical Performance2. ......................... is a subject-oriented, integrated, time-variant, nonvolatile collection or data in support of management decisions.A) Data MiningB) Data WarehousingC) Document MiningD) Text Mining3. The data is stored, retrieved and updated in ....................A) OLAPB) OLTPC) SMTPD) FTP 4. An .................. system is market-oriented and is used for data analysis by knowledge workers, including managers, executives, and analysts.A)...

Read more »