HOTSPOT
You are database administrator for an international sales application on a Microsoft SQL Server instance.
A large amount of legacy data has been collected in the application database, as shown in the following table.
You need to choose the correct file and filegroup usage strategy for each set of data.
The strategy should meet the following requirements:
Maximize performance for data older than 7 years.
Minimize lock management overhead when queries access data older than 7 years. Avoid the need to gain exclusive access to the database for data less than 7 years.
In the table below, identify the strategy that must be used for each set of data.
NOTE: Make only one selection in each column.
Hot Area:
