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

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

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
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

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