The Real MTCS SQL Server 2008 Exam 70/432 Prep Kit- P126: 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. | Performance Tuning Chapter 13 607 C. Standard default D. Capture_test_server 13. You re responsible for SQL Server in the organization and the IT Manager would like to forecast the remaining storage capacity that exists on the disk. Which SQL Server tools could help with capacity planning A. SP_spaceused B. Resource Governor C. SQL Profiler D. Performance Data Collector 14. You re responsible for SQL Server performance and one of the developers reports INSERTS are particularly slow. You suspect that a previous developer has created some redundant nonclustered indexes and these are hindering INSERT performance. How can you tell if an index is used A. B. C. D. 15. There is blocking occurring on your production SQL Server you ve found the session at the head of the blocking chain and retrieved the SQL_ HANDLE. Now you need to find the query executed by the user. Which DMV can help A. B. C. D. 16. Which SQL Server versions can be monitored by the Performance Data Collector A. SQL Server 2008 B. SQL Server 2005 C. SQL Server 2000 D. SQL Server 2005 Enterprise Edition 608 Chapter 13 Performance Tuning 17. What s the best method to run a SQL Trace with minimum overhead on the server being traced A. Run SQL Profiler from your desktop. B. Run SQL Profiler from the server. C. Run a server-side trace to a database on the server. D. Run a server-side trace to a file on a fast local disk. 18. Which of the following collections could be monitored by the Performance Data Collector A. SQL Trace B. T-SQL Queries C. Query Activity D. Client Response Statistics E. Performance Counters 19. Which component of table partitioning determines the boundary between partitions A. Partition function B. Partition scheme C. Partition index D. Partition view 20. Which transaction property ensures
