Home » Microsoft » MB6-886 » Which action should you take?
You manage SQL Server 2008 instances for a large retail organization. You want to design a reporting solution to allow users read-only access to data in databases on different instances.
Users generating reports only need read-only access. Users in different locations have different uses for the data. Some users perform complex reporting that is resource-intensive.
You want to provide reporting capability with optimum responsiveness for all users, while minimizing administration effort and performance impact to production systems using the data.
Which action should you take?
A. Configure peer-to-peer replication.
B. Create a database snapshot.
C. Implement scalable shared databases.
D. Configure log shipping.
Correct Answer: C
Explanation/Reference:
Scalable shared databases allow you to distribute multiple read-only databases to multiple instances for read-only reporting.
You should not configure peer-to-peer replication. In this scenario, there was no requirement that reporting users have the most up-to-date information. You could use peer-to-peer replication to scale out a heavily accessed database. This would allow users to access consistent data and provide multiple database copies to be updated by different users.
You should not create a database snapshot. A database snapshot is a copy of a database as of single point in time.
You should not configure log shipping. With log shipping, transaction log backups from a primary database are automatically transferred to another database and then applied.