7/28/2019 dwques

1/5

1

Data Warehousing Questions

1. What is a Data Mart?a) Database's used by a single business analyst

b) Database's used by the whole business organizationc) Scaled down version of a Data Warehouse usually

developed to solve a particular business problemd) A "view" of the Data Warehouse created within the

database management system

2. What is Data Webhouse?

a) An Active Data Warehouseb) A Data Warehouse which has the data feed from theInternet log and related data, and the information fromthe Data Warehouse web enabled

c) A collection Data Marts inter-connected as a Webd) A Operational Data Store, Data Mart and Data

Warehouse is called a Data Webhouse

3. Data Mart isa) Single Subject Oriented Data Warehouse

b) A collection of Data Warehousec) An Application on a Data Warehoused) None of the Above

4. Which one of the following is NOT an example of Operational

Systems?

a) Order Tracking Applications, such as catalog salesb) Customer service applications, such as setting up

customer accountsc) Banking functions, such as deposits and withdrawalsd) Sales forecasting applications

5. Which layer of the data warehouse architecture does an end userdirectly deals with

a) Staging layerb) External data layerc) Information access layerd) Data warehouse layer

6. What should be the primary source of data for a data mart?a) A subset of the data warehouse created in the database

management system

b) Data extracted from the target systemsc) The operational databasesd) Data extracted from the data warehouse databases

7. Where is Meta data usually store?a) Word Processing documents

b) Spread sheetsc) Information Repositoryd) All the above

8. Which of the following are the examples of dimensions?a) Customers

b) Timec) Productd) All the above

9. The process of populating a data warehouse is calleda) Loading

b) Extractingc) Transformingd) None of the Above

10. Architected Data Warehouse

a) Reduces server and client processing requiredb) Does not maintain historical integrityc) Inefficient data acquisitiond) None of the Above

11. Which one of the following are called 'Stove Pipe Systems'?

a) DataWarehouseb) Dependent Data Marts

c) Independent Data Martsd) Operational Data Stores

12. What is the advantage in going for a Bottom Up approach inbuilding a Enterprise Data Warehouse

a) Data Cleaning is not requiredb) Ensures that all departments get a Data Martc) Return on Investment can be felt at the earliest

d) Data Loading is Faster

13. Which of the following must be a function of a data Extractiontransformation tool?

a) Ability to retrieve data from all known database

management systemsb) Ability to store the data mart database designs and mthose designs available to the business analysts

c) Ability to translate data elements in the source systeinto data warehouse data

d) Ability to run on all known platforms and operatingsystems

14. The process of requesting detailed information

a) Drill upb) Drill leftc) Drill downd) Drill right

15. What is the difference between a Data Warehouse or Data Mar

and an Operational Data Store?

a) An operational data store contains more current datathan either a Data Warehouse or a Data Mart

b) An operational data store and a data warehouse or dmart track different subject areas in the organization

c) An operational data store is a copy of the data

warehouse or data martd) The operational data store tends to be larger than the

data warehouse or data mart

16. Data Warehousing Characteristics (i) Subject Oriented (ii) NonVolatile (iii) Time Variant (iv) Integrated (v) Time Invariant

a) (iii) &(i)&(iv)&(v) Onlyb) (i)&(ii)&(iv)&(v) Onlyc) (i)&(ii)&(iii)&(iv) Onlyd) All

17. Which process loads the data from heterogeneous source systemto the data warehouse

a) Cleaning

b) Miningc) ETL Processd) None of the Above

18. What does the term "Ad-hoc Analysis" mean?a) Business analysts access the Data Warehouse data fr

different locations.b) Business analysts use sampling techniquesc) Business analysts start query and analysis on the flyd) Business analysts access the Data Warehouse data

infrequently

19. Sparse Data in OLAP Cube indicatesa) Missing Datab) Data Repetitionsc) Zeroesd) Rare Data

20. What is an Operational System?a) An application system that supports the organization

