為大家收集整理了《微軟認(rèn)證考試70-432練習(xí)試題13》供大家參考，希望對(duì)大家有所幫助?。?！
QUESTION 61 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. There is a stored procedure. The stored procedure implements a database maintenance process. A SQL Server Agent job should be created to that runs the stored procedure. Besides this, you must make sure that after it is completed successfully, the job is removed. What should you do? A.You should create a job which is assigned to the Database Maintenance category B.You should create an Alert which will run another to delete the maintenance job. C.You should create a job. You schedule the job to run only once. D.You should create a job. The job uses the Automatically delete job option Answer: D QUESTION 62 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 which contains multiple Agent jobs. The jobs run each job on each day of the week by using seven shared schedules. You must make sure that a job named Job4 doesn't run Wednesday. So what action should you perform to achieve this goal? A.You should remove the schedule for Wednesday from Job5. B.You should add a new Job5 schedule for Wednesday and disable it. C.You should delete the schedule for Wednesday. D.You should disable the schedule for Wednesday. Answer: A QUESTION 63 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 have to perform the backup of the default trace according to the requirement of your failure recovery plan. The default trace is contained in the subdirectory. You have to backup the subdirectory. Which SQL Server database engine subdirectory should be backed up? A.DATA B.INSTALL C.LOG D.BINN Answer: C QUESTION 64 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. There is a management data warehouse that uses the data collector to collect performance data. You intend to maintain the management data. You want to implement a data collection process. The process can gather and upload data in the management data warehouse on different schedules. What process should you implement? A.You should create a cached data collection B.You should create an on-demand non-cached data collection C.You should create a scheduled non-cached data collection D.You should create two different SQL Agent jobs that are scheduled stimultaneously Answer: A QUESTION 65 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 remote SQL Server 2008 instance. You notice that the application has a poor performance. On the remote SQL Server instance, you capture a workload of the remote instance to a trace table by using SQL Profiler. Now you have to use the Database Engine Tuning Advisor to analyze the workload of the remote SQL Server instance on a local SQL Server instance. So what action should you perform to achieve this goal? A.You should recapture the workload by using the data collector. B.You should enable the XP_MSVER stored procedure on the local server. C.You should enable the XP_MSVER stored procedure on the remote server D.You should recapture the workload to a trace file by using SQL Profiler. Answer: D
QUESTION 61 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. There is a stored procedure. The stored procedure implements a database maintenance process. A SQL Server Agent job should be created to that runs the stored procedure. Besides this, you must make sure that after it is completed successfully, the job is removed. What should you do? A.You should create a job which is assigned to the Database Maintenance category B.You should create an Alert which will run another to delete the maintenance job. C.You should create a job. You schedule the job to run only once. D.You should create a job. The job uses the Automatically delete job option Answer: D QUESTION 62 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 which contains multiple Agent jobs. The jobs run each job on each day of the week by using seven shared schedules. You must make sure that a job named Job4 doesn't run Wednesday. So what action should you perform to achieve this goal? A.You should remove the schedule for Wednesday from Job5. B.You should add a new Job5 schedule for Wednesday and disable it. C.You should delete the schedule for Wednesday. D.You should disable the schedule for Wednesday. Answer: A QUESTION 63 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 have to perform the backup of the default trace according to the requirement of your failure recovery plan. The default trace is contained in the subdirectory. You have to backup the subdirectory. Which SQL Server database engine subdirectory should be backed up? A.DATA B.INSTALL C.LOG D.BINN Answer: C QUESTION 64 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. There is a management data warehouse that uses the data collector to collect performance data. You intend to maintain the management data. You want to implement a data collection process. The process can gather and upload data in the management data warehouse on different schedules. What process should you implement? A.You should create a cached data collection B.You should create an on-demand non-cached data collection C.You should create a scheduled non-cached data collection D.You should create two different SQL Agent jobs that are scheduled stimultaneously Answer: A QUESTION 65 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 remote SQL Server 2008 instance. You notice that the application has a poor performance. On the remote SQL Server instance, you capture a workload of the remote instance to a trace table by using SQL Profiler. Now you have to use the Database Engine Tuning Advisor to analyze the workload of the remote SQL Server instance on a local SQL Server instance. So what action should you perform to achieve this goal? A.You should recapture the workload by using the data collector. B.You should enable the XP_MSVER stored procedure on the local server. C.You should enable the XP_MSVER stored procedure on the remote server D.You should recapture the workload to a trace file by using SQL Profiler. Answer: D