Answers to Exam Prep Questions


1.

A. Although it would be most desirable to run the query on another server, it is always best to select a machine other than the production machine to absorb the overhead of running Profiler. For more information, see the section "Using SQL Server Profiler."

2.

C. To monitor detailed activity of SQL Server, you should use the SQL Server Profiler and configure a trace to take in the necessary data and filter for the desired objects. For more information, see the section "Using SQL Server Profiler."

3.

D. You need to perform some diagnosis during the period in which the issues exist. There is no sense in changing the physical configuration of the server until some diagnosis has been performed. Although adding memory and/or upgrading the processor may improve the situation, it is impossible to know whether that is even an issue before you perform some tests. SQL Profiler tests should be performed during activity; to get an accurate reading of the database usage, a Profiler trace should be performed during the day when the system is being used. For more information, see the section "Using SQL Server Profiler."

4.

C. To find information about what is currently occurring, you use Activity Monitor. Of course, the problem could be resolved by restarting the service, but that is extremely hazardous in a production environment and could corrupt data. SQL Server Profiler can only track down locking that is going to occur or that regularly occurs; starting a trace does not identify anything that is currently in place. System Monitor could provide only quantitative information about locks; it cannot isolate how a lock was put in place. For more information, see the section "Using Activity Monitor for the Here and Now."

5.

B, C, F. Because the error occurred in the database engine, you could find it logged to the Windows application and SQL Server logs. Because the server has been rebooted three times, it would be within the third archive, and this archive would have the extension .3. For more information, see the section "Management Studio: Log File Viewer."

6.

C. To monitor detailed activity in SQL Server, you should use SQL Server Profiler and configure a trace to take in the necessary data, and should also filter for the desired objects. For more information, see the section "Using SQL Server Profiler."




MCTS 70-431(c) Implementing and Maintaining Microsoft SQL Server 2005
MCTS 70-431 Exam Cram: Implementing and Maintaining Microsoft SQL Server 2005 Exam
ISBN: 0789735881
EAN: 2147483647
Year: 2006
Pages: 200
Authors: Thomas Moore

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net