SQL Server: DB Scalability

Scalable shared databases allow DBA/Developer to distribute multiple read-only databases to multiple instances for read- only reporting. DBA/Developer should not configure peer-to-peer replication. In this scenario, there was no requirement that reporting users have the most up-to-date information. DBA/Developer 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. DBA/Developer should not create a database snapshot. A database snapshot is a copy of a database as of single point in time. DBA/Developer should not configure log shipping. With log shipping, transaction log backups from a primary database are automatically transferred to another database and then applied. DBA/Developer are a database developer on an instance of SQL Server 2008. DBA/Developer Sales database contains both current and historical sales data for DBA/Developer company. DBA/Developer SalesHeader table is defined as follows: