Sharepoint Question (70-667)

Question

I wonder if someone could help me with this question:

You have a SharePoint Server 2010 service pack 1(SP1) server farm. You have a Microsoft SQL server 2008 Database that contains a table. The table can only be accessed by an Active Directory user account named User1. You need to ensure that the table can be used as an external content type.

• A) Run the add-spclaimtypemapping cmdlet <- WRONG
• B) Create a new Secure Store Service <-- Claims to be correct but Im not sure
• C) Modify the permission for the Business data connectivity service application <-- CORRECT?

Thanks!

Answer 1

Right Answer is Number C,

You need to ensure that the table can be used as an external content type.

You can create external content type using BCS.

Check this link for reference,

Create an external content type for a Business Connectivity Services on-premises solution in SharePoint 2013

Hope it helps.