edited by
2,723 views
5 votes
5 votes

Which of the following related to snowflake schema is true?

  1. Each dimension is represented by a single dimensional table
  2. Maintenance efforts are less
  3. Dimension tables are normalized
  4. It is not an extension of star schema
edited by

2 Answers

5 votes
5 votes

Snowflake Schema Example

Snowflake schema consists of a fact table surrounded by multiple dimension tables 

  • Each dimension is represented by multiple dimension tables . 1 is false
  • Maintenance efforts are more. 2 is false
  • Dimension tables are normalized (usually in 3 NF) . 3 is True (NB: But in star scheme it may not be true always)
  • It is an extension of star schema. 4 is false

 answer is 3

1 votes
1 votes
(C) should be answer

 snowflaking is normalization of the dimension tables by removing low cardinality attributes and forming separate tables.
Answer:

Related questions

2 votes
2 votes
1 answer
1
gatecse asked Dec 17, 2017
2,021 views
Consider the following : A.Condition Coveragep.Black box testing B.Equivalence Class partitioningq.System testingC.Volume Testingr.White box testingD.Beta Testings.Perfor...
9 votes
9 votes
2 answers
2
gatecse asked Dec 17, 2017
3,706 views
Consider the following $C$ function#include<stdio.h int main(void) { char c[]="ICRBCSIT17" char *p=c; printf("%s",c+2[p]-6[p]-1); return 0; }The output of the program is ...
1 votes
1 votes
1 answer
4
gatecse asked Dec 17, 2017
2,349 views
Which of the following set of components is sufficient to implement any arbitrary Boolean function?$XOR$ gates, $NOT$ gates$AND$ gates, $XOR$ gates and $1$$2$ to $1$ mult...