- Option : D
- Explanation :

(a) What is the maximum number of cells possible in the base cuboid? p^{n}.

This is the maximum number of distinct tuples that you can form with p distinct values per dimensions.

(b) What is the minimum number of cells possible in the base cuboid? p.

You need at least p tuples to contain p distinct values per dimension. In this case no tuple shares any value on any dimension.

(c) What is the minimum number of cells possible in the data cube, C? (2^{n}-1)×p+1.

The minimum number of cells is when each cuboid contains only p cells, except for the apex, which contains a single cell.

(d) What is the maximum number of cells possible (including both base cells and aggregate cells) in the data cube, C? (p+1)^{n}.

The argument is similar to that of part (a), but now we have p+1 because in addition to the p distinct values of each dimension we can also choose ∗.

You must be logged in to post a comment.

- Option : B
- Explanation :

The computation is based on the simplified Bayes’ formula.

P{B|A} = (P{A|B}·P{B) / P{A}.

P{M|S} = probability that a person had meningitis, conditioned by the existence of stiff neck.

P{S|M} = probability that a person complains about stiff neck, conditioned by the existence of meningitis. = 50%=1/2

P{S} = proportion of people who complain about stiff neck. = 1/20

P{M} = proportion of people who had meningitis. = 1/50,000

Then:

P{M|S} = (P{S|M}·P{M}) / P{S} =( 1 / 2 x 1 / 50,000 ) / 1 / 20 = 0.0002 = 0.02%

You must be logged in to post a comment.

You must be logged in to post a comment.

34. __________ allows selection of the relevant information necessary for the data warehouse.

- Option : A
- Explanation :
- The Top down view allows selection of the relevant information necessary for the data warehouse.
- Data Warehouse View contains fact tables and dimension tables
- Datasource View it shows the the information which was gathered, stored and managed by operational system
- Business Query View It shows the view of date in warehouse from end user point of view. So, option (A) is correct.

You must be logged in to post a comment.

You must be logged in to post a comment.

35. The hash function used in double hashing is of the form:

- Option : C
- Explanation :

h(k, i) = (h_{1}(k) + i * h_{2}(k)) mod m is used in double hashing is of the form. Rest other option does not used in double hashing. So, option (C) is correct.

You must be logged in to post a comment.

You must be logged in to post a comment.

You must be logged in to post a comment.