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.

microsoft-exams

Leave a Reply

Your email address will not be published. Required fields are marked *


The reCAPTCHA verification period has expired. Please reload the page.