Microsoft Azure Data Fundamentals — Question 297

In a fully normalized database, how is data read and written for a single entity?

Answer options

• A. Data is read from multiple tables and written to multiple tables.
• B. Data is read from a single table and written to a single table.
• C. Data is read from a single table and written to multiple tables.
• D. Data is read from multiple tables and written to a single table.

Correct answer: A

Explanation

In a fully normalized database, data for a single entity is typically distributed across multiple tables to eliminate redundancy. Therefore, both reading and writing operations involve multiple tables to maintain data integrity and normalization principles. Options B and C do not reflect the multi-table approach required in normalization, and option D incorrectly suggests that writing is limited to a single table.