Which of the following tools would you use to accomplish this goal?

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?
A . SQLIO
B . SQLIOSim
C . SQLIOStress
D . chkdsk

View Answer

Answer: B

Explanation:

The SQLIOSim utility has been upgraded from the SQLIOStress utility. The SQLIOSim utility more accurately simulates the I/O patterns of Microsoft SQL Server.

References: https://support.microsoft.com/en-us/help/231619/how-to-use-the-sqliosim-utility-to-simulate-sqlserver- activity-on-a-d