Microsoft Azure Data Fundamentals — Question 167

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

Answer options

• A. Data is read from a single table and written to a single table.
• B. Data is read from multiple tables 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 multiple tables.

Correct answer: A

Explanation

The correct answer is A because a fully denormalized database structure simplifies data access by consolidating data into a single table for both reading and writing. Options B, C, and D involve multiple tables, which contradicts the concept of denormalization where the aim is to reduce the number of tables to simplify interactions with the data.