ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam 70-331 All Questions

View all questions & answers for the 70-331 exam
Go to Exam

Exam 70-331 topic 1 question 124 discussion

Actual exam question from Microsoft's 70-331
Question #: 124
Topic #: 1
[All 70-331 Questions]

A company has two SharePoint 2007 site collections that each store 200,000 unique documents. The average size of each document is 250 KB. There are two non-current versions for each document.
There are approximately 600,000 list items in addition to the documents.
The company plans to upgrade the farm to SharePoint 2013.
The new farm will use two SQL Server instances that are configured as an AlwaysOn availability group. You use the following formula to estimate the size of the content database:
Database Size = ((D x V) x S) + (10 KB x (L + (V x D)))
You need to configure the storage for the content databases.
What is the minimum amount of storage space that you must allocate?

  • A. 101 GB
  • B. 110 GB
  • C. 220 GB
  • D. 405 GB
  • E. 440 GB
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️
Using the formula we make the following calculation (see note below for details):
((200000 x 2) x 250)+ (10 x 1024 x (600000 + (2 x 200000))) which calculates to 103400000000 bytes, which is 103.4 GB.
We would need 110 GB.
Note: Formula to estimate content database storage
✑ Use the following formula to estimate the size of your content databases:
Database size = ((D V) S) + (10 KB (L + (V D)))
✑ Calculate the expected number of documents. This value is known as D in the formula.
✑ Estimate the average size of the documents that you'll be storing. This value is known as S in the formula.
✑ Estimate the number of list items in the environment. This value is known as L in the formula.
✑ List items are more difficult to estimate than documents. We generally use an estimate of three times the number of documents (D), but this will vary based on how you expect to use your sites.
✑ Determine the approximate number of versions. Estimate the average number of versions any document in a library will have. This value will usually be much lower than the maximum allowed number of versions. This value is known as V in the formula.
Reference: Storage and SQL Server capacity planning and configuration (SharePoint Server 2013) https://technet.microsoft.com/en-us/library/cc298801.aspx
by [deleted] at April 4, 2025, 4:31 a.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
Currently there are no comments in this discussion, be the first to comment!
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel