You are designing a SharePoint 2010 application that contains a single list named User Data. You need to design
the application to meet these requirements:
The application must have a drop-down menu that contains key-value pair data.
.The data in the drop-down menu must be retrieved from a Microsoft SQL Server 2008 table.
Which two actions should you recommend? (Each correct answer presents part of the solution. Choose two.)
A.
Create a new list that links to the external SQL Server table.
B.
Create a new list that has an external data column. Set the source of this column to the external SQL Server
table.
C.
Create a managed metadata column on the User Data list. Add the data from the SQL Server table to this
column.
D.
Create a lookup column on the User Data list that gets its information from an external list.