nerdexam
CompTIA

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.

Storage Management

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)
  • A
    16% (10)
  • B
    70% (43)
  • C
    8% (5)
  • D
    5% (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.

AFull disk compression

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.

BThin provisioningCorrect

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.

CData and log isolation

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.

DFull disk encryption

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

#thin provisioning#storage optimization#database storage#capacity management

Community Discussion

No community discussion yet for this question.

Full SG0-001 Practice