DS0-001 Database Planning And Deployment Practice Question
A database developer is implementing a partitioning strategy for a large table containing historical financial records. The requirement is to allow for efficient archival of data older than five years. Which partitioning strategy should be chosen?
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
Range partitioning
Range partitioning allows the database to group data by specific values such as dates, making it very simple to drop an entire partition when data reaches its archival age.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
Range partitioning
Why this is correct
Range partitioning is ideal for time-series data, allowing for efficient partition dropping or archiving.
- ✗
Composite partitioning
Why it's wrong here
Composite partitioning is overly complex for a simple date-based archival requirement.
- ✗
List partitioning
Why it's wrong here
List partitioning is for categorical data (e.g., regions), not sequential time-series data.
- ✗
Hash partitioning
Why it's wrong here
Hash partitioning distributes data evenly across partitions and is not suitable for range-based archival.
- ✗
Round-robin partitioning
Why it's wrong here
Round-robin is for load balancing, not data management or archival.
About these practice questions
One of 216 original DS0-001 practice questions on Courseiva, each with a full explanation and wrong-answer analysis — not exam dumps or protected exam content. Learn why practice questions differ from exam dumps →
JA
Written and reviewed by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
Last reviewed August 2026 · checked against the official CompTIA exam blueprint
This DS0-001 practice question is part of Courseiva's free CompTIA certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the DS0-001 exam.