<< Prev Question Next Question >>

Question 40/56

You have Microsoft SQL Server installed on a Microsoft Azure virtual machine. The virtual machine is on the Standard D3 service tier. All of the data files for the databases on the virtual machine are located on a single volume that is mounted as drive E.
The virtual machine experiences performance issues.
You view the wait statistics and discover a high number of РАGEIOLATCH_SH waits associated to the tempdb data files.
You need to resolve the performance issues.
What should you do?

LEAVE A REPLY

Your email address will not be published. Required fields are marked *

Question List (56q)
Question 1: You need to tell the research project leaders how to migrate...
Question 2: You need to deploy a new Microsoft Azure SQL database that m...
Question 3: You need to recommend a solution to meet the reporting requi...
Question 4: You recently implemented a Microsoft Azure SQL data warehous...
Question 5: You need to recommend a disaster recovery solution for the C...
Question 6: You are evaluating moving the data from WebData1 to an Azure...
Question 7: You plan to deploy a data platform solution for 4 TB of data...
Question 8: You are evaluating the use of active geo-replication for one...
Question 9: You plan to create a data warehouse in Microsoft Azure for d...
Question 10: You manage a large Microsoft Azure SQL database. The databas...
Question 11: Your company has a Microsoft Azure MySQL database that is us...
Question 12: You have a Microsoft Azure SQL database named DB1 and a copy...
Question 13: You have a Microsoft SQL Server instance on a Microsoft Azur...
Question 14: You have a Microsoft Azure SQL database named DB1. You need ...
Question 15: You plan to implement a Microsoft Azure SQL database. You ne...
Question 16: You are evaluating whether to replace CRM-B with an Azure vi...
Question 17: Your environment contains a Microsoft Azure virtual machine ...
Question 18: You need to recommend an auditing solution that meets the bu...
Question 19: You have 10 Microsoft Azure SQL database. One of the databas...
Question 20: You have an application named App1 that uses a Microsoft Azu...
Question 21: Note: This question is part of a series of questions that pr...
Question 22: You need to recommend a solution to meet the network require...
Question 23: What should you use to schedule the nightly jobs to meet the...
Question 24: You need to recommend a backup solution for the ListTest dat...
Question 25: You have a Microsoft SQL Server 2014 instance on a Microsoft...
Question 26: You need to ensure that the performance statistics for the r...
Question 27: You are planning the consolidation of the databases from Hos...
Question 28: You need to configure a runbook to execute when a Microsoft ...
Question 29: Your company has two offices located in London and New York....
Question 30: Note: This question is part of a series of questions that pr...
Question 31: You need to create a Microsoft Azure Resource Manager templa...
Question 32: You need to recommend a solution to migrate the Listings dat...
Question 33: Your company has a Microsoft SQL Server database hosted on a...
Question 34: Note: This question is part of a series of questions that pr...
Question 35: You have a Microsoft Azure SQL database named DB1. You plan ...
Question 36: You are evaluating whether an Azure SQL Database elastic dat...
Question 37: You need to recommend a solution to migrate the Listings dat...
Question 38: You have a Microsoft Azure Infrastructure as a Service (IaaS...
Question 39: Note: This question is part of a series of questions that pr...
Question 40: You have Microsoft SQL Server installed on a Microsoft Azure...
Question 41: In this section you will see one or more sets of questions w...
Question 42: You implement Microsoft Azure ExpressRoute. You need to ensu...
Question 43: You have a Microsoft Azure SQL database. The database is hos...
Question 44: Your company register the domain name of contoso.com. You pl...
Question 45: You have Microsoft SQL Server installed on a Microsoft Azure...
Question 46: You are evaluating the migration of an on-premises Microsoft...
Question 47: You are designing the data warehouse. You need to recommend ...
Question 48: You have a Microsoft Azure SQL database that is used for rep...
Question 49: Your company has two offices. The offices are located in Lon...
Question 50: You deploy a Microsoft SQL Server instance on a Microsoft Az...
Question 51: You have a failover cluster deployed to Microsoft Azure virt...
Question 52: Your company has a data warehouse that contains a database n...
Question 53: You have a Microsoft Azure SQL database. You need to ensure ...
Question 54: You have a hybrid Microsoft SQL Server environment that has ...
Question 55: You have an on-premises Microsoft SQL Server 2014 database i...
Question 56: You have an organizational data mart that contains 3.5 TB of...