Quiz 70-431

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

What should you do to capture only those App1 actions in DB1 that have a response time of two seconds or more?

What should you do to minimize the impact of this operation on SQL1 performance?

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

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 resolve the error and allow the new employee to gain access to SQL1?

What should you do?

Which two Transact-SQL statements should you use?

What should you do?

What are two possible ways to achieve this goal?