Study tips 70-432

Study tips 70-432

Which four Transact-SQL statements should you use?

Which three actions should you perform in sequence?

You need to identify the purpose of each Dynamic Management Views (DMVs)

You need to limit the amount of CPU and RAM used by the reporting group

You need to ensure that the transaction log backup schedule meets the following requirements: -Log backups occur every 15 minutes between 09:00 hours and 17:00 hours

You need to place the database into an EMERGENCY state for troubleshooting

You need to restore the database

You need to ensure that no suspect pages have been detected in your database

Which database option should you turn on?

What task types are included in a SQL Maintenance Plan?