Data Warehousing - Quiz 3 - BITS WILP - Mtec Software Systems - 2017

Data Warehousing - Quiz 3

BITS WILP - Mtec Software Systems - 2017

1. Which of the following are the characteristic of OLAP.

a)Contains current and historical data

b)Generally read only

c)Very low analytical capabilities

d)Optimization of database for analysis

Choose the correct option

Select one:

a. Only c & d

b. All

c. Only a & b

d. Only a, b & d

Ans: d. Only a, b & d

2.Match the following:

1) B-tree Index        a) Data address in each entry

2) Bitmapped Index    b) Combined data and index segments

3) Clustered Index    c) Data address in each leaf node

Choose the correct option

Select one:

a. 1-c 2-b 3-b

b. 1-b 2-c 3-a

c. 1-c 2-a 3-b

d. 1-b 2-c 3-a

Ans: c. 1-c 2-a 3-b

3. Which of the following is the correct control flow in the case of ROLAP?

Notation: Analytical Server (AS), Desktop Client (DC), RDBMS Server (RS)

Select one:

a. DC -> RS -> AS -> RS -> DC

b. RS -> DC -> AS -> DC -> RS

c. DC -> AS -> RS -> AS -> DC

d. None of the Options

Ans: c. DC -> AS -> RS -> AS -> DC

4. Match the following:

1) ROLAP        a) It makes use of Multidimensional Databases

2) MOLAP        b) It makes use of Relational Databases

3) HOLAP        c) It provides portability to the users

4) DOLAP        d) It makes use of both Relational and Multidimensional databases

Choose the correct option

Select one:

a. 1-b 2-c 3-a 4-d

b. 1-c 2-b 3-a 4-d

c. 1-b 2-a 3-d 4-c

d. 1-c 2-d 3-b 4-a

Ans: c. 1-b 2-a 3-d 4-c

5. Which of the following is not an advantage of B-Tree Indexing

Select one:

a. Ease of maintenance

b. Works well with data with low selectivity

c. Simplicity

d. Good speed of data retrieval

Ans: b. Works well with data with low selectivity

6. Deliberate splitting of a large table and its index data into manageable parts is called ______________

Select one:

a. Indexing

b. Clustering

c. Partitioning

d. Aggregation

Ans: c. Partitioning

7. Which of the following is the remedy that needs to be applied to the data warehouse storing data at lowest level of granularity, so that the queries requiring summary data run faster (if memory is available in plenty)?

Select one:

a. Partitioning

b. Aggregation

c. Indexing

d. Clustering

Ans: b. Aggregation

8. Which below operation is the viewing of cross-tab (Single dimensional) with a fixed value of one attribute

Select one:

a. Slicing

b. Pivoting

c. Both A and B

d. Dicing

Ans: a. Slicing

9. The operation of moving from coarser-granularity data to a finer-granularity is called as ________.

Select one:

a. Pivoting

b. Dicing

c. Rollup

d. Drill down

Ans: d. Drill down

10. Which kind of partitioning will result in same number of columns in each partition but may have different number of rows.

Select one:

a. None of the above

b. Horizontal

c. Both a and b

d. Vertical

Ans: b. Horizontal