Latest topics

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...

Data Warehouse Overview (Photo credit: Wikipedia ) 1. The full form of OLAP is A) Online Analytical Processing B) Online Advanced Processing C) Online Advanced Preparation D) Online Analytical Performance 2. ......................... is a subject-oriented, integrated, time-variant, nonvolatile collection or data in support of management decisions. A) Data Mining B) Data Warehousing C) Document Mining D) Text Mining 3. The data is stored, retrieved and updated in .................... A) OLAP B) OLTP C) SMTP D) FTP 4. An .................. system is market-oriented and is used for data analysis by knowledge workers, including managers, executives, and analysts. A) OLAP B) OLTP C) Both of the above D) None of the above 5. ........................ is a good alternative to the star schema. A) Star schema B) Snowflake schema C) Fact constellation D) Star-snowflake schema 6. The ............................ exposes the information being captured, stored, and managed by operational systems. ...

1. ...................... is an essential process where intelligent methods are applied to extract data patterns. A) Data warehousing B) Data mining C) Text mining D) Data selection 2. Data mining can also applied to other forms such as ................ i) Data streams ii) Sequence data iii) Networked data iv) Text data v) Spatial data A) i, ii, iii and v only B) ii, iii, iv and v only C) i, iii, iv and v only D) All i, ii, iii, iv and v 3. Which of the following is not a data mining functionality? A) Characterization and Discrimination B) Classification and regression C) Selection and interpretation D) Clustering and Analysis 4. ............................. is a summarization of the general characteristics or features of a target class of data. A) Data Characterization B) Data Classification C) Data discrimination D) Data selection 5. ............................. is a comparison of the general features of the target class data objects against the general features of objects from on...