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.