Quiz 70-462

Quiz 70-462, Administering Microsoft SQL Server 2012 Databases

Which options should you select on the Options page of the Restore Database window?

Which command(s) or tool(s) should you use?

Which backup option should you use?

Which Transact-SQL statement should you insert at line 06?

Which performance counter or counters should you use for each server?

You need to configure the distribution agent by granting only the minimum required access to all accounts

Which feature should you use?

You need to reduce the I/O workload on the SAN at a minimal cost

Which type of solution should you use?

You need to reduce the amount of memory used for cached query plans