You are designing a SharePoint 2010 application. The application must populate a site column based on data
from an existing Microsoft SQL Server 2008 table. This table contains metadata information that is structured in a
key-value pair.
You need to design a column type that meets the requirements.
Which type of column should you design?
A.
Business Data
B.
External Data
C.
Lookup
D.
Managed Metadata
Business data, only a general description, there is no sense.
Lookup field, the list must be based on other data within SharePoint.
Managed metadata, but also the internal data SharePoint.
So answer this question should external data as it can be configured with SQL
https://office.microsoft.com/en-us/sharepoint-help/create-and-update-an-external-data-column-in-a-list-or-library-HA102843647.aspx