You are a SharePoint administrator for Lucerne Publishing. The company policy and requirements are described in the Exhibit (Refer to the Exhibit).
You need to recommend a backup strategy for the content in a SharePoint site collection. The strategy must meet the following requirements:
– Adhere to the company’s business requirements.
– Minimize the amount of time required to restore the entire server farm.
What should you include in the backup strategy?
A.
Granular backups and Microsoft SQL Server transaction log backups
B.
Full farm backups and Microsoft SQL Server transaction log backups
C.
Full farm backups and granular backups
D.
Full farm backups and differential farm backups
Explanation:
Q112
BURGOS MNEMO: = “Full farm backups and Microsoft SQL Server transaction log backups”BURGOS COMMENTS:
About “granular backup” in Q046, Q056, Q107, Q112:
IF HAVE IN SAME CHOICE “SharePoint farm” OR “Scheduled”
THEN is this
ELSE no.ORIGINAL COMMENTS:
Plan for backup and recovery
http://technet.microsoft.com/en-us/library/cc261687.aspxBackup and recovery overview
http://technet.microsoft.com/en-us/library/ee663490.aspx
I believe that this answer should be D: Full farm backups and differential farm backups.
In order to “Minimize the amount of time required to restore the entire server farm” you would need to have the configuration databases and service databases included in the differential backups and in order to capture this information and allow for the fastest restore you would need SharePoint differential backups rather than SQL transaction log backups.
If you had SQL backups you would need to individually replay each of the transaction logs on each of the different SharePoint databases which would increase the time to recovery over restoring a SharePoint differential backup.
This is tricky… 50TB is huge, so you need differential backups, and content < 15 mins… SO SQL Trans Log is 100% required.
The question requirement is "You need to recommend a backup strategy for the content in a SharePoint site collection." this would be Granular backups.
With 50TB, you'd detach your DB before doing a Farm backup.
Answer is B.