You are developing customized Microsoft Azure Resource Group templates to automate the process of deploying Microsoft SQL Server in Azure to enforce consistency during future deployments.You need to deploy the customized templates to the Azure environment and to external endpoints.Which resource value should you populate?
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.You have a mission-critical application that stores data in a Microsoft SQL Server instance. The application runs several financial reports. The reports use a SQLServer-authenticated login named Reporting_User. All queries that write data to the database use Windows authentication.Users report that the queries used to provide data for the financial reports take a long time to complete. The queries consume the majority of CPU and memory resources on the database server. As a result, read-write queries for the application also take a long time to complete.You need to improve performance of the application while still allowing the report queries to finish.Solution: You configure the Resource Governor to set the MAXDOP parameter to 0 for all queries against the database.Does the solution meet the goal?
HOTSPOT -Background -You manage the Microsoft SQL Server environment for a company that manufactures and sells automobile parts.The environment includes the following servers: SRV1 and SRV2. SRV1 has 16 logical cores and hosts a SQL Server instance that supports a mission-critical application. The application has approximately 30,000 concurrent users and relies heavily on the use of temporary tables.The environment also includes the following databases: DB1, DB2, and Reporting. The Reporting database is protected with Transparent Data Encryption(TDE). You plan to migrate this database to a new server. You detach the database and copy it to the new server.You are performing tuning on a SQL Server database instance. The application which uses the database was written using an object relationship mapping (ORM) tool which maps tables as objects within the application code. There are 30 stored procedures that are regularly used by the application.Exhibit -You need to optimize SRV1.What configuration changes should you implement? To answer, select the appropriate option from each list in the answer area.Hot Area:
You manage a Microsoft SQL Server environment in a Microsoft Azure virtual machine.You must enable Always Encrypted for columns in a database.You need to configure the key store provider.What should you do?
Note: This question is part of a series of questions that use the same or similar answer choices. An answer choice may be correct for more than one question in the series. Each question is independent of the other questions in this series. Information and details provided in a question apply only to that question.You have deployed several GS-series virtual machines (VMs) in Microsoft Azure. You plan to deploy Microsoft SQL Server in a development environment. EachVM has a dedicated disk for backups.You need to backup a database to the local disk on a VM. The backup must be replicated to another region.Which storage option should you use?
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?
