Given below are two statements: one is labelled as Assertion A and the other is labelled as Reason R. Assertion A: A Snowflake Schema is characterized by significantly faster query execution compared to a Star Schema because it utilizes normalized dimension tables. Reason R: Normalization in the Snowflake Schema reduces data redundancy by splitting dimension tables into multiple related tables, resulting in lower storage requirements. In the light of the above statements, choose the most appropriate answer from the options given below:

Question

Computer Science · Data Warehousing

Verified Solution4 OptionsUpdated: October 2026👁️1 View

Share:

Correct answer

A is not correct but R is correct

Save this question and verified answer as a clean study sheet with live clickable link.

👥

Challenge your peer aspirants on WhatsApp or Telegram to solve this question!

Online Test Series

Practice full-length mock tests with real exam timers, instant score analysis, and all-India ranking.

Chapter Practice

Want more practice questions on Data Warehousing?

Solve complete topic-wise tests with detailed solutions on GkGet.

Recommended practice questions in Computer Science · Data Warehousing

Mahatma Gandhi's last fast unto death in 1948 was primarily against which of the following?

What was the primary meaning of 'Swaraj' as popularized by Mahatma Gandhi during India's independence movement?

What was one major impact of India’s independence on its economy?

Answer 1

Both A and R are correct and R is the correct explanation of A

Answer 2

Both A and R are correct but R is NOT the correct explanation of A

Answer 3

A is correct but R is not correct

Answer 4

A is not correct but R is correct

Related Practice Questions