exam questions

Exam 98-361 All Questions

View all questions & answers for the 98-361 exam

Exam 98-361 topic 1 question 91 discussion

Actual exam question from Microsoft's 98-361
Question #: 91
Topic #: 1
[All 98-361 Questions]

What are two advantages of normalization in a database? (Choose two)

  • A. prevents data inconsistencies
  • B. reduces schema limitations
  • C. minimizes impact of data corruption
  • D. decreases space used on disk
Show Suggested Answer Hide Answer
Suggested Answer: AD 🗳️

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
kozlu
11 months ago
Should be A and C. Theri is no important effect to decreasing space used when you follow the normalization rules but it prevents data inconsistencies.
upvoted 2 times
ReDo
8 months, 1 week ago
Normalization reduces disk space. If you have 50 tables that all have a column Address that can be 50 characters long, that will take more space than having a table with Address and all those 50 tables referring to the Address table by id. This also can actually increase chance of corruption - if that Address table gets corrupted, all the tables that use it are negatively affected as well.
upvoted 4 times
...
Hashino
9 months, 1 week ago
because normalization reduces redundancy (repeat of information) it also reduces space usage. so the answer is actually correct. side note: normalization can actually increase the risk of corruption, since it consists (generally) of breaking tables into more tables related to each other, deleting or updating on table and not the others may corrupt data
upvoted 7 times
...
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago