nerdexam
CompTIA

SG0-001 · Question #332

Which of the following would be considered a poor candidate for deduplication?

The correct answer is A. A high performance OLTP database. The question asks to identify a workload that is poorly suited for data deduplication.

Storage Functionality

Question

Which of the following would be considered a poor candidate for deduplication?

Options

  • AA high performance OLTP database
  • BTape based backups
  • CA filesystem or share containing unstructured windows files and documents
  • DDisk based backups

How the community answered

(56 responses)
  • A
    89% (50)
  • B
    2% (1)
  • C
    5% (3)
  • D
    4% (2)

Why each option

The question asks to identify a workload that is poorly suited for data deduplication.

AA high performance OLTP databaseCorrect

A high performance OLTP (Online Transaction Processing) database is a poor candidate for deduplication because these databases often have data blocks that are highly unique or change frequently, providing little deduplication benefit, and the overhead of deduplication can significantly impact the required high I/O performance. Deduplication adds processing and latency that OLTP databases cannot tolerate.

BTape based backups

Tape based backups typically do not support inline deduplication efficiently due to the sequential access nature of tape, but the data itself could be deduplicated before being written to tape. The question asks about a candidate for deduplication, not the medium's capability.

CA filesystem or share containing unstructured windows files and documents

A filesystem or share containing unstructured Windows files and documents, like user home directories or shared drives, is an excellent candidate for deduplication due to the high redundancy often found across multiple users' files.

DDisk based backups

Disk based backups are generally excellent candidates for deduplication because they often contain many identical blocks across full and incremental backups of the same systems over time.

Concept tested: Data deduplication suitability for workloads

Source: https://learn.microsoft.com/en-us/windows-server/storage/data-deduplication/overview

Topics

#data deduplication#storage optimization#OLTP database

Community Discussion

No community discussion yet for this question.

Full SG0-001 Practice