- Home
- Microsoft
- Designing and Implementing Cloud Data Platform Solutions
- Microsoft.70-473.v2018-10-23.q56
- Question 45
Valid 70-473 Dumps shared by EduDump.com for Helping Passing 70-473 Exam! EduDump.com now offer the newest 70-473 exam dumps, the EduDump.com 70-473 exam questions have been updated and answers have been corrected get the newest EduDump.com 70-473 dumps with Test Engine here:
Access 70-473 Dumps Premium Version
(170 Q&As Dumps, 35%OFF Special Discount Code: freecram)
<< Prev Question Next Question >>
Question 45/56
You have Microsoft SQL Server installed on a Microsoft Azure virtual machine.
One of the databases on the virtual machine supports a highly active Online Transaction Processing (OLTP) application.
Users report abnormally long wait times when they submit data in the application.
Which two tools can you use to identify the longest running queries? Each correct answer presents a complete solution.
One of the databases on the virtual machine supports a highly active Online Transaction Processing (OLTP) application.
Users report abnormally long wait times when they submit data in the application.
Which two tools can you use to identify the longest running queries? Each correct answer presents a complete solution.
Correct Answer: A,B
Explanation/Reference:
Explanation:
A: Microsoft Azure SQL Database enables a subset of dynamic management views to diagnose performance problems, which might be caused by blocked or long-running queries, resource bottlenecks, poor query plans, and so on. You can detect such common performance problems by using dynamic management views.
B: The SQL Profiler has been replaced by SQL Server Extended Events.
Extended Events works via Event Tracing (ETW). This has been the common way for all Microsoft related technologies to expose diagnostic data.
ETW provides much more flexibility.
Reference:
https://docs.microsoft.com/en-us/azure/sql-database/sql-database-monitoring-with-dmvs
https://stackify.com/performance-tuning-in-sql-server-find-slow-queries
Explanation:
A: Microsoft Azure SQL Database enables a subset of dynamic management views to diagnose performance problems, which might be caused by blocked or long-running queries, resource bottlenecks, poor query plans, and so on. You can detect such common performance problems by using dynamic management views.
B: The SQL Profiler has been replaced by SQL Server Extended Events.
Extended Events works via Event Tracing (ETW). This has been the common way for all Microsoft related technologies to expose diagnostic data.
ETW provides much more flexibility.
Reference:
https://docs.microsoft.com/en-us/azure/sql-database/sql-database-monitoring-with-dmvs
https://stackify.com/performance-tuning-in-sql-server-find-slow-queries
- 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...
