1) Which of the following is NOT an example of a typical grain

1. Individual Transactions
2. Monthly aggregates
3. Normalized attributes
4. Daily aggregates

2) Which of the following is not an example of dimension

1. Sales amount
2. ATM card no
3. Time/Date
4. ATM_Location

3) Which of the following statement is/are TRUE regarding Entity relationship modeling

1. ER modeling helps retrieval of individual records having certain critical identifiers
2. It does not really model business; but models the micro relationships among data elements
3. All of the given options
4. ER modeling does not have business rules, it has data rules;

4) Flat files are one of the prevalent structures used in _________ data extraction.

1. Full
2. Incremental
3. Online
4. Offline

5) Enrichment is one of the basic tasks in data __________

1. Loading
2. Summarization
3. Transformation
4. Extraction

6) If a table is expected to have six columns but some or all of the records do not have six columns then it is example of:

1. Semantically dirty data
2. Extraction issue
3. Syntactically dirty data
4. Coverage anomaly

7) Which Logical Data Extraction has significant performance impacts on the data warehouse server

1. Online Extraction
2. Offline Extraction
3. Incremental Extraction
4. Legacy vs. OLTP

8) __________ models the macro relationships among data elements with an overall deterministic strategy

1. Dimensional model
2. Object oriented model
3. Structured model
4. Entity relationship model

9) Online Extraction is a kind of _______ data extraction.

1. Physical
2. Dimensional
3. Logical
4. Multivalued

10) There are often multiple ways to represent the same piece of information, “FAST”, “National University”, “FAST NU” and “Nat. Univ. of Computers” This problem is known as ________

1. Simple Key problem
2. Composite key problem
3. Non primary key problem
4. Primary key problem