DS0-001 Database Planning And Deployment Practice Question
A database administrator is planning a new SQL Server deployment and needs to ensure that the tempdb system database does not become a bottleneck during high-concurrency operations. Which configuration step should be performed during the initial setup?
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
✓
Create multiple tempdb data files of equal size to distribute I/O contention across multiple threads.
In SQL Server, tempdb contention is often mitigated by increasing the number of data files based on the number of logical processors.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Move the tempdb database to a network attached storage (NAS) share for high availability.
Why it's wrong here
tempdb should reside on local high-performance storage to minimize latency.
- ✓
Create multiple tempdb data files of equal size to distribute I/O contention across multiple threads.
Why this is correct
SQL Server best practices recommend creating multiple tempdb files to reduce contention on system tables.
- ✗
Set the recovery model of tempdb to Full to ensure point-in-time recovery.
Why it's wrong here
tempdb is a simple-logged database and cannot have its recovery model changed.
- ✗
Configure the tempdb database to use a single large file on a compressed volume.
Why it's wrong here
Compression increases latency and a single file often leads to PAGELATCH contention.
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.