You are the administrator for a SharePoint 2010 farm. The farm uses the user profile service to synchronize user profiles of employees from Active Directory. Your company stores contact information of employees in a separate Microsoft SQL Server database.
Currently, user profiles do not contain contact information of all employees.
You need to design a solution that will synchronize contact information of employees from the SQL database into user profiles.
What should you do? (Choose the best answer.)
A.
Create a Business Connectivity Services (BCS) external content type in Microsoft Visual Studio 2010 connected to the SQL database. Then, configure the user profile service to import BCS data, and start a full import.
B.
Use the managed metadata service to create a term set for the employee contact fields. Then, configure the user profile service to use this term set, and start a full import
C.
Run the following SharePoint Management PowerShell commands:
$Model = Get-SPBusinessDataCatalogMetadataObject -BdcObjectType “Model” -Name “ContosoModel” -ServiceConext
http://contoso
Export-SPBusinessDataCatalogModel -Identity $Model -Path “C:\folder\model.bdcm”
D.
Use Microsoft Visual Studio 2010 to create a timer job that synchronizes data between the SQL database and profile store.
E.
Create a Business Connectivity Services (BCS) external content type in SharePoint Designer 2010 connected to the SQL database. Then, configure the user profile service to import BCS data, and start a full import.