day to day activitiesb) An application system that tracks and manages the

financial assets of the organizationc) An application system that supports the creation of

products(s) that the organization marketsd) An application system that supports the planning and

forecasting within the organization

7/28/2019 dwques

2/5

2

21. Which of the following are the advantages of creating individualmarts and then rolling them up into a central warehouse? 1)QuickSuccesses 2)Rapid prototyping of data transformations3)Duplication of data

a) 1 onlyb) 1 and 2 only

c) 1, 2 and 3d) None of the Above

22. Disadvantage of data mart isa) Does not provide integrated view of information

b) Uncontrolled proliferation results in redundancyc) More number of Data Marts are complex to maintaind) All of the above

23. Which of the following statements correctly describe a dimensiontable in Dimensional Modeling?

a) Dimension tables do not contain numeric fieldsb) Dimension tables do not need system-generated keysc) Dimension tables usually have fewer fields than fact

tablesd) Dimension tables contain fields that describe the facts

24. What is the most common use of a multi dimensional database(MDDB)?

a) Access pre determined aggregated data across several

dimensions

b) Access huge data warehousesc) Access application packagesd) As the only type of database management system used

for a data warehouse

25. Table Denormalization (a)Improves Query performance (b)Duplicates Information

a) Only (a) Trueb) Only (b) Truec) Both (a) and (b) Trued) None

26. Bit Mapped Indexing can be useda) When the distinct value of a column is high

b) When the distinct value of a column is lowc) When the storage space available is less

d) When the table is having very few rows

27. Which of the following is NOT a type of process typically done by

a OLAP tool?a) Creation of large, detailed transaction level reports

b) "WHAT IF" analysisc) "Slicing and Dicing" of the data with drill down when

something interesting is found.d) Time series analysis

28. Scheduling of various tasks needed to build and maintain a datawarehouse is taken care of by

a) Staging layerb) Process management layerc) Information access layer

d) Transformation layer

29. What is an Operational Data Store (ODS)?a) A set of database that support reporting from an

application systemb) A set of databases that provide integrated operations

data to serve the organization's day to day activitiesc) A set of database to provide operational data for a single

departmentd) A set of databases that support OLAP

30. OLAP that accesses the raw data lying in the RDBMS for reportingis called as

a) Multidimensional OLAP

b) Relational OLAPc) Hybrid OLAP

d) All the above

31. Data Warehouses and Data Marts assista) Reports to regulatory agencies

b) Audit reportingc) Decision Supportd) Accounting Reporting

32. Operational Data Store (ODS) Characteristics (a) Subject Orien(b) Volatile (c) Current or Near Current collection of data (d)integrated

a) (b)&(a)b) (a)&(b)&(c)&(d)

c) (d)&(c)d) (a)&(b)&(c)

33. What is a Fact Table in a Data Warehouse terminology?a) Any Table that has the history of a Business.

b) Table that contains Time related datac) Any Table present in a Data Warehouse Tabled) Table that contains measurable data.

34. What is the difference between a Data Warehouse or Data Marand an Operational Data Store?

a) An operational data store contains more current datathan either a Data Warehouse or a Data Mart

b) An operational data store and a data warehouse or dmart track different subject areas in the organization

c) An operational data store is a copy of the data

warehouse or data martd) The operational data store tends to be larger than the

data warehouse or data mart

35. Why data in a Data Warehouse called as Time Variant?

a) Because data in the data warehouse is accurate as ofsome moment in time

b) Because every key structure in the data warehousecontains - implicitly or explicitly -an element of timesuch as day, week, month, etc.

c) (a)&(b)d) Only (a)

36. Data Warehouse isa) Collection of History Data

b) Query Centric

c) Decision Support Systemd) All the above

37. Enterprise Data warehouse containsa) Only detailed data

b) Only summarized datac) Detailed and summarized datad) None of the Above

