Quiz 70-431

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

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?

What should you do to provide maximum query performance?

What should you do to monitor which objects and SQL Server session IDs are involved when deadlock conditions occur?

What should you do to analyze the workload file by using DTA?

What should you do to identify both the server process ID and the start time of the oldest active transaction in DB1?

Which two article properties should you change?

What should you do to use the Copy Database Wizard to accomplish this task?

Which two article properties should you change the article properties so that all indexes of Table1 in DB1 are replicated ?

What should you do to achieve this goal without negatively affecting performance?