Which database solution should you recommend?

Correct Answer for the following Question is given below

You are a SharePoint administrator for Fourth Coffee. The company has 40 offices. Current Environment Smart cards are deployed in the organization. The company uses Microsoft SQL Server 2005 (64-bit) to host all of its databases. All SQL servers run Windows Server 2003 R2. The SQL Server databases are backed up by using SQL Server tools. Database administrators manage and administer all of the SQL Server backups. You plan to upgrade the Microsoft Office SharePoint Server 2007 server farm to SharePoint Server 2010. Technical Requirements Fourth Coffee has the following technical requirements for the planned SharePoint Server 2010 deployment: All user search results must display a thumbnail preview. The server farm must be available if a single SQL server fails. The server farm must be available during server patch maintenance. Excel Services settings from SharePoint Server 2007 must be migrated to SharePoint Server 2010. Business Requirements Fourth Coffee has the following business requirements for the planned SharePoint Server 2010 deployment: A separate Service Level Agreement (SLA) must be provided for each office. Database administrators must be able to restore all the content of one office without affecting the content of the other offices. Security Requirement All users must authenticate to the SharePoint server farm by using smart cards. You need to recommend a database solution that meets the company’s technical requirements. Which database solution should you recommend?

Question:

Which database solution should you recommend?

Options:

Snapshots

Partitioning

Mirroring

Encryption

Correct Answer

The Correct Answer for this Question is

Mirroring

Explanation

The Question – Which database solution should you recommend? has been answered correctly and answers for the question is Mirroring

More about these Exams

These Exam Questions and the order of these questions keep changing. but the answers are obviously same. so if you don’t find a question after another we suggest you search it in the search box and we are sure you’ll find it. you can bookmark this site for Quick access in future.

We hope you found it helpful don’t forget to leave a comment if you feel a need to correct or ask we’re always here to help.

you can find more here at mnccertified

Feel free to contact via comment or email.

Happy Learning

Cheers, Team MNCcertified

Leave a Comment