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 limit the amount of memory, CPU, and IOPS used for the pool of all queries that the Reporting_user login can run concurrently.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.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:
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.After reviewing the plan cache you have identified that a large number of simple queries are using parallelism, and that execution plans are not being kept in the plan cache for very long.You review the properties of the instance (Click the Exhibit button).Exhibit:You need to resolve the identified issues.Use the drop-down menus to select the answer choice that answers each question based on the information presented in the graphic.Hot Area:
HOTSPOT -Background -You are the database administrator for Contoso, Ltd. The company has 200 offices around the world. The company has corporate executives that are located in offices in London, New York, Toronto, Sydney, and Tokyo.Contoso, Ltd. has a Microsoft Azure SQL Database environment. You plan to deploy a new Azure SQL Database to support a variety of mobile applications and public websites.The company is deploying a multi-tenant environment. The environment will host Azure SQL Database instances. The company plans to make the instances available to internal departments and partner companies. Contoso is in the final stages of setting up networking and communications for the environment.Existing Contoso and Customer instances need to be migrated to Azure virtual machines (VM) according to the following requirements:✑ Contoso instances should use the method requiring the least administrative effort to migrate instances to Azure Vms.✑ Customer instances should use a method that allows customers to bring their own licenses to Azure VMs. Customers have approved down time for the migration.The company plans to deploy a new order entry application and a new business intelligence and analysis application. Each application will be supported by a new database. Contoso creates a new Azure SQL database named Reporting. The database will be used to support the company's financial reporting requirements.You associate the database with the Contoso Azure Active Directory domain.Each location database for the data entry application may have an unpredictable amount of activity. Data must be replicated to secondary databases in Azure datacenters in different regions.To support the application, you need to create a database named contosodb1 in the existing environment.Objects -Database -The contosodb1 database must support the following requirements:✑ a size of at least 200 gigabytes (GB)✑ 1,000 concurrent sessions✑ point-in-time restore to any point in the two weeks prior to a failure✑ minimize costsApplication -For the business intelligence application, corporate executives must be able to view all data in near real-time with low network latency.Contoso has the following security, networking, and communications requirements:✑ Multi-Location Load Balancing to ensure customers have access to their tenants at multiple Azure locations across the world.✑ Secure Message/Data Flow to securely support communication between Azure and on-premises applications and services.✑ Accounts should support accessing external domain resources and be configured in the most secure and lowest-maintenance way possible, including meeting the company policy of regular service account password changes.You need to configure the data entry and business intelligence databases.In the table below, identify the option that you must use for each database.NOTE: Make only one selection in each column.Hot Area:
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?
