nerdexam
Microsoft

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.

Design SharePoint infrastructure

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)
  • A
    5% (2)
  • B
    81% (34)
  • C
    12% (5)
  • D
    2% (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.

Aa content database for each site collection based on business function

Organizing content databases by business function for each site collection does not account for the geographic distribution requirements specified in the scenario.

Ba content database based on geography for each site collectionCorrect

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.

Ca single content database for the entire environment

A single content database for the entire environment creates a single point of failure, limits scalability, and does not support geographic data separation requirements.

Da content database for each business function, with site collections based on geography

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

#content database architecture#geography-based design#site collections#database planning

Community Discussion

No community discussion yet for this question.

Full 70-339 Practice