Microsoft Certified Azure Data Fundamentals · Free Practice Question Easy
Question 37
- A Normalization is the process of removing all null values from a database.
- B Normalization improves query performance by denormalizing data into a single table.
- C Normalization helps eliminate redundant data by organizing fields and tables.
- D Normalization is used to ensure referential integrity between tables.
Reveal correct answer
Correct answer: C
A. Normalization is not specifically about removing null values from a database. While normalization can help in organizing data and reducing redundancy, its primary goal is to structure data to minimize duplication and improve data integrity.
B. Denormalization, not normalization, involves combining tables and duplicating data to improve query performance. Normalization, on the other hand, focuses on breaking down data into smaller, related tables to reduce redundancy and improve data integrity.
C. Normalization in relational database design aims to reduce redundancy by organizing data into separate tables and structuring relationships between them. This process helps to minimize data duplication and inconsistencies, leading to a more efficient and maintainable database schema.
D. Referential integrity is a concept related to maintaining consistency and relationships between tables in a database. While normalization can indirectly help ensure referential integrity by structuring data properly, its main purpose is to reduce redundancy and improve data organization.
Discussion
Think the marked answer is wrong, or have a better explanation? Share it below — comments appear after review.
