Microsoft
70-667 · Question #132
You have a SharePoint Server 2010 Service Pack 1 (SP1) server farm. You configure a Microsoft Office Excel workbook to connect to a database. All connections to the database must use a Microsoft SQL…
The correct answer is A. the Secure Store Service Application. See the full explanation below for the reasoning.
Question
You have a SharePoint Server 2010 Service Pack 1 (SP1) server farm. You configure a Microsoft Office Excel workbook to connect to a database. All connections to the database must use a Microsoft SQL Server login named Excel1. You publish the workbook to a SharePoint site. You need to ensure that users can access the database via the published workbook. What should you configure?
Options
- Athe Secure Store Service Application
- Bcontent deployment paths and jobs
- Calternate access mappings
- Dthe Business Data Connectivity service Application
How the community answered
(48 responses)- A81% (39)
- B10% (5)
- C4% (2)
- D4% (2)
Community Discussion
No community discussion yet for this question.