MCITP题库70-432(SQL2008).pdf

70-432 QUESTION 1 You work in a company which is named Wiikigo Corp. The company 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 computer which hosts several applications in your company. The instance runs on the computer. A job named DiliveryList is created by you. This job requires a file to be written to a file server. But because the job cannot access the file server , it fails to run. You intend to configure the SQL Server Agent service so that only the SQL Server Agent service has read and write access to the file server. Which account type should you use? A. You should use local Service account B. You should use network Service account C. You should use domain account D. You should use local System account QUESTION 1 Answer: C QUESTION 2 You work in a company which is named Wiikigo Corp. The company 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 database named DB1 in the instance. On DB1, quite few logged operations are performed. Now according to the requirement of the company CIO, you must validate that the database can be restored to a specific point in time. So what action should you perform to achieve this goal? A. You should verify that the simple recovery model is used by the database B. You should verify that the full recovery model is used by the database. C. You should verify that the checksum page verify option is used by the database D. You should verify that the bulk-logged recovery model is used by the database Answer: B /en-us/library/ms189275.aspx QUESTION 3 You work in a company which is named Wiikigo Corp. The company 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 SQL Server 7.0 database. You