CompTIA Server+ SK0-005 Practice Question

Users complain that queries against the company's production SQL Server cluster are much slower than usual this morning. Reports show the slowdown began shortly after last night's maintenance window, when the storage team expanded the SAN LUN that holds the cluster's data files and the Windows team applied cumulative OS patches to both nodes. You have just begun the troubleshooting process.

Which first question to the relevant stakeholders would BEST help you determine the scope of the problem?

  • What exact changes were made during the SAN LUN expansion-including size, pathing or zoning adjustments-and at what time did the work complete?

  • Have we already run DBCC CHECKDB to verify the integrity of every database on the cluster?

  • Can someone provide the 24-hour growth trend for tempdb so we can compare it to yesterday's baseline?

  • Should we immediately fail over the SQL cluster to the secondary node to see if that restores normal performance?

CompTIA Server+ SK0-005
Troubleshooting
Your Score:
Settings & Objectives
Random Mixed
Questions are selected randomly from all chosen topics, with a preference for those you haven’t seen before. You may see several questions from the same objective or domain in a row.
Rotate by Objective
Questions cycle through each objective or domain in turn, helping you avoid long streaks of questions from the same area. You may see some repeat questions, but the distribution will be more balanced across topics.

Check or uncheck an objective to set which questions you will receive.

SAVE $47
$390.00 $343.00
SAVE $53
CompTIA Server+ Voucher with Retake
v5 / SK0-005
Includes Retake
$439.00 $386.00
Bash, the Crucial Exams Chat Bot
AI Bot