Study tips 70-462

Which Transact-SQL statement should you use before attempting the restore?

Which server-level audit action group should you use?

Which three actions should you perform in sequence?

You need to stop a blocking process that has an SPID of 64 without stopping other processes What should you do?

Which tool or tools should you use?

You need to identify the root cause of the issue by retrieving the error message

You need to identify which queries are taking longer than 1 second to run over an extended period of time

Which tool or tools should you use?

You need to ensure that the size of the transaction log file does not exceed 2 GB

You need to ensure that Data File Autogrow operations use Instant File Initialization