General Data Warehousing MCQs

1. Which of the following implements Multidimensional OLAP?

2. Which of the following is true about Data Scrubbing?

3. Operational Database(OLTP) is based on which of the following?

4. The ‘Slice’ operation deals with?

5. Which of the following is NOT a benefit of data warehousing?

6. Where does cleansing take place during the ETL phase of data bound for a MOLAP based data warehouse?

7. Which of the following is true about Specialized SQL servers?

8. A data warehouse is built as a separate repository of data, different from the operational data of an enterprise because?

9. What is an example of an OLAP dice operation?

10. What table is at the center of a star schema?

11. Which of the following is TRUE about ROLAP?

12. Which of the following is VALID about time-variant characteristic of a data warehouse?

13. Which of the following is TRUE about MOLAP?

14. Which of the following is true about Data mining?

15. Which of the following systems is optimized for multidimensional analysis?

16. Which of the following are valid Logical Extraction methods?

17. Which of the following is true about Data Warehousing?

18. Which of the following is true about Snowflake schema?

19. What is the process by which raw data is migrated into a data warehouse?

20. Data Warehouse (OLAP) is based on which of the following?

21. Which of the following uses the idea of a data cube to represent the dimensions of data ?

22. Which system is appropriate for recording customer transactions in real time?

23. When is it appropriate to use a Joiner Transformation during ETL?

24. What is the "grain" of a fact table?

25. Which of the following operations navigate data from less detailed data to highly detailed data?

26. Which MDX operation returns all possible combinations of one or more sets?

27. Which language is appropriate for querying a non-relational OLAP database?

28. Modifying an OLAP Cube to view information from only a single year is an example of which operation?

29. Which of the following is an example of a non-aggregatable measure?

30. Which of the following is true about 'Pivot' operation?

31. Which of the following is a method for delta detection during the ETL process?

32. Which line is not a valid MDX comment?

33. What is a Data Mart?

34. Choose the most correct statement:

35. Which of the following would not be a part of the fact table of a star schema representing sales data?

36. Which of the following is not a VALID characteristic of data warehouse?

37. Which of the following environments has a higher amount of Joins

38. Which of the following operation is performed by introducing new dimensions?

39. Which of the following contains historical data?

40. What is an OLAP Cube?

41. Which of the following can present summary data from an OLAP server?

42. Which of the following enviroments are in third normal form 3NF?

43. Which of the following is true about multidimensional models?

44. Which of the following is true about 'Dice' operation?

45. Which operation on a multidimensional database is most equivalent to a relational join?

46. In which of the data storing approaches does transaction data get partitioned into facts?

47. What Amazon Reshift compression encodings would be most appropriate for the columns (Date, City, Description), respectively?

48. Which of the following is a property of Data Warehouse data?

49. Which of following stages involve data update in the warehouse for every transaction performed on the source data?

50. Which of the following is not a type of OLAP?

51. ‘ROLAP’ is preferred over ‘MOLAP’ in which of the following cases?

52. In a 3-tier architecture of the data warehouse, the OLAP engine is related to:

53. Which of the following operations performs aggregation on a data cube by dimension reduction?

54. In order to populate the data warehouse, which of the following set of operations are appropriate?

55. Among the following, which is NOT the objective of clustering?

56. Which of the following is the most appropriate data structure for indexing a MOLAP Cube?

57. Which of the following applies to Fact Tables?

58. When is a column-based engine a more appropriate architecture for a Data Warehouse than a row-based engine?

59. Which of the following is not a property of a perspective?

60. What is the principal disadvantage of Type 3 Slowly Changing Data management?

61. Which of the following is an appropriate method for mitigating the database explosion associated with sparse dimensions?

62. Which of the following is not TRUE about subject oriented characteristics of a data warehouse?

63. Which of the following is not a valid context for the MDX From clause?

64. An ETL Joiner Transformation is performed on Source A with 10,000 rows and Source B with 25,000 rows. Which source should be the master?

65. Which of the following is not an advisable implementation of division in MDX?

66. What is true of querying normalized data in a relational database for the purposes of business analysis?

