Data Warehousing - Quiz 1 - 2017 BITS WILP - Mtec Software Systems

Data Warehousing - Quiz 1 

BITS WILP - Mtec Software Systems - 2017 

1_________ component involves purging source data that is not useful and separating out source records into new combinations.
Select one:
 a. Source Data
 b. Data Staging
 c. Management and Control
 d. Data Storage

 Ans : b. Data Staging

2 ______ is the navigational map of the data warehouse.
Select one:
 a. Operational Metadata
 b. Extraction Metadata
 c. End-User Metadata
 d. Transformation Metadata

 Ans: c. End-User Metadata

3)Strategic information IS NOT used for which for the following purpose?
Select one:
 a. formulate the business strategies
 b. Increase the customer base
 c. process business transactions (e.g., generate invoice, payments, orders, etc.)

 Ans: c. process business transactions (e.g., generate invoice, payments, orders, etc.)

4). __________ are either identical or strict mathematical subsets of the most granular, detailed dimension.
Select one:
 a. Factless Fact Tables
 b. Conformed Facts
 c. Conformed Dimensions
 d. Degenerate Dimensions

 Ans : c. Conformed Dimensions

5)One of the primary benefits of ___________ keys is that they buffer the data warehouse environment from operational changes.
Select one:
 a. None of the Options
 b. Foreign
 c. Natural
 d. Surrogate

 Ans: d. Surrogate

6).In a dimension table ________ conveys the level of detail associated with the fact table measurements.
Select one:
 a. grain
 b. attribute
 c. dimension
 d. metadata

 Ans: a. grain

 7)The precursors required to load the data into the data warehouse presentation area are:
Select one:
 a. Combining data from multiple sources
 b. All the options
 c. Deduplicating data
 d. Cleansing the data

 Ans: b. All the options

 8)What is / are the feature/ features of Data Warehouse?
Select one:
 a. Data Granularity
 b. Time - Variant Data
 c. Nonvolatile Data
 d. All of the Options

 Ans: d. All of the Options

 9).____________ modeling is a design technique that seeks to remove data redundancies.
Select one:
 a. 1NF
 b. 3NF
 c. 2NF
 d. BCNF

 Ans: b. 3NF

 10) ____________ is a systematic process for capturing, integrating, organising and communicating knowledge accumulated by employees.
Select one:
 a. Agent Technology
 b. Multidimensional Analysis
 c. ERP
 d. Knowledge Management

 Ans : d. Knowledge Management