為大家收集整理了《微軟認(rèn)證考試70-432練習(xí)試題11》供大家參考，希望對大家有所幫助！??！
QUESTION 51 You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. A SQL Server Agent job is failing. You find that the job history information is incomplete and seems to be truncated after you review it. All information produced by a job must be available for viewing. So what action should you perform to achieve this goal? A.You should enable notifications to the Windows application event log when the job completes. B.You should enable write OEM file C.You should enable all job steps, making them send the output to a file D.You should include execution trace messages in the SQL Agent Error log Answer: C QUESTION 52 You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. The instance contains a database named DB1. An application which is continuously connected uses DB1. The application extensively uses the INSERT command and triggers the population of multiple tables. Now you notice that the application has a poor performance. You doubt that this problem has something to do with blocking. You have to monitor the state of the instance at regular intervals while not affecting the application performance further. Which tool should you use? A.You should use Dynamic Management Views B.You should use SQL Server Resource Governor C.You should use SQL Server Profiler D.You should use Windows System Monitor Answer: A QUESTION 53 You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2002 instance. You upgrade this instance to SQL Server 2008. You configure the Agent service to use the LocalSystem account. There is a file named Orderdata on a remote network share. A job accesses this Orderdata file by using a CMDExec step. The job step fails to complete execution after the upgrade. You must make sure that the job can complete execution, so you have to configure the job step. What action should you perform? A.You should configure a certificate B.You should configure the SQL Server Agent service to use the NetworkService account. C.You should configure the job step to use a proxy account D.You should configure the SQL Server Agent service to use a local Windows account Answer: C QUESTION 54 You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. A user reports that when he runs a query, it takes a quite long time and it is still unfinished. As the IT support, you have to verify whether the query is blocked. Which tool should you use? A.You should use the Database Engine Tuning Advisor tool B.You should use the Windows System Monitor tool C.You should use the Job Activity Monitor tool in Microsoft SQL Server Management Studio D.You should use the Activity Monitor tool in Microsoft SQL Server Management Studio Answer: D QUESTION 55 You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. You create a SQL Server Agent job that execute every 2 minutes. There istext file named SQL.log On the E:drive. The job logs information to the text file. You get a report from users saying that the server doesn't make response. You check and find that the SQL Server Agent service does not run and the Agent job doesn't function any loner. As the IT support, you have to identify the reason for the failure of the SQL Server Agent service. Which log should you check? A.You should check ERRORLOG B.You should check QL1.log C.You should check SQLAGENT.OUT D.You should check log_xx.trc Answer: C
QUESTION 51 You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. A SQL Server Agent job is failing. You find that the job history information is incomplete and seems to be truncated after you review it. All information produced by a job must be available for viewing. So what action should you perform to achieve this goal? A.You should enable notifications to the Windows application event log when the job completes. B.You should enable write OEM file C.You should enable all job steps, making them send the output to a file D.You should include execution trace messages in the SQL Agent Error log Answer: C QUESTION 52 You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. The instance contains a database named DB1. An application which is continuously connected uses DB1. The application extensively uses the INSERT command and triggers the population of multiple tables. Now you notice that the application has a poor performance. You doubt that this problem has something to do with blocking. You have to monitor the state of the instance at regular intervals while not affecting the application performance further. Which tool should you use? A.You should use Dynamic Management Views B.You should use SQL Server Resource Governor C.You should use SQL Server Profiler D.You should use Windows System Monitor Answer: A QUESTION 53 You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2002 instance. You upgrade this instance to SQL Server 2008. You configure the Agent service to use the LocalSystem account. There is a file named Orderdata on a remote network share. A job accesses this Orderdata file by using a CMDExec step. The job step fails to complete execution after the upgrade. You must make sure that the job can complete execution, so you have to configure the job step. What action should you perform? A.You should configure a certificate B.You should configure the SQL Server Agent service to use the NetworkService account. C.You should configure the job step to use a proxy account D.You should configure the SQL Server Agent service to use a local Windows account Answer: C QUESTION 54 You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. A user reports that when he runs a query, it takes a quite long time and it is still unfinished. As the IT support, you have to verify whether the query is blocked. Which tool should you use? A.You should use the Database Engine Tuning Advisor tool B.You should use the Windows System Monitor tool C.You should use the Job Activity Monitor tool in Microsoft SQL Server Management Studio D.You should use the Activity Monitor tool in Microsoft SQL Server Management Studio Answer: D QUESTION 55 You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. You create a SQL Server Agent job that execute every 2 minutes. There istext file named SQL.log On the E:drive. The job logs information to the text file. You get a report from users saying that the server doesn't make response. You check and find that the SQL Server Agent service does not run and the Agent job doesn't function any loner. As the IT support, you have to identify the reason for the failure of the SQL Server Agent service. Which log should you check? A.You should check ERRORLOG B.You should check QL1.log C.You should check SQLAGENT.OUT D.You should check log_xx.trc Answer: C