You are designing a SharePoint 2010 application that displays information from an external
database. You need to develop the application to meet the following requirements: ·Remote
connections to the external database are not allowed. .Data from multiple tables must be
joined into a single list. .The list must be synchronized with the external database. Which
approach should you recommend?
A.
Build a Web service to join the data fields into a single list, and implement event
receivers to synchronize the list with the external database.
B.
Build a Web service to manage each table, and use the SPQuery object to join the data
fields into a single list.
C.
Build a Web service to manage each table, use Business Connectivity Services (BCS) to
import the individual tables into lists, and then create a new list that joins these external lists
together.
D.
Build a Web service to join the data fields into a single list, and use BCS to synchronize
the list with the external database.