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.
http://msdn.microsoft.com/en-us/library/ee556391(v=office.14).aspx
A core concept of Microsoft Business Connectivity Services (BCS) is the external content type. Used throughout the functionality and services offered by Business Connectivity Services, external content types are reusable metadata descriptions of connectivity information and data definitions plus the behaviors you want to apply to a certain category of external data. External content types enable you to manage and reuse the metadata and behaviors of a business entity such as Customer or Order from a central location, and enable users to interact with that external data and processes in a more meaningful way.
For example, consider a business entity such as Customer. You might want to interact with items of type Customer inside a SharePoint list or work on them offline in Microsoft Outlook. Or, you might want to enable the user to pick a customer from a list of customers in an Orders contract document inside Microsoft Word. You can create an external content type once and then reuse it anywhere you need it.
External content types offer the following benefits:
– Enable reusability
– Encapsulate complexities of external systems
– Provide built-in Office and SharePoint behavior:
External content types provide Office item-type behaviors (such as contacts, tasks, calendars in Microsoft Outlook, documents in Microsoft Word, and lists in Microsoft SharePoint Workspace); SharePoint behaviors (such as lists, Web Parts, and profile pages); and capabilities (such as the ability to search or work offline) to external data and services, so users can work in their familiar work environments without having to hunt for data or learn and interact with different (and proprietary) user interfaces.
– Ensure secure access
– Simplify maintenance
– Enable external data search
– Enable working offline
it was for next question 🙁