The Real MTCS SQL Server 2008 Exam 70/432 Prep Kit- P99: Congratulations on your journey to become certified in SQL Server 2008. This book will help prepare you for your exam and give you a practical view of working with SQL Server 2008. | 472 Chapter 10 Monitoring and Troubleshooting 9. You are looking at a SQL Server that is having performance problems. You have found that the SAN storage is not working correctly. Which performance monitor should you look at to confirm that the storage is not writing data quickly enough A. Current Disk Queue B. Avg Disk Sec Write C. Avg Disk Write Sec D. Avg Disk Queue 10. You wish to monitor the throughput of your backup operation to see if the backups are running at their full potential. What performance monitor counter should you monitor A. SQL Server Backup Device - Device Throughput Bytes sec B. PhysicalDisk - Avg Disk Write Sec C. PhysicalDisk - Disk Writes Sec 11. You have a SQL Server Agent job configured to run T SQL statements. The job runs under a domain account that is not a member of the sysadmin fixed server role. You wish to add a Command Exec job step to the job. The job fails on the step because the domain account doesn t have rights to run Command Exec job steps. What should you do to correct this issue without granting excessive rights to the instance A. Make the logon a member of the sysadmin fixed server role. B. Make the logon a member of the Windows Administrators group on the server. C. Create a credential based on the Windows logon. Create a proxy based on the credential. Grant the logon rights to the proxy. Assign the proxy to run the job step. D. Create a proxy based on the Windows logon. Create a credential based on the proxy. Grant the logon rights to the credential. Assign the credential to run the job step. Monitoring and Troubleshooting Chapter 10 473 12. You have a SQL Server with several instances installed on it. After the server reboots users are only able to connect to the default instance. What should to do to enable your clients to connect to the named instances again A. Restart the SQL Server services for the named instances. B. Restart the SQL Server Agent services for the named instances. C. Restart the SQL Server service .
