70-432 Sample Question: 9

Question: 9

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

70-432 Sample Question: 8

Question: 8

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

You need to implement the company security policy that is stored in the RestrictedLogonHours table.What should you do?

70-432 Sample Question: 7

Question: 7


You administer a SQL Server 2008 instance. The security policy permits members of a Windows group named CONTOSO\Sales to establish new connections to the SQL Server instance only during business horns between 07:00 horns and 19:00 hours. Other users may connect to the SQL Server instance any time.

You write the following Transact-SQL statements.

You need to implement the company security policy that is stored in the
RestrictedLogonHours table.What should you do?

A. Create a logon trigger that denies the connection to the CONTOSO\Sales group during
non-business hours.
B. Create a SQL Server Agent job that causes the SQL Server Windows service to pause
during non-business hours.
C. Create a SQL Server Agent job that periodically looks for and kills connections made by the CONTOSO\Sales group during non-business hours.
D. Create a policy that uses a condition based on the Server Audit facet. Use the policy to deny the connection to the CONTOSO\Sales group during non-business hours.

Answer: A

70-432 Sample Question: 6

Question: 6

You administer a SQL Server 2008 instance that contains a database named Ad venture Works.
You are log shipping the Adventureworks database to a remote SQL Server 2008 instance.

During the weekend, the primary SQL Server instance required a restart. After the
weekend, you discover that log shipping has stopped working.

You need to troubleshoot log shipping of the Adventureworks database. What should you do?

A. Verify whether the SQL Server Agent is started on the primary server.
B. Verify whether the AdventureWorks database uses the Simple recovery model.
C. Verify whether the SQL Server Volume Shadow Copy Service (VSS) Writer is started on
the primary server.
D. Execute a DBCC CHECKDB statement on the AdventureWorks database by using the
EXTENDED_LOGICAL_CHECKS option.

Answer: A