38. What is Snow Flake Schema in a Database design?a) The Dimension Tables have a Foreign Key Table.

b) The Dimension Tables do not have a Foreign Key Tc) The Fact Table has one Dimension Tabled) The Dimension table is Only of Time

39. In order to be successful at decision-making, what does anorganization need?a) Experienced decision makers

b) Adequate and timely datac) A corporate strategyd) All the above

40. Non Architectured Data Marts are also known as

a) Legacy Data Martsb) Lega Martsc) Non-Integrated Data Martsd) All of the above

7/28/2019 dwques

3/5

3

41. In building a data warehouse 60 - 80 % of work is required inwhich stage?

a) Database Designb) ETL deploymentc) OLAP deploymentd) Cleaning

42. Categories of OLAP Tools: Level 1- Basic query and display ofdata; Level 2- Level 1 + advanced selection and arithmeticoperations; Level 3- Level 1 and Level 2 + sophisticated dataanalysis techniques. Which of the following is an example of a

processa) Display a report based on specific selection criteriab) Drill down to another level of detailc) Calculate a rolling average on a set of datad) Display the top 10 items that meet a specific selection

criteria

43. The Fact Table is related to a Dimension Table in the DimensionalModeling by

a) One to Manyb) Many to Onec) One to Oned) Many To Many

44. Which of the following are considered to be advantages while

building a data warehouse?

a) The ability to access Enterprise-Wide datab) The ability to have consistent datac) The ability to perform analysis quicklyd) All the above

45. Ad-hoc access path, low transaction volume, low number of usersare the characteristics of which system

a) Informational systemb) Decision support systemc) Operational systemd) Transactional system

46. The key performance indicators of an enterprise area) Dimension attributes

b) Facts, Measuresc) Summary data

d) Detailed data

47. What is an Active Data Warehouse?

a) A Production Data Warehouseb) Close-coupled OLTP and Data Warehousec) Close-coupled Data Martsd) None

48. Executing a decision support query against an operational system

usually results ina) No change in performance

b) Degradation in performancec) Improvement in performanced) None

49. Data can be cleaned (a)at the source(b)during transformation(c)inthe Data Warehouse

a) Only (a)b) Only (b)c) Could be by all methods or any one of the methods

based on the Environment of Data Warehouse Setupd) Only (c)

50. What modeling technique would be used to design a specificdatabase that will be implemented with star schema?

a) Object Modelingb) Entity Relationship Modelingc) Dimensional Modeling

d) None of the Above

51. The person who defined rules for OLAP(OnLine AnalyticalProcessing) is

a) Bill Inmonb) Ralph Kimballc) C J Dated) E F Codd

52. What is a Dimension Table in Data Warehouse terminology?a) Any Table present in a Data Warehouse Table

b) Table of members, positions, or units of the same tywhich is used as categories by which data is analyze

c) Any Table storing measurable unitd) Table storing Data type that has a value to be analyz

53. In which schema only primary dimension tables are joined to ftables?

a. Star Schemab. Snow flaked schemac. Both star schema and snow flaked schemad. None of the Above

54. What is the substantial benefit of implementing a Data Warehoor Data Mart?

a) Improves the morale of the organization's knowledgworkers

b) Provides many new tools to the executives within th

organization

c) Increases technical knowledge within the executiveranks of the organization because they will have to lto use a computer

d) Improves decision-making within the organization

55. OLAP that accesses its own proprietary Data Storage for reporis called as

a) Multidimensional OLAPb) Relational OLAPc) Hybrid OLAPd) All the above

56. Characteristics of dimension tables area) Contains a primary key

b) Has one to many relationship to the fact table

c) Contains other attribute columns that are useful forlevels of aggregation

d) All the above

57. The type of Modeling used for the Database designing in StarSchema is

a) ER Modelingb) Dimensional Modelingc) Any Method

d) All the methods

58. The following statement fits for Data Mining (a) Its an ad hocreporting tool (b) Its a technology to find Hidden patterns in hudata

