Study tips 70-432

Study tips 70-432

What task types are included in a SQL Maintenance Plan?

You need to add a new partition for the upcoming year

You need to create a partition scheme that will place all data to the SECONDARY filegroup

You need to move the data from the oldest year into a new table in a different Schema to archive the data

Which process should you use?

Which four Transact-SQL statements should you use?

You need to identify the following: -The sessions that wait for a resource -The resource needed -The sessions that block the resource Which dynamic management view should you use?

Which two actions should you perform?

Which Transact-SQL statement should you execute?

You need to identify the network protocol used by the current connection