Microsoft
70-667 · Question #86
You have a SharePoint 2010 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 user named User1…
The correct answer is D. Publish the Secure Store Service Application. BURGOS MNEMO: "(access via) published workbook"= "Secure Store Service"
Configuring SharePoint 2010
Question
You have a SharePoint 2010 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 user named User1. 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
- Aalternate access mappings
- Bcontent deployment paths and jobs
- CPublish the Business Data Connectivity service Application
- DPublish the Secure Store Service Application
How the community answered
(47 responses)- A2% (1)
- B9% (4)
- C4% (2)
- D85% (40)
Explanation
BURGOS MNEMO: "(access via) published workbook"= "Secure Store Service"
Topics
#Secure Store Service#Excel Services#credential management#database connectivity
Community Discussion
No community discussion yet for this question.