CS614 Quiz 3 by VU Topper RM

“If resources increase in proportion to increase in data size, time is constant”. The statement refers to: A. Speed - Up B. Over - Utilized System C. Size - Up

D. Scale - Up

Most DWH implementations today do not use ______ enforced by the database, but as TQM methods improve overall data quality and database optimizers.

A. Attribute domain

B. Referential Integrity C. Using Data Quality Rules D. Consistency integrity

If every key in the data file is represented in the index file then it is called -------. A. A Multi level Sparse Index

B. Dense index

C. Sparse Index D. Inverted Index

A __ index, if fits in the memory, costs only one disk I/O access to locate a record given a key. A. Sparse

B. Dense

C. B-tree D. Hash

The ___ operator is conservative in that it assigns to the dimension an aggregate value no higher than the value of its weakest data quality indicator. A. Min B. Max C. None of the given D. Min and Max

Q1. Vu-Topper RM (1 marks)

“What means What”. The phrase refers to:

A. Meta data Page 338

B. External data C. Transformed data D. Internal representations

Q2. Vu-Topper RM (1 marks)

In Four Cell Quadrant Technique, The quadrant's vertical axis refers to: A. Scope B. Feasibility C. Resources available

D. The potential impact or value to the business Page 297

Q3. Vu-Topper RM (1 marks)

Which of the following is NOT one of the methodologies for Data Warehouse project development?

1. Data driven
2. System driven Page 283
3. Resource driven
4. Requirement driven

Correct answer: System driven Page 283

Q4. Vu-Topper RM (1 marks)

Which of the following is the most ignored step during data warehouse development A. Schema validation B. The vision definition C. The requirement verification

D. Success criteria development

Q5. Vu-Topper RM (1 marks)

Waterfall model is appropriate when A. When the budget is low B. When the deadline is strict C. When resources are limited

D. Requirements are clearly defined Page 284

Q6. Vu-Topper RM (1 marks)

Users do not care, how advance the front end of your DWH is, what they care is that: A. Tables should be properly denormalized B. Proper partitioning technique should be used C. At least star or snow flake schema should be implemented

D. They should get information in timely manner and the way they want

Q7. Vu-Topper RM (1 marks)

A top down implementation approach is useful when A. Business objectives are unclear

B. Technology is mature and well understood Page 283

C. Problem to be solved are not well documented D. Organization can not implement latest technologies

Q8. Vu-Topper RM (1 marks)

Identify the TRUE statement: A. Both clustering and classification are supervised learning B. Both clustering and classification are unsupervised learning C. Clustering is unsupervised learning and classification is supervised learning Page 270