DP-900 · Question #277
In a fully denormalized database, how is data read and written for a single entity?
The correct answer is A. Data is read from a single table and written to a single table. Full denormalization collapses all related data into a single wide table, eliminating joins so all reads and writes target that one table.
Question
Options
- AData is read from a single table and written to a single table.
- BData is read from multiple tables and written to a single table.
- CData is read from a single table and written to multiple tables.
- DData is read from multiple tables and written to multiple tables.
How the community answered
(58 responses)- A88% (51)
- B7% (4)
- C2% (1)
- D3% (2)
Why each option
Full denormalization collapses all related data into a single wide table, eliminating joins so all reads and writes target that one table.
In a fully denormalized schema every attribute of an entity is stored in one table, so a query reads from that table and an insert/update writes to that same table with no need to touch additional tables.
Reading from multiple tables implies joins, which characterizes a normalized (not denormalized) design.
Writing to multiple tables implies the data is split across tables, contradicting the single-table premise of full denormalization.
Both reading from and writing to multiple tables describes a normalized relational model, the opposite of full denormalization.
Concept tested: Database normalization vs. denormalization
Source: https://learn.microsoft.com/en-us/azure/architecture/data-guide/relational-data/relational-data
Topics
Community Discussion
No community discussion yet for this question.