Term
| You need to ensure that an OLTP database that includes up-to-the-minute reporting requirements can be off-loaded from the primary database to another server. You also need to be able to add indexes to the secondary database. |
|
Definition
| SQL Server that includes an application database configured to perform transnational replication. |
|
|
Term
| You Administer all the deployments of MS SQL Server 2012 in your company. You need to ensure that data changes are sent to a non-SQL Server database server in near real time. You also need to ensure that data on the primary server is unaffected. Which configuration should you use? |
|
Definition
| SQL Server that includes an application database configured to perform transnational replication. |
|
|
Term
| You administer all the deployments of MS SQL Server 2012 in your company. A database contains a large product catalog that is updated periodically. You need to be able to send the entire product catalog to all branch offices on a monthly basis. Which configuration should you use? |
|
Definition
| SQL Server that includes an application database configured to perform snapshot replication. |
|
|
Term
| You administer all the deployments of MS SQL Server 2012 in your company. You need to ensure that an OLTP database that uses a storage area network (SAN) remains available if any of the server fail. You also need to minimize the amount of storage used by the database. Which configuration should you use? |
|
Definition
- Two servers configured in a Windows Failover Cluster in the same data center.
- SQL Server configured as a clustered instance.
|
|
|
