Quiz 70-462

Quiz 70-462, Administering Microsoft SQL Server 2012 Databases

What should you create?

What should you create?

Which four Transact-SQL statements should you use?

Which three actions should you perform in sequence?

Which Transact-SQL statement should you use?

Which configuration should you use?

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

Which three actions should you perform in sequence?

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