DRAG DROP -You are a database administrator for a Microsoft SQL Server 2012 environment that contains two SQL Server instances named Server01 and Server02. TheContoso database is located on Server01. Through database mirroring, a copy of the Contoso database is on Server02.During the last manual failover of database mirroring, the recovery took longer than usual.You need to determine where the synchronization bottleneck is for the database mirroring topology.Which performance counter or counters should you use for each server? (To answer, drag the appropriate performance counter or counters to their corresponding server or servers in the answer area. Answer choices may be used once, more than once, or not at all. Answer targets may be used once or not at all. Additionally, you may need to drag the split bar between panes or scroll to view content.)Select and Place:
You administer two Microsoft SQL Server 2012 servers named ProdSrv1 and ProdSrv2.ProdSrv1 is configured as a Distributor.Both servers are configured to use the Windows NT Service virtual accounts for all SQL Services.You are configuring snapshot replication from ProdSrv1 to ProdSrv2 by using ProdSrv2 as a pull subscriber.The distribution agent on ProdSrv2 regularly fails, displaying the following error message:"Cannot access the file. Operating system error code 5 (Access is denied.)."You need to configure the distribution agent by granting only the minimum required access to all accounts.What should you do?
You are a database administrator for a Microsoft SQL Server environment.You want to deploy a new application that will scale out the workload to at least five different SQL Server instances.You need to ensure that for each copy of the database, users are able to read and write data that will then be synchronized between all of the database instances.Which feature should you use?
You administer a Microsoft SQL Server instance that has multiple databases. You have a two-node SQL Server failover cluster. The cluster uses a storage area network (SAN).You discover I/O issues. The SAN is at capacity and additional disks cannot be added.You need to reduce the I/O workload on the SAN at a minimal cost.What should you do?
You administer a Microsoft SQL Server database that includes a table named Application.Events. Application.Events contains millions of records about user activity in an application.Records in Application.Events that are more than 90 days old are purged nightly. When records are purged, table locks are causing contention with inserts.You need to be able to modify Application.Events without requiring any changes to the applications that utilize Application.Events.Which type of solution should you use?
Note: This question is part of a series of questions that use the same set of answer choices. An answer choice may be correct for more than one question in the series.You administer all the deployments of Microsoft SQL Server in your company.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?
