CS614 Final Term Solved Papers

Spring 2009 · CS614- Data Warehousing · (VISIT VURANK FOR MORE) · Marks: 70

Q1. It is observed that every year the amount of data recorded in an organization is (1 marks)

Doubles (handouts page # 6) Triples Quartiles Remains same as previous year

Q2. Multidimensional databases typically use proprietary __________ format to store pre-summarized cube structures. (1 marks)

File ( Page # 69 )

Aggregate Database

Q3. Pre-computed _______ can solve performance problems (1 marks)

Aggregates (page # 101) Facts Dimensions

Q4. _______________, if fits into memory, costs only one disk I/O access to locate a (1 marks)

record by given key. A Dense Index (page # 211) A Sparse Index An Inverted Index

Q5. The degree of similarity between two records, often measured by a numerical value between _______, usually depends on application characteristics. (1 marks)

0 and 1 (page # 157 ) 0 and 10 0 and 100 0 and 99

Q6. The purpose of the House of Quality technique is to reduce ______ types of risk. (1 marks)

Two (page # 181) Three Four All

Q7. NUMA stands for __________ (1 marks)

Non-uniform Memory Access ( page # 194) Non-updateable Memory Architecture New Universal Memory Architecture

Q8. Which is the least appropriate join operation for Pipeline parallelism? (1 marks)

Hash Join Inner Join Outer Join

Sort-Merge Join

Q9. There are many variants of the traditional nested-loop join. If the index is built as part of the query plan and subsequently dropped, it is called (1 marks)

Naive nested-loop join Index nested-loop join Temporary index nested-loop join ( page # 230)

Q10. Data mining derives its name from the similarities between searching for valuable business information in a large database, for example, finding linked products in gigabytes of store scanner data, and mining a mountain for a _________ of valuable ore. (1 marks)

Furrow Streak Trough

Vein

Q11. With data mining, the best way to accomplish this is by setting aside some of your data in a ________ to isolate it from the mining process; once the mining is complete, the results can be tested against the isolated data to confirm the model's validity. (1 marks)

Cell Disk Folder

Vault

Q12. The Kimball s iterative data warehouse development approach drew on decades of experience to develop the _____________. (1 marks)

Business Dimensional Lifecycle (page # 276 ) Data Warehouse Dimension Business Definition Lifecycle OLAP Dimension

Q13. We must try to find the one access tool that will handle all the needs of their users. (1 marks)

True False

Q14. For a smooth DWH implementation we must be a technologist. (1 marks)

True False (page # 306)

Q15. During the application specification activity, we also must give consideration to the organization of the applications. (1 marks)

True ( page # 294 ) False

Q16. Investing years in architecture and forgetting the primary purpose of solving business problems, results in inefficient application. This is the example of _________ mistake. (1 marks)

Extreme Technology Design Extreme Architecture Design None of these (page # 303)

Q17. The most recent attack is the ________ attack on the cotton crop during 2003- 04, resulting in a loss of nearly 0.5 million bales. (1 marks)

Boll Worm (VIDO LECTURE # 38) Purple Worm Blue Worm Cotton Worm

Q18. The users of data warehouse are knowledge workers in other words they are _________ in the organization. (1 marks)

Decision maker (page# 10 )