Here you have the best Microsoft 70-765 practice exam questions
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?
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.
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?
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.
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?
B
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:
References:
https://blogs.msdn.microsoft.com/psssql/2016/03/17/sql-2016-it-just-runs-faster-automatic-tempdb-configuration/
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?
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.
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 a GS-series virtual machine (VM) in Microsoft Azure. You plan to deploy Microsoft SQL Server.
You need to deploy a 30 megabyte (MB) database that requires 100 IOPS to be guaranteed while minimizing costs.
Which storage option should you use?
A
Premium Storage Disks Limits -
When you provision a disk against a Premium Storage account, how much input/output operations per second (IOPS) and throughput (bandwidth) it can get depends on the size of the disk. Currently, there are three types of Premium Storage disks: P10, P20, and P30. Each one has specific limits for IOPS and throughput as specified in the following table:
References:
https://docs.microsoft.com/en-us/azure/storage/storage-premium-storage