How would you accomplish this?

You work as a database developer at ABC.com. You are developing a SQL server 2012 database
for ABC.com’s e-Commerce application. The application allows ABC.com employees from
different regions to execute a store procedure based on their location.
The location of the ABC.com employees are determined by an input parameter named @location.
You want to develop a process that will execute the correct stored procedure for every ABC.com
employee based on their location.
How would you accomplish this?

A.
You should make use of a client cursor.

B.
You should make use of a static cursor.

C.
You should make use of a forward-only cursor.

D.
You should make use of a dynamic cursor.

E.
You should make use of a keyset cursor.

Explanation:

Ref: http://msdn.microsoft.com/en-us/library/ms191179.aspx