Provisioning SQL Databases

Here you have the best Microsoft 70-765 practice exam questions

  • You have 168 total questions to study from
  • Each page has 5 questions, making a total of 34 pages
  • You can navigate through the pages using the buttons at the bottom
  • This questions were last updated on October 14, 2025
  • This site is not affiliated with or endorsed by Microsoft.
Question 1 of 168
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?
    Correct Answer: B

    Azure Resource Manager (ARM) templates are specified using JSON format, not XAML. To create a template for deploying and configuring SQL Server on Azure virtual machines, you need to use JSON format to define the deployment and configuration settings. Therefore, using Visual Studio to create a XAML template would not meet the goal.

Question 2 of 168
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 create the desired SQL Server configuration in an Azure Resource Group, then export the Resource Group template and save it to the Templates
Library.
Does the solution meet the goal?
    Correct Answer: A

    The solution involves creating a SQL Server configuration within an Azure Resource Group, then exporting the Resource Group template and saving it to the Templates Library. This meets the goal because Azure supports exporting Resource Group templates, which can be used for future deployments. This process effectively captures the configuration and dependencies within an ARM template, aligning with the requirement to use Azure Resource Manager templates for deployments.

Question 3 of 168
You have a Microsoft SQL Server 2014 named SRV2014 that has a single tempdb database file. The tempdb database file is eight gigabytes (GB) in size.
You install a SQL Server 2016 instance named SQL Server 2016 by using default settings. The new instance has eight logical processor cores.
You plan to migrate the databases from SRV2014 to SRV2016.
You need to configure the tempdb database on SRV2016. The solution must minimize the number of future tempdb autogrowth events.
What should you do?
    Correct Answer: A
    In an effort to simplify the tempdb configuration experience, SQL Server 2016 setup has been extended to configure various properties for tempdb for multi- processor environments.
    1. A new tab dedicated to tempdb has been added to the Database Engine Configuration step of setup workflow.
    2. Configuration options:

    Data Files -
    ✑ Number of files this will default to the lower value of 8 or number of logical cores as detected by setup.
    ✑ Initial size is specified in MB and applies to each tempdb data file. This makes it easier to configure all files of same size. Total initial size is the cumulative tempdb data file size (Number of files * Initial Size) that will be created.
    ✑ Autogrowth is specified in MB (fixed growth is preferred as opposed to a non-linear percentage based growth) and applies to each file. The default value of
    64MB was chosen to cover one PFS interval.
    Figure:
    Exam 70-765: Question 3 - Image 1
    References:
    https://blogs.msdn.microsoft.com/psssql/2016/03/17/sql-2016-it-just-runs-faster-automatic-tempdb-configuration/ B
Question 4 of 168
Note: This question is part of a series of questions that use the same or similar answer choices. An answer choice may be correct for more than one question in the series. Each question is independent of the other questions in this series. Information and details provided in a question apply only to that question.
You have deployed several GS-series virtual machines (VMs) in Microsoft Azure. You plan to deploy Microsoft SQL Server in a development environment. Each
VM has a dedicated disk for backups.
You need to backup a database to the local disk on a VM. The backup must be replicated to another region.
Which storage option should you use?
    Correct Answer: H

    To back up the database to the local disk on a VM and ensure that the backup is replicated to another region, you should use Standard geo-redundant blob storage. This storage option provides replication to a secondary region (geo-redundancy) to ensure durability and high availability of data in the event of a regional outage. While the virtual machines (VMs) have dedicated disks for local backups, the requirement to replicate to another region is adequately met by using geo-redundant blob storage.

Question 5 of 168
Note: This question is part of a series of questions that use the same or similar answer choices. An answer choice may be correct for more than one question in the series. Each question is independent of the other questions in this series. Information and details provided in a question apply only to that question.
You have a virtual machine (VM) in Microsoft Azure, which has a 2 terabyte (TB) database. Microsoft SQL Server backups are performed by using Backup to URL.
You need to provision the storage account for the backups while minimizing costs.
Which storage option should you use?
    Correct Answer: G