CS614 Final Term Solved MCQs Preparation

CS614- Data Warehousing Final Term Solved Objective For

Preparation of Final Term Exam

Q1. To identify the (1 marks)

required we need to perform data profiling

1. Degree of Transformation

(Page 437)

1. Complexity
2. Cost
3. Time

Q2. Companies collect and record their own operational data, but at the same time they also use reference data obtained from (1 marks)

sources such as codes, prices etc.

1. Operational
2. None of these
3. Internal
4. External

Correct answer: External

(Page 21)

Q3. Ad-hoc access means to run such queries which are known already. (1 marks)

1. True
2. False

Correct answer: False

(Page 18)

Q4. in agriculture extension is that pest population beyond which the benefit of spraying outweighs its cost. (1 marks)

1. Profit Threshold Level
2. Economic Threshold Level

Correct answer: Economic Threshold Level

(Page 332)

1. Medicine Threshold Level

Q5. People that design and build the data warehouse must be capable of working across the organization at all levels (1 marks)

1. True

(Page 320)

1. False

Q6. The (1 marks)

is only a small part in realizing the true business value buried within the mountain of data collected and stored within organizations business systems and operational databases.

1. Independence on technology
2. Dependence on technology

Correct answer: Dependence on technology

(Page 320)

1. None of these

Q7. Relational databases allow you to navigate the data in (1 marks)

that is appropriate using the primary, foreign key structure within the data model.

1. Only One Direction
2. Any Direction

Correct answer: Any Direction

(Page 19)

1. Two Direction
2. None of these

Q8. DSS queries do not involve a primary key (1 marks)

1. True

(Page 21)

1. False

Q9. Data Transformation Services (DTS) provide a set of (1 marks)

that lets you extract, transform, and consolidate data from disparate sources into single or multipledestinations supported by DTS connectivity.

1. Tools

(Page 373)

1. Documentations
2. Guidelines

Q10. The need to synchronize data upon update is called (1 marks)

1. Data Manipulation
2. Data Replication
3. Data Coherency

Correct answer: Data Coherency

(Page 12)

1. Data Imitation

Q11. Taken jointly, the extract programs or naturally evolving systems formed a spider web, also known as (1 marks)

1. Distributed Systems Architecture
2. Legacy Systems Architecture

Correct answer: Legacy Systems Architecture

(Page 14)

1. Online Systems Architecture
2. Intranet Systems Architecture

Q12. Node of a B-Tree is stored in memory block and traversing a B-Tree involves (1 marks)

page faults.

1. O (n)
2. O (n2)
3. O (n lg n)
4. O (lg n)

Correct answer: O (lg n)

(Page 22)

Q13. Which statement is true for De-Normalization? (1 marks)

1. Redundant data is a performance liability at query time, but is a performance benefit at update time.
2. Redundant data is a performance benefit at both query time and update time.
3. Redundant data is a performance liability at both query time and update time.
4. Redundant data is a performance benefit at query time, but is a performance liability at update time. (Page 51)

Correct answer: Redundant data is a performance benefit at query time, but is a performance liability at update time. (Page 51)

Q14. As apposed to the out come of classification, estimation deal with (1 marks)

valued outcome.

1. Discrete
2. Isolated
3. Continuous

Correct answer: Continuous

(Page 260)

1. Distinct

Q15. The goal of (1 marks)

is to look at as few block as possible to find the matching records.

1. Indexing

(Page 222)

1. Partitioning
2. Joining
3. none of these

Q16. The technique that is used to perform these feats in data mining modeling, and this act of model building is something that people have been doing for long time, certainly before the (1 marks)

of computers or data mining technology.

1. Access Advent

click for detail

1. Ascent Avowal