70-339 · Question #16
You need to define the content database architecture. What should you create?
The correct answer is B. a content database based on geography for each site collection. The recommended SharePoint content database architecture in this scenario organizes databases by geography, with individual site collections aligned to geographic regions.
Question
You need to define the content database architecture. What should you create?
Options
- Aa content database for each site collection based on business function
- Ba content database based on geography for each site collection
- Ca single content database for the entire environment
- Da content database for each business function, with site collections based on geography
How the community answered
(42 responses)- A5% (2)
- B81% (34)
- C12% (5)
- D2% (1)
Why each option
The recommended SharePoint content database architecture in this scenario organizes databases by geography, with individual site collections aligned to geographic regions.
Organizing content databases by business function for each site collection does not account for the geographic distribution requirements specified in the scenario.
Creating a content database based on geography for each site collection ensures data locality, which improves performance for geographically distributed users and simplifies compliance with regional data residency requirements. Separating content databases by geography also makes disaster recovery and targeted restores more manageable per region.
A single content database for the entire environment creates a single point of failure, limits scalability, and does not support geographic data separation requirements.
Creating databases per business function with site collections by geography inverts the architecture - databases should align to geography, not business function, given the scenario's geographic requirements.
Concept tested: SharePoint content database architecture by geography
Source: https://learn.microsoft.com/en-us/sharepoint/administration/database-types-and-descriptions
Topics
Community Discussion
No community discussion yet for this question.