67. Which of the following environments has more indexes?

68. What are the following is not a requirement of First Normal Form?

69. What is a slice in the context of Amazon Redshift?

70. Without deliberate security measures, which of the following MDX clauses is susceptible to injection attack?

71. Where is the OLAP page pool stored in memory in an Oracle Database 10g and later?

72. What property do Router Transformations and Filter Transformations have in common?

73. Online extraction process falls under which type of data extraction method?

74. Which of the following is a required property of information passed to the Microsoft Sequence Clustering Algorithm?

75. A data warehouse is an ‘integrated’ collection of data because?

76. All else being equal, which of the following elements of a single MDX WHERE clause will evaluate first?

77. Which is the modes of OLAP?

78. OLAP queries can be characterised as on-line transactions that do not:

79. Normalisation is:

80. Which would not be considered as a variable affecting the design of an OLAP system?

81. A slice is:

82. Which techniqe can be used to improve query performance?

83. The term OLAP was coined by:

84. The main objects used by OLAP programs are:

85. Granularity refers to the:

86. Which query would be correlated with a Data warehouse?

87. Data Volatility describes:

88. A multi-dimensional data set is sparse if:

89. Normalization applied to the dimension tables of a star schema is known as:

90. Replication refers to the:

91. ROLAP stands for:

92. In a star schema, a table which contains data about one of the dimensions is called a:

93. Which would not be an application of Data Mining in the banking field?

94. HOLAP stands for:

95. A structure that stores multi-dimensional information, having one cell for each possible combination of dimensions is known as:

96. Which Data Mining function/technique is used to analyse a collection of records over a period of time?

97. Which technique of Data Mining involves developing mathematical structures with the ability to learn?

98. A datawarehouse should be able to implement advanced query functionality. This means :

99. The modification of data as it is moved into the data warehouse is:

100. Which statement is incorrect regarding Data Mining?

101. Which would be the only similarity between a datawarehouse and OLTP system?

102. Which is not true regarding the process of Data Mining?

103. Data quality management refers to the fact that:

104. Which stage is concerned with the extraction of patterns from the data?

105. The Metadata of the data warehouse should at least contain:

106. Data Mining is also known as

107. Given the following steps between raw data and extracted knowledge, arrange them in the correct order

108. The data warehouse is typically a large database on a high performance SMP system. Here SMP stands for:

109. The main impetus behind data warehousing was:

110. SQL stands for:

111. Changing the view of the data to a higher level of aggregation is known as:

112. The movement of data from one environment to another is known as:

113. In which component of the enterprise is the data re-organised for analysis and information extracted from the data?

114. A means of extending the data accessible to the end user beyond that which is stored in the OLAP server is know as :

115. The logical organisation of data in a database is called:

116. Which type of data is most likely to be stored on some form of mass storage ?

117. The requirement that the datawarehouse RDBMS server must support hundreds and thousands of concurrent users while maintaining an acceptable query performance is known as:

118. Metadata does not include:

119. The main objective of Data Mining is:

120. In the Discovery model of Data Mining, the emphasis is on which of the following?

121. In a star schema, the central table which contains the individual facts being stored in the database is called a:

122. Which rule would be considered the central core of OLAP?

123. Changing the view of the data to a greater level of detail is known as:

124. A multidimensional cube records a set of data derived from:

125. Which Data Mining technique partitions the database so that each partition or group is similar according to some criteria or metric ?

126. Which is not associated with data warehousing?

127. Which is an architecture for OLAP?

128. Under OLAP terminology, slice and dice refers to:

129. In the Verification model of Data Mining, the emphasis is on which of the following?

130. The applications of Data Mining would not include:

131. A data warehouse is a 'subject-oriented, integrated, time-variant, non-volatile collection of data in support of management'

132. Which is not a purpose of Data Mining?

133. Which feature is required by OLAP application?

134. A _____ is usually a smaller version of a data warehouse, used by a single department or function.

135. A ________ is a data warehouse that is limited in scope.

136. The purpose of a data warehouse is to ________.