Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.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 create the desired SQL Server configuration in an Azure Resource Group, then export the Resource Group template and save it to the TemplatesLibrary.Does the solution meet the goal?
A company has an on-premises Microsoft SQL Server 2014 environment. The company has a main office in Seattle, and remote offices in Amsterdam and Tokyo.You plan to deploy a Microsoft Azure SQL Database instance to support a new application. You expect to have 100 users from each office.In the past, users at remote sites reported issues when they used applications hosted at the Seattle office.You need to optimize performance for users running reports while minimizing costs.What should you do?
HOTSPOT -You need to ensure that a user named Admin2 can manage logins.How should you complete the Transact-SQL statements? To answer, select the appropriate Transact-SQL segments in the answer area.Hot Area:
You plan to deploy an AlwaysOn failover cluster in Microsoft Azure. The cluster has a Service Level Agreement (SLA) that requires an uptime of at least 99.95 percent.You need to ensure that the cluster meets the SLA.Which cmdlet should you run before you deploy the virtual machine?
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 create the desired SQL Server configuration in an Azure Resource Group, then export the Resource Group template and save it to the TemplatesLibrary.Does the solution meet the goal?
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?
