locked
Minimum number of content database required RRS feed

  • Question

  • Hi all,

    I pass “PRO: Microsoft SharePoint 2010, Administrator” exam before few days ago, I found following question in the exam:

    Case Study: Databases must not exceed 100GB.

    You are a SharePoint administrator for Northwind Traders.

    The company has 20,000 employees distributed across 11 different departments.

    You plan to implement a SharePoint Server 2010 server farm for internal collaboration.

    You need to identify the minimum number of content database required for the planned SharePoint server 2010 deployment.

    How many content databases should you identify?

    How I can calculate the number of content databases from provided requirements?

    Any kind of help will be appreciated.

    Wednesday, September 12, 2012 8:34 AM

Answers

All replies

  • Those Q on exams are really funny, as they almost never affect realworld deployment. Simply if there is no additional information, you can guess .. it could be 1 in a case you have just 1 webapp with 11 site collections, or 11 if you will have 11 web apps each with 1 site collection.

    I have seen Q on exam, which were refering to nonexistent items in administration etc.


    Marek Chmel, WBI Systems (MCTS, MCITP, MCT, CCNA)
    Please Mark As Answer if my post solves your problem or Vote As Helpful if a post has been helpful for you.

    Wednesday, September 12, 2012 8:49 AM
  • Was there no hind on how many Site Collections or Web Applikations are to use?

    Wednesday, September 12, 2012 8:49 AM
  • Hi , the following are Case Study and the Question.

    Case Study:

    Northwind Traders

    Active Directory Configurations

    Northwind Traders has the following Active Directory configurations:

    User attributes are stored in Active Directory.

    Active Directory group membership is based on the company's departments.

    Business Requirements

    Northwind Traders has the following business requirements for the planned SharePoint Server 2010

    deployment:

    Custom workflows must be reused across multiple document libraries.

    Human resources content must always have the highest relevancy in search results. Users who

    have no development experience must be able to create custom workflows.

    The initial deployment must contain 500GB of data and must support as much as 5 terabytes of

    content.

    Technical Requirements

    Northwind Traders has the following technical requirements for the planned SharePoint Server 2010

    deployment:

    Databases must not exceed 100GB.

    SharePoint Server 2010 processes must be evenly distributed across the servers in the server farm.

    All changes to the user profile attributes in My Sites must be updated automatically in Active

    Directory.

    To support backup and restore procedures, all databases must be created during the

    implementation phase of SharePoint Server 2010.

    Security Requirements

    Northwmd Traders has the following security requirements for the planned SharePo mt Server 2010

    deployment:

    All users in the same department must share the same level of access to site content.

    Users in the human resources department must be prevented from browsing accounting

    department documents.

    User Requirements

    Northwind Traders has the following user requirements for the planned SharePoint Server 2010

    deployment:

    All customizations must be authored by a single team of developers.

    All customizations must be deployed by the site collection administrators.

    Question:

    You are a SharePoint administrator for Northwind Traders.

    The company has 20,000 employees distributed across 11 different departments.

    You plan to implement a SharePoint Server 2010 server farm for internal collaboration.

    You need to identify the minimum number of content database required for the planned SharePoint server 2010 deployment.

    How many content databases should you identify?

    Wednesday, September 12, 2012 8:56 AM
  • Hi.

    Never post the actual questions or anything that will reflect the questions from the test on internet or like in this case TechNet, the questions are the propery of Microsoft and should be respected and treated as such.
    Please remove the test-question and scenario from your post.

    But, to give a hint on how to think in these kinds of situations in real Life:

    Key things to keep Count of regarding Content Databases:
    SharePoint Server 2010 capacity management: Software boundaries and limits, Content database limits
    http://technet.microsoft.com/en-us/library/cc262787.aspx#ContentDB

    Regards


    Thomas Balkeståhl - Technical Specialist - SharePoint - http://blog.blksthl.com
    Download the SharePoint Branding Project here
    Download the SharePoint 2010 Site Settings Explained here

    • Proposed as answer by Daniel Bugday Wednesday, September 12, 2012 9:56 AM
    • Marked as answer by star.wars Thursday, September 20, 2012 2:39 AM
    Wednesday, September 12, 2012 9:16 AM