Study tips 70-462

Which server-level audit action group should you use?

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

Which three actions should you perform in sequence?

You need to ensure that the SQL Server instance can use all nodes of the cluster