Microsoft
70-576 · Question #77
You are designing a SharePoint 2010 application that connects to an external Microsoft SQL Server database. You have the following requirements: - Server administrators can add and edit connection…
The correct answer is A. Add or change the connection strings in the web.config file. See the full explanation below for the reasoning.
Question
You are designing a SharePoint 2010 application that connects to an external Microsoft SQL Server database. You have the following requirements:
- Server administrators can add and edit connection strings at the Web
application level.
- SharePoint users must not be able to view or modify sensitive data in
the connection strings.
- Server administrators can add or change the connection strings
declaratively with no custom UI required.
- The connection strings can be modified programmatically without
redeploying code. You need to create a plan to store connection strings for the database within the SharePoint system. Which approach should you recommend?
Options
- AAdd or change the connection strings in the web.config file.
- BUse a hierarchical object store configuration approach to store the connection strings.
- CUse a property bag configuration approach to store the connection strings.
- DUse SharePoint lists to store the connection strings.
How the community answered
(39 responses)- A79% (31)
- B13% (5)
- C5% (2)
- D3% (1)
Community Discussion
No community discussion yet for this question.