Register

ISRO-DEC2017-79

• recategorized by
3,715 views
5 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

2 Answers

5 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 1 vote
(C) should be answer

 snowflaking is normalization of the dimension tables by removing low cardinality attributes and forming separate tables.
Voting & Accepting an answer helps improve the community
Answer:
← Previous · ISRO-DEC2017-78Next → · ISRO-DEC2017-80
← Previous in category · ISRO-DEC2017-78Next in category → · Uttrakhand Asst. Pro...
Position:
Show:

Related questions

9 9 votes
3 answers 3 answers
4.5k
4.5k views
gatecse asked Dec 17, 2017
4,531 views
ISRO-DEC2017-78
Consider the results of a medical experiment that aims to predict whether someone is going to develop myopia based on some physical measurements and heredity. In this cas...
3 3 votes
4 4 answers
3.8k
3.8k views
gatecse asked Dec 17, 2017
3,842 views
ISRO-DEC2017-16
Consider the following query :$SELECT$ E.eno, $COUNT(*)$$FROM$ Employees E$GROUP\, BY$ E.enoIf an index on $eno$ is available, the query can be answered by scanning only ...
7 7 votes
4 answers 4 answers
10.8k
10.8k views
gatecse asked Dec 17, 2017
10,785 views
ISRO-DEC2017-15
Consider the following table: $\text{Faculty(facName, dept, office, rank, dateHired)}$ facNamedeptofficerankdateHiredRaviArtA101Professor1975MuraliMathM201Assistant2000Na...
1 1 vote
1 answers 1 answer
2.4k
2.4k views
gatecse asked Dec 17, 2017
2,354 views
ISRO-DEC2017-14
$\text{Type-IV} JDBC$ driver is a driverwhich is written in $C++$which requires an intermediate layerwhich communicates through Java socketswhich translates $JDBC$ functi...