Provisioning SQL Databases Free Sample Questions

You are preparing to provide support for a batch processing application by deploying 25 Microsoft Azure SQL Database instances to an elastic pool in Azure. You notice that two of the databases in the pool reach their peak workload threshold simultaneously on a daily basis, which results in erratic batch completion performance. You are required to make sure that all batches execute reliably.

Solution: You raise the pool’s storage limit.

Has the requirement been satisfied?

After recently deploying a number of GS-series virtual machines (VMs) in Microsoft Azure, you are preparing to deploy Microsoft SQL Server.
You are required to deploy a 40 MB database. You want to make sure that you make use of a storage option that guarantees 100 IOPS, but keeps expenses to a minimum.

Solution: You configure the use of Premium P4 disk storage.

Has the requirement been satisfied?

A Microsoft Azure virtual machine (VM) hosts a 2 TB database. The Backup to URL method is employed for Microsoft SQL Server backups. You have been tasked with provisioning the storage account for these backups. You are informed that expenses should be as little as possible. You want to employ a storage option that meets these requirements.

Solution: You configure the use of standard zone redundant blob storage.

Has the requirement been satisfied?