a) Only (a)

b) Only (b)c) Both (a) and (b)d) None

59. Degenerate dimensions can be represented asa) An entry in the fact table without an associated

dimension tableb) Dimension table that contain all attributes that are

necessary to provide query valuesc) An entry in the fact table with an associated dimensi

tabled) None of the Above

7/28/2019 dwques

4/5

4

60. REDBRICK and TERADATA databases are mostly used fora) OLTP applications

b) OLAP applicationsc) Both OLTP and OLAP applicationsd) OO Database applications

61. Which one of the following is NOT an example of measures?a) Order Quantity

b) Product namec) Dollar Valued) Inventory Count

62. Which of the following is a problem/analysis/study that could beassisted by using Clustering Data Mining Technique

a) Market Basket Analysisb) Credit Card Fraud Detectionc) Campaign Marketingd) Time Series Analysis

63. Which one of the following is the complete general process in theorder involved in building a Data Warehouse?

a) Evaluate Data ->Extract Data ->Store Datab) Extract Data ->Evaluate Datac) Extract Data->Store Data ->Evaluate Datad) None of the Above

64. Which one of the following is NOT an advantage of breaking a

Data Warehouse up into smaller Data Martsa) Data Marts are guaranteed to have shared fields

b) All data transformations from sources are commonc) It takes longer to develop the Data Warehouse due to

increased time for advanced planning and design

d) None of the Above

65. Which of the following statements are true about OLAP?a) Ad Hoc Reporting Tool

b) Has Drill through, Slice & Dice facilityc) Built on a Data Warehouse/Data Martd) All the above

66. Casual dimensions can be useda) As a helper table

b) For explaining why a record exists in a fact table

c) For integrating data marts into a data warehoused) For handling changes to the data.

66. Factless Fact tables are useda) For event tracking

b) For handling multi valued dimensionsc) As a helper tabled) None of the above

67. Helper tables are useda) For handling one to many relationships

b) For handling many to one relationshipsc) For handling many to many relationshipsd) None of the above

68. Which of the following is not true with for an ODS?a) It is integrated and subject orientedb) Contains current and detailed datac) Contains years of historical datad) Used for making tactical decisions

69. Conformed dimensions are useda) For handling multi valued dimensions

b) For integrating data marts into a data warehousec) For event trackingd) For explaining why a record exists in a fact table

70. Which of the following statements are not true?a) A collection of data marts does not equal a data warehouse.

b) A data warehouse contains summarized data.c) A data warehouse contains subject oriented, volatile, integrated and

cleansed data.d) None of the above

71. Metadata is associated with the followinga) Extraction Transformation and Loading

b) Front end accessc) Data warehouse administrationd) All of the above

72. Compound Growth Factor (CGF) is associated witha) Data explosion

b) Data integration

c) Scalabilityd) Data warehouse performance

73. The relationship between a fact table and a dimension table isa) One to One

b) One to Manyc) Many to Oned) Many to Many

74. Which of the following is suited for large, transaction intensiveapplications?

a) ROLAPb) MOLAPc) HOLAPd) DOLAP

75. An Architected Data Warehousea) Does not maintain historical integrity

b) Is inefficient with respect to data acquisitionc) Reduces server and client processing requiredd) Does not store historical data

76. A fact table is linked to a dimension table usinga) Surrogate keys

b) Compound keysc) Complex keysd) None of the above

77. The following methods can be used for handling slowly changingdimensions

a) Inserting a new field in the tableb) Inserting a new record in the table

c) Overwrite the existing datad) All of the above

78. In a Bottom Up data warehouse architecturea) The data warehouse is created first and then the data marts

b) The data marts are created first and then the data warehousec) A set of independent data marts are createdd) An enterprise data warehouse is created without creating data m

79. In a Top Down data warehouse architecturea) The data warehouse is created first and then the data marts

