You work as a Database Administrator (DBA) at ABC.com. All databases are hosted on
Windows Server 2012 servers running SQL Server 2012.
The Sales department uses a database named SalesDB. SalesDB contains a large table
named Orders that lists every order received by the company in the last 10 years.
You want to partition improve the performance of SalesDB by partitioning the Orders table
into 10 partitions based on year.
Which of the following describes how you should partition the table?

A.
Create a partition scheme. Create a partition function. Create 10 filegroups. Modify the storage
location of the table.

B.
Modify the storage location of the table. Create 10 filegroups. Create a partition function. Create
a partition scheme.

C.
Create 10 filegroups. Create a partition function. Create a partition scheme. Modify the storage
location of the table.

D.
Create a partition function. Create a partition scheme. Create 10 filegroups. Modify the storage
location of the table.

Explanation: