You are designing a SharePoint 2010 application that contains a single list named UserDat
a. 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 UserData list. Add the data from the SQL
Server table to this column.
D.
Create a lookup column on the UserData list that gets its information from an external
list.