You administer a Microsoft SQL Server 2012 database named Contoso on a server named Server01.You need to diagnose deadlocks that happen when executing a specific set of stored procedures by recording events and playing them back on a different test server.What should you create?
You administer a Microsoft SQL Server 2012 database named Contoso on a server named Server01.You need to prevent users from disabling server audits in Server01.What should you create?
You administer a Microsoft SQL Server 2012.A process that normally runs in less than 10 seconds has been running for more than an hour.You examine the application log and discover that the process is using session ID 60.You need to find out whether the process is being blocked.Which Transact-SQL statement should you use?
You administer all the deployments of Microsoft SQL Server 2012 in your company. You have two servers in the same data center that hosts your production database.You need to ensure that the database remains available if a catastrophic server failure or a disk failure occurs.You also need to maintain transactional consistency of the data across both servers.You need to achieve these goals without manual intervention.Which configuration should you use?
You create an availability group that has replicas named HA/Server01 and HA/Server02.Currently, HA/Server01 is the primary replica.You have multiple queries that read data and produce reports from the database.You need to offload the reporting workload to the secondary replica when HA/Server01 is the primary replica.What should you do?
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution. Determine whether the solution meets stated goals.Your company plans to use Microsoft Azure Resource Manager templates for all future deployments of SQL Server on Azure virtual machines.You need to create the templates.Solution: You use Visual Studio to create a XAML template that defines the deployment and configuration settings for the SQL Server environment.Does the solution meet the goal?
