You administer a Microsoft SQL Server 2012 instance.The instance contains a database that supports a retail sales application. The application generates hundreds of transactions per second and is online 24 hours per day and 7 days per week.You plan to define a backup strategy for the database. You need to ensure that the following requirements are met:No more than 5 minutes worth of transactions are lost. Data can be recovered by using the minimum amount of administrative effort.What should you do? Choose all that apply.
You administer a Microsoft SQL Server 2012 database that contains a table named OrderDetail.You discover that the NCI_OrderDetail_CustomerID non-clustered index is fragmented. You need to reduce fragmentation. You need to achieve this goal without taking the index offline.Which Transact-SQL batch should you use?
You administer a Microsoft SQL Server database named Sales. The database is 3 terabytes in size.The Sales database is configured as shown in the following table.You discover that all files except Sales_2.ndf are corrupt.You need to recover the corrupted data in the minimum amount of time.What should you do?
You administer a Microsoft SQL Server 2012 server. You plan to deploy new features to an application.You need to evaluate existing and potential clustered and non-clustered indexes that will improve performance.What should you do?
You administer a Microsoft SQL Server 2012 database named Contoso on a server named Server01.You need to write messages to the Application Log when users are added to or removed from a fixed server role in Server01.What should you create?
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?
