MS Sql Server DBA 2012 Set 1

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. Which configuration should you use?

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?

You need to ensure that an OLTP database that uses a storage area network (SAN) remains available if any of the servers fail. You also need to minimize the amount of storage used by the database. Which configuration should you use?

You create an availability group named haContosoDbs. Your primary replica is available at Server01\Contoso01. You need to configure the availability group to prevent data loss. In the event of a database failure, the designed secondary database must come online automatically. Which Transact-SQL statement should you use?

You administer several Microsoft SQL Server database servers. Merge replication has been configured for an application that is distributed across offices throughout a wide area network (WAN). Many of the tables involved in replication use the XML and varchar (max) data types. Occasionally, merge replication fails due to timeout errors. You need to reduce the occurrence of these timeout errors. What should you do?

You create an availability group named HaContoso that has replicas named Server01/HA, Server02/HA, and Server03/HA. Currently, Server01/HA is the primary replica. You need to ensure that the following requirements are met: (i) Backup operations occur on Server02/HA. (ii) If Server02/HA is unavailable, backup operations occur on Server03/HA. (iii) Backup operations do not occur on Server01/HA. How should you configure HaContoso?

You administer a Microsoft SQL Server instance that has several SQL Server Agent jobs configured. When SQL Server Agent jobs fail, the error messages returned by the job steps are truncated. The following error message is an example of the truncated error message: "Executed as user CONTOSO\ServiceAccount....0.4035.00 for 64-bit Copyright (C) Microsoft Corp 1984-2011. All rights reserveD. Started 63513 PM Error 2012-06-23 183536.87 Code 0XC001000E Source UserImport Description Code 0x00000000 Source Log Import Activity Descript... The package execution fA. .. The step failed. " You need to ensure that all the details of the job step failures are retained for SQL Server Agent jobs. What should you do?