Study tips 70-462

You need to ensure that the following requirements are met: No more than 5 minutes worth of transactions are lost

Which Transact-SQL batch should you use?

You need to evaluate existing and potential clustered and non-clustered indexes that will improve performance

Which Transact-SQL statement should you use?

You need to offload the reporting workload to the secondary replica when HA/Server01 is the primary replica

You need to be able to create database mirroring endpoints on both servers

You need to ensure that all available details of the job step failures for SQL Server Agent jobs are retained

You need to configure a new database to support FILETABLES

You need to ensure that the application can connect to the named instance

You need to be able to restore the database.Which Transact-SQL statement should you use before attempting the restore?