Online Access Free 70-765 Practice Test

You plan to migrate a Microsoft SQL Server workload from an on-premises server to a Microsoft Azure virtual machine (VM). The current server contains 4 cores with an average CPU workload of 6 percent and a peak workload of 10 percent when using 2.4Ghz processors.
You gather the following metrics:

You need to design a SQL Server VM to support the migration while minimizing costs.
For each setting, which value should you use? To answer, select the appropriate storage option from each list in the answer area.
NOTE: Each correct selection is worth one point.

Correct Answer:

Explanation:
Data drive: Premium Storage
Transaction log drive: Standard Storage
TempDB drive: Premium Storage
Note: A standard disk is expected to handle 500 IOPS or 60MB/s.
A P10 Premium disk is expected to handle 500 IOPS.
A P20 Premium disk is expected to handle 2300 IOPS.
A P30 Premium disk is expected to handle 5000 IOPS.
VM size: A3
Max data disk throughput is 8x500 IOPS
References:
https://docs.microsoft.com/en-us/azure/virtual-machines/virtual-machines-windows-sizes

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this sections, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have Microsoft SQL Server on a Microsoft Azure virtual machine that has a database named DB1.
You discover that DB1 experiences WRITE_LOG waits that are longer than 50 ms.
You need to reduce the WRITE_LOG wait time.
Solution: Move the transaction logs to a faster disk.
Does this meet the goal?

• A.Yes
• B.No
  Section: Deploy and migrate applications

You deploy a new Microsoft Azure SQL Database instance to support a variety of mobile application and public websites.
You have the following requirements:
* You must be able to replicate the database to azure datacenter in other region geo-replication.
* Clients must only connect to the Azure SQL Datacenter by using contained database users.
* You must be able to move the database to other in the future.
* Only application in the 23.96.52.0-23.96.52.255 IP range are permitted to access the database.
* Only application settings for the instance must not provide access to any other Azure services.
You need to configured the firewall for the requirement.
Which three actions should you perform? Each correct answer presents part of the solution.

• A.Run the following Transact-SQL statement:
  EXECUTE sp_set_database_firewall_rule N'Applications', '23.96.52.0', '23.96.52.255'
• B.Run the following Transact-SQL statement:
  EXECUTE sp_set_firewall_rule N'Allow Windows Azure', '0.0.0.0', '0.0.0.0'
• C.In the Azure portal, disable Allow access to Azure services for the Azure SQL Database server
• D.Run the following Transact-SQL statement:
  EXECUTE sp_set_firewall_rule N'Applications', '23.96.52.0', '23.96.52.255'
• E.Run the following Transact-SQL statement:
  EXECUTE sp_set_database_firewall_rule N'Allow Windows Azure', '0.0.0.0', '0.0.0.0'
• F.In the Azure portal, enable Allow access to Azure services for the Azure SQL Database server

You administer a Microsoft SQL Server 2014 database.
The database contains a Product table created by using the following definition:

You need to ensure that the minimum amount of disk space is used to store the data in the Product table.
What should you do?

• A.Implement row-level compression.
• B.Implement page-level compression.
• C.Convert all indexes to Column Store indexes.
• D.Implement Unicode Compression.

You have Microsoft SQL Server on a Microsoft Azure virtual machine.
You discover that queries take longer than expected to execute. You also discover that the top wait type for the SQL Server instance is ASYNC_ETWORKJO.
You need to resolve the performance issue.
What should you do?

• A.Increase the number of processor cores for the virtual machine.
• B.Allocate more memory to the SQL Server instance.
• C.Modify the application code to remove row-by-row processing.
• D.Create any missing indexes.