For all the future deployments of SQL server on Azure virtual machines, your company plans to use Microsoft Azure resource manager templates. You have to create the templates. Solution: You create a XAML template by using Visual studio that defines the deployment and configuration setting for SQL server environment.

Can you achieve your goal with the above solution?

For all the future deployments of SQL server on Azure virtual machines, your company plans to use Microsoft Azure resource manager templates. You have to create the templates. Solution: In an azure resource group, you created the desired SQL server configuration. The template of the resource group is then exported and save it to the templates library.

Can you achieve your goal with the above solution?

For all the future deployments of SQL server on Azure virtual machines, your company plans to use Microsoft Azure resource manager templates. You have to create the templates. Solution: You create a JSON template by using Visual studio that defines the deployment and configuration setting for SQL server environment. Can you achieve your goal with the above solution?

Can you achieve your goal with the above solution?

There is a single database file tempdb which is created by using Microsoft SQL server 2014 named SRV2014. The size of the file tempdb is eight Gigabytes (GB). An SQL Server 2016 instance named SQL Server 2016 is installed by using default settings. There are eight logical processor cores in the new instance. The database SRV2014 is plan to be migrated to SRV2016. The tempdb database needs to be configured on SRV2016. You need a solution that must minimize the number of future tempdb auto-grow the events.

What should you do?

In Microsoft Azure, several GS-series virtual machines (VM) have been deployed. You are planning to deploy Microsoft SQL server in a development environment. There is a dictated disk for backups for each VM. A database needs to be backup to the local disk on a VM. The backup must be replicated to another region.

What should be the correct option for storage?

You have a 2 Terabytes (TB) database virtual machine (VM) in Microsoft Azure. By using backups to URL, Microsoft SQL server backups are performed. While minimizing costs you need to provision the storage account for the backups.

What should be the correct option for storage?

In Microsoft azure several GS-series virtual machines (VM) have been deployed. You plan to deploy Microsoft SQL server. A 30-megabytes Database needs to be deployed that requires 100 IOPS to be guaranteed while minimizing costs.

What should be the correct option for storage?

In Microsoft azure several GS-series virtual machines (VM) have been deployed. You are planning to deploy Microsoft SQL server in a development environment. Provide storage to the environment that minimizes costs.

What should be the correct option for storage?

A database is planned to migrate to Microsoft azure SQL database. The storage of 500 gigabytes (GB) is required by the database. The database must support 50 concurrent logins. The cost associated with hosting the database must be minimized. You need to create the database. Which should be the pricing tier?

In a Microsoft SQL server environment, you are managing several databases. You need to confirm that the queries use statistical data and the values should not be initialized for the local variable. Solution: Enabling the option of QUERY__OPTIMIZER_HOTFIXES for databases.

Is this solution correct for your goal?

In a Microsoft SQL server environment, you are managing several databases. You need to confirm that the queries use statistical data and the values should not be initialized for the local variable. Solution: Enabling the option of LEGACY_CARDINALITY_ESTIMATION for databases.

Is this solution correct for your goal?

In a Microsoft SQL server environment, you are managing several databases. You need to confirm that the queries use statistical data and the values should not be initialized for the local variable. Solution: Enabling the option of PARAMETER_SNIFFING for databases.

Is this solution correct for your goal?

In a Microsoft Azure virtual machine, you are managing a Microsoft SQL server environment. Always Encrypted for the columns in a database must be enabled. The key store provider needs to be configured, what should you do?

20 Microsoft Azure SQL database instances are planned to deploy to an elastic pool in Azure to support a batch processing application. Every day at the same time, two of the database in the pool reach their peak workload threshold. This leads to inconsistent performance for batch completion. To make sure that all batches perform consistently.

What should you do?

For a company, you are managing on-premises and Microsoft Azure SQL database instances. Microsoft SQL server 2012 ODBS must be supported by your environment. Only specific column in the Database must be encrypted. What should you implement?

There are several Microsoft database instances in your company. For the client application that access the data, data encryption must be allowed to be implemented. Do not make encryption keys available to the database engine. To configure the database what should you implement?

To a virtual machine in Azure, you deployed Microsoft SQL server. You distribute across multiple Azure storage disks the database files and the file group. Using SQL server management studio, the database must be able to be managed as individual entities. All the data stored in the database must be encrypted. By using the same key as the live copy of the database backups must be encrypted. In order to secure the database what should be implemented?

To support a mixed OLTP and OLAP workload you are deploying a Microsoft SQL server database. There are four CPU's in the target virtual machine. Reports must not use all available system resources. What should you do?

There is an on-premises Microsoft server 2014 environment in a company. The company's main office is in Seattle and remote offices in Amsterdam and Tokyo. To support a new application you plan to deploy a Microsoft Azure SQL Database instance. 100 users from each office are expected. In the past, when the application hosted at Seattle was used users at remote sites reported an issue. For users running reports, you need to optimize the performance while minimizing costs. What should you do?

Data in a Microsoft SQL server instance is stored by your mission- critical application. There are several financial reports running by the application. SQL Server-authenticated login named Reporting_User is used by the reports. Windows authentication is used by the queries that write data to the database. It is reported by the users that queries take a long time to complete that is used to provide data for the financial reports. The majority of CPU and memory resources are consumed by the resources on the database server. As a result, read-write queries also take a long time to complete for the application. Performance of the application needs to be improved while still allowing the report queries to finish.

Solution: A snapshot of Database is created. Configure all report queries to use the snapshot. Will you be able to achieve your goal by the above solution?

Data in a Microsoft SQL server instance is stored by your mission- critical application. There are several financial reports running by the application. SQL Server-authenticated login named Reporting _User is used by the reports. Windows authentication is used by the queries that write data to the database. It is reported by the users that queries take a long time to complete that is used to provide data for the financial reports. The majority of CPU and memory resources are consumed by the resources on the database server As a result, read-write queries also take a long time to complete for the application. Performance of the application needs to be improved while still allowing the report queries to finish.

Solution: To limit the amount of memory, CPU, ISOP used for the pool of all queries, you configure the resource Governor that the Reporting User login can run concurrently. Will you be able to achieve your goal by the above solution?

Data in a Microsoft SQL server instance is stored by your mission- critical application. There are several financial reports running by the application. The reports use a SQL Server-authenticated login named Reporting User. Windows authentication is used by the queries that write data to the database. It is reported by the users that queries take a long time to complete that is used to provide data for the financial reports. The queries consume the majority of CPU and memory resources on the database server. As a result, read-write queries also take a long time to complete for the application. Performance of the application needs to be improved while still allowing the report queries to finish.

Solution: The Resource Governor is configured to set the MAXDOP parameter for all queries to 0 against the database.

Will you be able to achieve your goal by the above solution?