Online Access Free 070-765 Practice Test

You use Resource Manager to deploy a new Microsoft SQL Server instance in a Microsoft Azure virtual machine (VM) that uses Premium storage. The combined initial size of the SQL Server user database files is expected to be over 200 gigabytes (GB). You must maximize performance for the database files and the log file.
You add the following additional drive volumes to the VM:

You have the following requirements:
Maximize performance of the SQL Server instance.
Use Premium storage when possible.
You need to deploy the SQL instance.
In the table below, identify the drive where you must store each SQL Server file type.
NOTE: Make only one selection in each column. Each correct selection is worth one point.

Correct Answer:

Explanation:
Enable read caching on the disk(s) hosting the data files and TempDB.
Do not enable caching on disk(s) hosting the log file. Host caching is not used for log files.
Incorrect Answers:
C, D: Avoid using operating system or temporary disks for database storage or logging.
References:
https://docs.microsoft.com/en-us/azure/virtual-machines/windows/sql/virtual-machines-windows-sql-performance

You are deploying a Microsoft SQL Server database that will support a mixed OLTP and OLAP workload. The target virtual machine has four CPUs.
You need to ensure that reports do not use all available system resources.
What should you do?

• A.Set MAXDOP to half the number of CPUs available.
• B.Enable Auto Close.
• C.Increase the value for the Minimum System Memory setting.
• D.Increase the value for the Minimum Memory per query setting.

You have Microsoft SQL Server on a Microsoft azure virtual machine that has 12 databases.
All database files are in the same Azure Blob storage account.
You need to receive an email notification if I/O operations to the database files exceed 800 MB/s for more than five minutes.
Solution: You run the Get-Counter cmdlet and specify the -counter '\physicaldisk:disk write/sec' parameter.
Does this meet the goal?

• A.Yes
• B.No

You plan to create an AlwaysOn availability group that will have two replicas in Microsoft Azure and two onpremises replicas.
You need to ensure that a replica in Azure is always available.
Which cmdlet should you run before you deploy the virtual machines?

• A.New-AzureRmAvailabilitySet
• B.New-AzureRmSqlDatabaseCopy
• C.New-AzureRmVM
• D.New-AzureRmSqlServer
• E.New-AzureRmSqlServerCommunicationLink
• F.New-AzureRmSqlElasticPool
• G.New-AzureRmSqlDatabaseSecondary
• H.New-AzureRmLoadBalancer

You have a server named server1-contoso.database.windows.net that has a Microsoft Azure SQL database.
You need to create a group of Azure SQL databases that share the resources on server1-contoso.database.windows.net.
Which cmdlet should you run before you create the database?

• A.New-AzureRmAvailabilitySet
• B.New-AzureRmSqlDatabaseCopy
• C.New-AzureRmVM
• D.New-AzureRmSqlServer
• E.New-AzureRmSqlServerCommunicationLink
• F.New-AzureRmSqlElasticPool
• G.New-AzureRmSqlDatabaseSecondary
• H.New-AzureRmLoadBalancer