b) The data marts are created first and then the data warehousec) A set of independent data marts are createdd) An enterprise data warehouse is created without creating data m

80. Which of the statements are not true?a) A data mart contains less information than a data warehouseb) A data mart covers a single subject areac) Data marts can be used for creating a data warehoused) None of the above.

81. Which of the statements are not true for MOLAP Architecture?a) Processing overhead for large input data sets is high

b) The no of dimensions is usually restricted to 10 or lessc) Scalability is goodd) It has a good user interface and functionality

82. Which of the following is associated with coverage tables?a) Factless fact tables

b) Conformed dimensionsc) Casual dimensions

d) Helper tables

7/28/2019 dwques

5/5

5

83. Which of the following statements are false for surrogate keys?a) Surrogate keys should not be composed of natural keys glued

together.b) Surrogate keys should ideally be numeric integers.c) Surrogate keys should contain meaningful information.d) None of the above

84. How are dimensions in a Multi Dimensional database related?a) Hierarchically

b) In a Networkc) By an inverse list

d) Non of the above

85. The process of standardizing the data that is extracted from theoperational systems is known as

a) Transformationb) Cleansingc) Populationd) Data Staging

86. Which of the following is used for calculating the Compound GrowthFactor for an application?

a) Sparsity of the datab) Clustering of the datac) Number of dimensions and the number of levels in the dimension

hierarchy

d) All of the above

87. Which of the following is an MOLAP tool?

a) Holos (Segate Software)b) Business Objects

c) Brio Query Enterprised) DSS Server (MicroStrategy)

88. The term Corporate Information Factory is associated witha) Bill Inmon

b) Ralph Kimballc) Sid Adelmand) Chuck Kelley

89. Which of the following is suited for Near Line Storage?a) Photo optical storage

b) Siloed tape storagec) A and Bd) None of the above

90. Which of the following statements are false for ROLAP?a) Query performance is slower compared to MOLAP

b) Suitable for frequent updatesc) Scalability is poord) Summary tables are implemented in the relational database

91. Which type of modeling technique is associated with a data warehousing?a) Dimensional Modeling

b) ER Modelingc) Object Oriented Modelingd) All of the above

92. OLAP that access its own proprietary data storage for reporting is calledas

a) Multidimensional OLAPb) Relational OLAPc) Hybrid OLAPd) All of the above

93. Which of the following is not an ETL tool?a) Power Mart

b) Data Stagec) Scenariod) Data Junction

94. Majority of work involved in a data warehousing project is carried out inthis phase

a) Requirements gatheringb) Data warehouse design

c) ETLd) Data warehouse testing

95. What two types of processing are done in an exploration warehouse?a) Exploration and Data Mining

b) OLAP and Data Mining

c) Exploration and OLAPd) Data Mining and Multidimensional analysis

96. Data that is loaded into a data warehouse and never used is referred toa) Dormant data

b) Static datac) Operational datad) Time dependant data

97. What determines the class of an ODS?a) The type of data that is stored in the ODS

b) The speed of update synchronization from the operationalenvironment to the ODS

c) The duration of data that is stored in the ODS.d) The amount of time it takes to update the ODS

98. What is meant by a wrinkle of time?a) The time it takes to populate a data warehouse

b) The amount of time that elapses between the update of a recordthe operational environment and the time that the update is

reflected in the data warehouse

c) The granularity of the time dimension that is present in the datawarehouse

d) The time it takes to populate the data warehouse from the datastaging area

99. What is the metadata called that is used for the corporate informationfactory?

a) Exploration metadatab) Corporate metadatac) Distributed metadatad) Integrated metadata

100. When comparing ROLAP with MOLAT which of the followingstatements are true?

a) User interface and functionality is good in ROLAP and normalMOLAP.

b) MOLAP and ROLAP stores details and summarized data.c) The common access language for ROLAP and MOLAP is SQLd) ROLAP support for a large number of users is good where as t

is limited support in the case of MOLAP.