MCQ

1. The process of extracting the data in data warehouse involves sources such as

a.(Data and functional design documents)

b.(Architecture resource planning documents and archives)

c. (OLTP, personal databases and spreadsheets)

d. (end users requirements documents)

2 .Why relationships are mapped between primary keys and foreign keys?

a. (To develop standalone tables)

b. (To allow one table to reference another)

c. (To secure the integrity of the tables)

d. (To serve as the bridge between users)

3.Why do we need to analyze transactions?

a. (To understand the general constraints related to the transactions)

b. (To eliminate critical transactions that may harm the functionality)

c.(To identify the important transactions that have significant effects on the performance)

4.The following are the steps to translate the physical database design from the logical model EXCEPT

a. (design representation of derived data)

b.(design base relations)

c. (design general constraints)

d. (analyze user requirements)

5. The following end-users access tools are very important in supporting the decision makers making decisions related to the data and its importance EXCEPT

a. (reporting and querying)

b. (data distribution)

c.(application and development)

d. (data mining)

6.Which of the following statement is TRUE when logical model is transformed to physical model?

a. (An attribute becomes a column)

b. (A primary unique identifier becomes a unique key)

c. (An instance becomes a table)

d. (An entity becomes attribute)

7.One of the techniques in fact-finding is interviewing. The following list are the objectives that can be achieved during the interviewing EXCEPT

a. (clarifying enthusiasm)

b. (clarifying facts)

c.(finding out facts)

d.(verifying facts)

In physical database design methodology, several aspects of the database that need to be described are as follows EXCEPT

a.(file organizations)

b. (security measurements)

c.(base relations)

d. (relationships between attributes)

In physical database design methodology, several aspects of the database that need to be described are as follows EXCEPT

a.(security measurements)

b. (file organizations)

c. (relationships between attributes)

d.(base relations)

What is the definition of data profiling and quality control concepts in data warehouse?

a. (Evaluations of the quantity and quality of the data from the source systems)

b.(Evaluations of analytical requirements of a particular business unit)

c.(Evaluations of particular business process to support users)

d. (Evaluations of the query results that triggers the consideration of data history)