Quiz 70-431

Quiz 70-431, TS: Microsoft SQL Server 2005 – Implementation and Maintenance

What should you do to identify any missing nonclustered indexes. You want the existing structures remain intact?

How can you achieve this goal to connect to Certkiller -DB01 to detect the problem?

How can you retrieve data concerning a user who is currently logged in on the system?

What should you do next on Certkiller -SR02 to configure Certkiller -DB01 and Certkiller -DB02 as mirrored servers?

Which two article properties should you change to change the article properties so that all indexes of Certkiller 4?

Which two actions should you perform to modify the Transact-SQL statement?

Which Transact-SQL batch should you use to ensure that the database is always in a consistent state?

Which Transact-SQL batch should you use to ensure that the database is always in a consistent state?

Which Transact-SQL batch should you use to ensure the following?

What should you do to meet the following criteria?