You have a SharePoint Server 2010 Web application that is being utilized as the reporting interface for system performance reports. The data presented is located in a secured SQL server database and should never be exposed to unauthorized site collection users. You need to configure a security boundary that complies with the security requirements, while also ensuring the highest level of performance in retrieving and displaying the data. You must also use the least amount of effort to provide the service to your company. What should you do?

Question:You have a SharePoint Server 2010 Web application that is being utilized as the reporting interface for system performance reports. The data presented is located in a secured SQL server database and should never be exposed to unauthorized site collection users. You need to configure a security boundary that complies with the security requirements, while also ensuring the highest level of performance in retrieving and displaying the data. You must also use the least amount of effort to provide the service to your company. What should you do?

1.Ensure that the Application Pool account for the Web application hosting the site collection has access to the secure data. Create external content types using revert-to-self and add external lists to the site collection based on these content types.

2.Create a secure store group mapping for an Active Directory group. Using external content types and this secure store application, add external lists to the site collection.

3.Create a secure store group mapping for individuals. Using external content types and this secure store application add external lists to the site collection.

4.Deploy a custom solution to the site collection that uses search Web Parts and custom queries to expose the data in the secure SQL Server database.

Answer:2