SK0-004 · Question #860
An administrator is planning for the deployment of a new database. The database will be 100GB at inception and is expected to grow by 50% every year. Management wants the administrator to plan for…
The correct answer is C. 800GB. Applying 50% compound annual growth to a 100GB database over five years yields approximately 759GB, making 800GB the minimum disk allocation that satisfies the full five-year requirement.
Question
An administrator is planning for the deployment of a new database. The database will be 100GB at inception and is expected to grow by 50% every year. Management wants the administrator to plan for the database to be in service for a maximum of five years. Which of the following is the MINIMUM amount of disk space that will meet these requirements?
Options
- A400GB
- B600GB
- C800GB
- D1TB
How the community answered
(40 responses)- A8% (3)
- B10% (4)
- C80% (32)
- D3% (1)
Why each option
Applying 50% compound annual growth to a 100GB database over five years yields approximately 759GB, making 800GB the minimum disk allocation that satisfies the full five-year requirement.
400GB covers only through Year 3 (337.5GB) and is exhausted before the end of Year 4 (506.25GB), failing the five-year service requirement.
600GB is insufficient because the database reaches approximately 759GB by the end of Year 5, exceeding this allocation by roughly 159GB.
Compound growth at 50% per year produces: Year 1 = 150GB, Year 2 = 225GB, Year 3 = 337.5GB, Year 4 = 506.25GB, Year 5 = 759.375GB. The answer of 800GB is the smallest listed option that exceeds the projected 759.375GB size at the end of Year 5, making it the minimum compliant allocation.
1TB provides more than enough capacity but is not the minimum - 800GB already satisfies the requirement, so 1TB adds unnecessary over-provisioning relative to the minimum asked.
Concept tested: Compound annual storage growth capacity planning
Source: https://learn.microsoft.com/en-us/sql/relational-databases/databases/estimate-the-size-of-a-database
Topics
Community Discussion
No community discussion yet for this question.