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 manage a Microsoft SQL Server environment with several databases.You need to ensure that queries use statistical data and do not initialize values for local variables.Solution: You enable the QUERY_OPTIMIZER_HOTFIXES option for the databases.Does the solution meet the goal?
You plan to migrate on-premises Microsoft SQL Server databases to SQL Server on a Microsoft Azure virtual machine.A full back up of the databases is 3 TB. The corporate network has a 1.5 MB/sec Internet connection.You need to move the backups to Azure to ensure that you can restore the databases to the Azure virtual machine as quickly as possible.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.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 manage a Microsoft SQL Server environment with several databases.You need to ensure that queries use statistical data and do not initialize values for local variables.Solution: You enable the LEGACY_CARDINALITY_ESTIMATION option for the databases.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 manage a Microsoft SQL Server environment with several databases.You need to ensure that queries use statistical data and do not initialize values for local variables.Solution: You enable the PARAMETER_SNIFFING option for the databases.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?
