Administering a SQL Database Infrastructure — Question 125

You want to simulate read, write, checkpoint, backup, sort, and read-ahead activities for your organization's SQL Server 2016 deployment.
Which of the following tools would you use to accomplish this goal?

Answer options

• A. SQLIO
• B. SQLIOSim
• C. SQLIOStress
• D. chkdsk

Correct answer: B

Explanation

The correct answer is SQLIOSim, as it is specifically designed to simulate SQL Server I/O patterns. SQLIO and SQLIOStress are useful for measuring I/O performance but do not replicate the specific SQL Server operations like SQLIOSim. chkdsk is a disk utility for checking file system integrity and is not related to SQL Server performance simulation.