You administer a Microsoft SQL Server 2012 instance that has multiple databases. You have a two-node SQL Server failover cluster. The cluster uses a storage
area network (SAN). You discover I/O issues. The SAN is at capacity and additional disks cannot be added.
You need to reduce the I/O workload on the SAN at a minimal cost.
What should you do?
A.
Move user databases to a local disk.
B.
Expand the tempdb data and log files
C.
Modify application code to use table variables
D.
Move the tempdb files to a local disk
?