1. OLTP stands for ___.

Ans. Online Analytical Processing

2. OLTP handles day to day business transactions (true/false)

Ans. True

3. Updates on the Data Warehouse is allowed (true/false)

Ans. False

4. Data Warehouse is a database that is designed for facilitating ___ and ___.

Ans. Query and Analysis

5. Data Warehouse is defined as subject-oriented, integrated, time-variant and ___.

Ans. Non-Volatile

6. Data Warehouse contains only aggregated data and individual transactions (true/false)

Ans. True

7. List the types of the data warehouse.

Ans. Real-time, federated and distributed

8. ___ data Warehouse will allow changes in the information to be monitored and recorded over
time.

Ans. Time-variant

9. The Data Warehouse functions as ___ and an Executive Information System (EIS).

Ans. DSS

10. Data about data is called ___.

11. Data Warehouse contains data for ___ purpose.

Ans. Analysis

12. Data Warehouse is a storehouse of ___ data.

Ans. Historical

13. In most organizations, two groups of people are key to the success of the project, ___ and ___.

Ans. Senior Management and Working Management

14. OLTP systems are designed for ___.

Ans. Real-time business operations

15. Data Warehouses does not require real-time validation (True / False)

Ans. True

16. In most organizations, two groups of people are key to the success of the project, ___ and ___.

Ans. Senior Management,

17. In Data Warehouse, the requirements are gathered subject area wise. (True / False)

Ans. True

18. The 3 major functions that needed to be performed for getting the data ready into the Data
Warehouse are extraction, transformation and ___.

Ans. Loading

19. ___ and ___ of data take place on a large scale in the data staging area.

Ans. Sorting and Merging

Ans. Data Mining

21. The main purpose of E-R modelling is

a. To remove redundancy

b. To improve analysis for decision-making

c. To record historical data

d. None

Ans. A

21. E-R modelling and Dimensional modelling are the same (True / False)

Ans. No

22. A Dimension is an entity or subject area, which can group the data (True / False)

Ans. True

23. Dimensional model consists of ___ and ___ tables.

Ans. Dimensions and fact tables

24. ___ is often used in dimensional modelling.

Ans. Text data

25. Fact –tables usually consist of ___to___ relationships.

Ans. Many to many

27. Dimensional model can be implemented with the following databases,

a. Relational database

b. MDDB
c. Flat files

d. Excel data files

e. None

Ans. A

28. Customer name change in the dimensional model comes under ___.

Ans. Slowly-changing-dimension

29. The most popular model for the data warehouse is ___.

Ans. Multidimensional model

30. Which of the following schema supports the normalization in dimensional modelling?

a. Star Schema

b. Snow-Flake schema

c. Fact-Constellation

Ans. A

31. Each dimension table is in ___ relationship with the central fact table.

Ans. One-to-many

32. Dimensional table and a fact table can be connected with the following database keys:

a. Foreign key

b. Surrogate key

c. Candidate key

Ans. A

33. For sales analysis units sold is a ___ kind of measure.

Ans. Additive numeric measure

Ans. True

35. In Data Warehouse a system with multiple architectures is called ___

Ans. Federated Data Warehouse architecture

36. Data marts are,

a) Department level

b) Limited in size

c) Read-only

d) All the above

Ans. D

37. Data Warehouse functions are a Decision support system and ___.

Ans. EIS

38. Info Data extraction, ___ and ___ encompass the areas of data acquisition and data storage.

Ans. Transformation and Loading

39. Populating all the Data Warehouse tables for the very first time is called ___.

Ans. Initial Load

40. Which of the following are open source ETL tools?

a) SAS Data Integrator

b) Ascetical Data Stage

c) Cognos Decision Stream

d) Microsoft DTS

e) Clover

Ans. Clover
41. Average daily balances ___ attribute.

Ans. Derived attribute

42. OLAP stands for ___

Ans. Online analytical processing

43. OLAP tools enable the user to access the data in Data Warehouse in an interactive manner (True /
False)

Ans. True

44. ERP and CRM are ___ kinds of systems.

Ans. OLTP

45. Data cube contains ___ and ___.

Ans. Dimensions and Facts

46. A dimensional table contains hierarchies (True / False)

Ans. True

47. Which of the following are the intermediate servers that stand in between a relational back-end
server and client front-end tools?

a. ROLAP

b. MOLAP

c. HOLAP

d. All the above

Ans. All

48. The advantage of using a data cube is that it allows fast indexing to precomputed summarized data.
(True / False)
Ans. True

49. In Data Warehouse, a single record link to all the duplicate record in the sources systems is called
___.

Ans. De-duplication

50. Sorting the data in the given source file is a transformation (True / False).

Ans. True

51. OLTP is abbreviated as ___

Ans. Online transaction processing

52. Query response time is ___ kind of metadata.

Ans. Operational metadata

53. Key hierarchies and key performance indicators are ___ kind of Metadata.

Ans. Business metadata

54. Storing, data mapping and transformation from source systems to the data warehouse fall into:

a. Technical metadata

b. Operational metadata

c. Business metadata

Ans. A

55. According to Ralph Kimball, Back-room metadata guides:

a. Extraction

b. Cleaning

c. Loading processes

d. All the above

56. One tool that can allow data warehouse managers to deal with metadata is called___.

Ans. Repository

57. Access rights, protocols are ___ metadata.

Ans. Administrative metadata

58. Data about data is called ___.

Ans. Metadata

59. Information can be converted into knowledge about ___ patterns and future trends.

Ans. Historical

60. Data about data is called ___.

Ans. Metadata

61. The ___ software gives the user the opportunity to look at the data from a variety of different
dimensions.

Ans. Multidimensional Analysis

62. ___ Optimization techniques are based on the concepts of genetic combination, mutation, and
natural selection.

Ans. Genetic algorithms

63. Based on the overall requirements of business intelligence, the ___ layer is required to extract,
cleanse and transform data into load files for the information warehouse.

Ans. Data integration

64. Data Mining is not a business solution; it is just a technology. (True/False)

65. ___ is used to refer to systems and technologies that provide the business with the means for
decision-makers to extract personalized meaningful information about their business and industry.

Ans. Business Intelligence

66. OLAP Supports ___ user access and multiple queries.

Ans. Multiple

67. Statistics techniques are incorporated into Data mining methods. (True/False).

Ans. True

68. A priori algorithm operates in ___ method

a. Bottom-up search method

b. Breadth-first search method

c. None of the above

d. Both a & b

Ans. D

69. A bi-directional search takes advantage of ___ process

a. Bottom-up process

b. Top-down process

c. None

d. Both a & b

Ans. D

70. The pincer-search has an advantage over a priori algorithm when the largest frequent itemset is
long. (True/false)

Ans. True