SG0-001 · Question #432
A database is designed to auto-extend its table spaces as data is ingested. Which of following technologies would help optimize storage utilization ratios?
The correct answer is B. Thin provisioning. Thin provisioning helps optimize storage utilization ratios for a database with auto-extending table spaces by allocating physical storage on-demand rather than pre-allocating the full potential capacity.
Question
A database is designed to auto-extend its table spaces as data is ingested. Which of following technologies would help optimize storage utilization ratios?
Options
- AFull disk compression
- BThin provisioning
- CData and log isolation
- DFull disk encryption
How the community answered
(61 responses)- A16% (10)
- B70% (43)
- C8% (5)
- D5% (3)
Why each option
Thin provisioning helps optimize storage utilization ratios for a database with auto-extending table spaces by allocating physical storage on-demand rather than pre-allocating the full potential capacity.
Full disk compression reduces the amount of physical space data occupies, but it is a separate mechanism from optimizing the allocation of physical space for auto-extending volumes and can introduce performance overhead.
Thin provisioning allows a database to perceive it has access to a large storage capacity while only consuming physical storage space as data is actually written. This is highly effective with auto-extending table spaces, as it prevents large blocks of physical storage from being reserved but unused, thus optimizing utilization ratios.
Data and log isolation involves placing database data files and transaction log files on separate storage devices for performance and recovery benefits, which does not directly optimize storage utilization ratios.
Full disk encryption protects data security by encrypting the entire disk, but it does not inherently optimize storage utilization ratios; in some cases, it can add minor storage overhead.
Concept tested: Storage optimization - Thin Provisioning
Source: https://learn.microsoft.com/en-us/windows-server/storage/storage-spaces/thin-provisioning
Topics
Community Discussion
No community discussion yet for this question.