Online Access Free 070-432 Practice Test

You maintain a SQL Server 2008 instance.
You have an existing database maintenance plan that performs the following tasks:
---
It checks database integrity.
It rebuilds indexes.
It writes a report to a text file.
You need to modify the SQL Server instance such that an e-mail message is sent to the operators when the maintenance plan fails to execute successfully.
What should you do?

• A.Modify the database maintenance plan to include a Notify Operator task that e-mails the appropriate operators.
• B.Modify the SQL Server Agent job that executes the database maintenance plan to notify the appropriate operators.
• C.Modify the database maintenance plan to e-mail a report to the appropriate operators.
• D.Enable a fail-safe operator for the SQL Server Agent.

You administer a Microsoft SQL Server 2008 R2 instance. The instance has a database named CustomerOrders.
The database is backed up by using the weekly scheduled SQL Server Agent jobs. The backup schedule is shown in the following table:

A drive fails and the CustomerOrders database goes into suspect mode on Monday at
09:00 hours.
You need to restore the backup.
What should you do?

• A.Restore the backups taken on Wednesday, Thursday at 09:00 hours, and Thursday at
  18:00
  hours.
• B.Restore the backups taken on Wednesday and Thursday at 09:00 hours.
• C.Restore the backups taken Wednesday, Friday, and Saturday.
• D.Restore the backup taken on Sunday only.
• E.Restore the backups taken on Sunday and Monday.
• F.Restore the backups taken on Wednesday and Friday.
• G.Restore the backup taken on Wednesday only.
• H.Restore the backups taken on Wednesday, Thursday, and Friday.

You maintain a SQL Server 2008 instance that runs on a computer that hosts several applications. You configure the SQL Server Agent service to run by using the SERVER1\AGENT account. You create a job named MailingList that requires a file to be written to a file server. The job fails to run because it does not have appropriate access to the file server. You plan to configure the SQL Server Agent service.
You need to perform the configuration such that only the SQL Server Agent service has read and write access to the file server.
Which account type should you use?

• A.Local System account
• B.Local Service account
• C.Network Service account
• D.Domain account

You administer a SQL Server 2008 instance.
You need to configure the instance to use a single thread for queries that have an estimated execution cost less than 3.
Which sp_configure configuration option should you set?

• A.precompute rank
• B.cost threshold for parallelism
• C.query governor cost limit
• D.max worker threads
• E.priority boost

You maintain a SQL Server 2008 instance that contains a database named OrderEntry. The OrderEntry database contains a table named OrderDelivery.
You add a column named DeliveryPoint to the OrderDelivery table. The DeliveryPoint column is of the Geography data type. The OrderDelivery table does not contain indexes.
You need to create a spatial index on the DeliveryPoint column.
What should you do first?

• A.Define a primary key for the OrderDelivery table.
• B.Ensure that the DeliveryPoint column does not allow NULL values.
• C.Copy the OrderDelivery data to a temporary table and truncate the existing
  OrderDelivery table.
• D.Create a clustered index for the OrderDelivery table.