Exam1pass
Easiest way to pass IT exams
Exam1pass Help You Pass Any IT Exam
http://www.exam1pass.com
Exam
: Microsoft 70-432
Title
: TS:MS SQL Server@
2008,Implementation and
Maintenance
Version : Demo
Exam1pass
Easiest way to pass IT exams
Exam1pass Help You Pass Any IT Exam
http://www.exam1pass.com
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
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
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