Microsoft Technology Associate Mta · Free Practice Question Medium
Question 3
This question requires that you evaluate the styled text to determine if it is correct.
You combine data from three tables into one table. The new table includes redundancy to optimize read performance. As a result, the data in the new table has been de-normalized.
Instructions: Review the styled text. If it makes the statement correct, select "No change is needed." If the statement is incorrect, select the answer choice that
makes the statement correct.
-
A
No change is needed
-
B
Normalized
-
C
Indexed
-
D
Truncated
Reveal correct answer
Correct answer: A
Explanation
Denormalization is a strategy used on a previously-normalized database to increase performance. In computing, denormalization is the process of trying to improve the read performance of a database, at the expense of losing some write performance, by adding redundant copies of data or by grouping data.Discussion
Think the marked answer is wrong, or have a better explanation? Share it below — comments appear after review.
You must be logged in to post a comment.
