Microsoft Exam DP-900 Topic 4 Question 70 Discussion

Actual exam question for Microsoft's DP-900 exam

Question #: 70
Topic #: 4

[All DP-900 Questions]

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

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.

Show Suggested Answer

Suggested Answer: B

by Marge at Oct 20, 2023, 06:28 PM

Limited Time Offer

25%

Off

Get Premium DP-900 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Boris

3 days ago

Haha, guys, you're overthinking this. In a fully denormalized database, there's only one table, so how else would you read and write the data? A has got to be the answer. Let's not make this harder than it needs to be.

upvoted 0 times

...

Glory

4 days ago

Yeah, I'm with Vonda on this one. Denormalization is the opposite of normalization, so you're intentionally introducing redundancy in the data. A single table just doesn't seem like the right approach.

upvoted 0 times

...

Vonda

5 days ago

I'm not so sure about that. Denormalization is all about duplicating data across multiple tables to improve performance, right? So I think the answer might be D - data is read from and written to multiple tables.

upvoted 0 times

...

Quentin

6 days ago

Hmm, this question seems straightforward enough. In a fully denormalized database, all the data for a single entity should be stored in a single table, so I'd say the answer is A - data is read from and written to a single table.

upvoted 0 times

...