Provisioning SQL Databases Free Sample Questions

7 free sample questions48 in the full practice test Other versions: DP-300(269),70-764(49)

Try simulator

70-765 Sample Questions

  1. Question 1

    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?

    Answer and explanation

    Correct answer: A

    A

  2. Question 2

    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?

    Answer and explanation

    Correct answer: A

    Explanation:
    P4 and P6 disk sizes are as yet only supported for Managed Disks.
    References: docs.microsoft.com/en-us/azure/storage/storage-premium-storage#premium-storage-supported-vms">https://docs.microsoft.com/en-us/azure/storage/storage-premium-storage#premium-sto

  3. Question 3

    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?

    Answer and explanation

    Correct answer: B

    Explanation:
    Zonel^dundant blob storage would be expensive as it stores three copies of data across multiple datacenters within or across regions.
    References: azure.microsoft.com/en-us/pricing/details/storage/blobs/">https://azure.microsoft.com/en-us/pricing/details/storage/blobs/

Register free for 4 more questions

Or unlock all 48 70-765 questions with explanations, timed mode and flashcards.