Start learning 50% faster. Sign in now
A snowflake schema is a variation of a star schema in which the dimension tables are normalized (broken down into related tables). This: • Reduces redundancy (e.g., separating country, state, and city into different tables). • Leads to better storage efficiency. • However, it requires more joins in queries, which can reduce query performance compared to a star schema. • Option A is incorrect because normalization typically increases the number of joins, decreasing performance. • Option C is false; more joins are needed in snowflake schemas. • Option D is incorrect; multiple dimension tables can be used. • Option E is the opposite of what a snowflake schema does (it normalizes, not denormalizes, dimension tables).
What was the primary reason for the ₹115.86 crore penalty imposed on IndiGo by GST authorities?
Which city is known as the 'Manchester of the East'?
Who has been crowned as Miss India World 2022?
The 38th India-Indonesia Coordinated Patrol (IND-INDO CORPAT) between the Indian Navy Units of Andaman & Nicobar Command (ANC) and the Indonesian Na...
The length of the playing surface for Table Tennis is _____________.
What is the theme of World Hindi Day in 2024?
Which author won the Sahitya Akademi Yuva Puraskar for her memoir "Homeless: Growing up Lesbian and Dyslexic in India"?
Which government scheme has a component called "Recognition of Prior Learning (RPL)"?
Which is the greatest example of stone craft of Uttar Pradesh?
India and which country has launched a Young Professional Programme under which the other country will offer annually 3,000 degree-holding Indians in th...