微软认证考试70-432练习试题13[1]

【网络综合 - 微软认证(MCSE)试题】
无忧考网为大家收集整理了《微软认证考试70-432练习试题13》供大家参考，希望对大家有所帮助！！！

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微软认证(MCSE)