- Home
- Microsoft
- Designing and Implementing Cloud Data Platform Solutions
- Microsoft.70-473.v2019-07-23.q90
- Question 41
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 41/90
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 (90q)
- Question 1: Note: This question is part of a series of questions that pr...
- Question 2: You need to recommend a high-availability solution in Micros...
- Question 3: You have a Microsoft SQL Server instance that is hosted on a...
- Question 4: Your company has two offices. The offices are located in Lon...
- Question 5: You plan to migrate a 150-GB on-premises database to a Micro...
- Question 6: Note: This question is part of a series of questions that pr...
- Question 7: Your company has a Microsoft SQL Server database hosted on a...
- Question 8: Note: This question is part of a series of questions that pr...
- Question 9: You have a Microsoft Azure SQL database named DB1. You plan ...
- Question 10: You need to recommend a database strategy to support the pla...
- Question 11: You are planning the consolidation of the databases from Hos...
- Question 12: You need to recommend a solution to meet the reporting requi...
- Question 13: You have a Microsoft Azure virtual machine named SQL1 that h...
- Question 14: You need to ensure that the performance statistics for the r...
- Question 15: You need to tell the research project leaders how to migrate...
- 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 establish a site-to-site VPN to Microsoft Azure. You nee...
- Question 19: You need to recommend a solution to meet the network require...
- Question 20: You have Microsoft SQL Server installed on a Microsoft Azure...
- Question 21: You have several SQL Server instances on Microsoft Azure vir...
- Question 22: Your company has a Microsoft Azure subscription that contain...
- Question 23: You implement Microsoft Azure ExpressRoute. You need to ensu...
- Question 24: You have a Microsoft Azure SQL database named DB1 and a copy...
- Question 25: You need to implement a solution to meet the technical requi...
- Question 26: You need to prepare the Azure environment for the planned mi...
- Question 27: What should you use to schedule the nightly jobs to meet the...
- Question 28: You have an on-premises Microsoft SQL Server 2014 database i...
- Question 29: Note: This question is part of a series of questions that pr...
- Question 30: Relecloud recently implemented the planned changes. You plan...
- Question 31: You have a failover cluster deployed to Microsoft Azure virt...
- Question 32: You need to recommend a disaster recovery solution for the C...
- Question 33: You have Microsoft SQL Server installed on a Microsoft Azure...
- Question 34: Note: This question is part of a series of questions that pr...
- Question 35: Note: This question is part of a series of questions that pr...
- Question 36: You plan to create a data warehouse in Microsoft Azure for d...
- Question 37: You have a Microsoft Azure Infrastructure as a Service (IaaS...
- Question 38: You are evaluating the use of active geo-replication for one...
- Question 39: You have Microsoft SQL Server 2014 installed on a Microsoft ...
- Question 40: Your company identifies a stored procedure that runs slowly....
- Question 41: You have Microsoft SQL Server installed on a Microsoft Azure...
- Question 42: You plan to migrate an on-premises Microsoft SQL Server data...
- Question 43: You plan to deploy a data platform solution for 4 TB of data...
- Question 44: You have an application named App1 that uses a Microsoft Azu...
- Question 45: Note: This question is part of a series of questions that pr...
- Question 46: You need to recommend an auditing solution that meets the bu...
- Question 47: Your company's data warehouse contains several Microsoft SQL...
- Question 48: You are evaluating moving the data from WebData1 to an Azure...
- Question 49: You have a server named SQL1 that has Microsoft SQL Server 2...
- Question 50: Your Microsoft Azure environment contains an elastic pool th...
- Question 51: In this section you will see one or more sets of questions w...
- Question 52: You need to design a security strategy to support the planne...
- Question 53: You have a Microsoft SQL Server instance on a Microsoft Azur...
- Question 54: Note: This question is part of a series of questions that pr...
- Question 55: You need to recommend a backup solution for the ListTest dat...
- Question 56: You have a Microsoft Azure virtual machine that has Microsof...
- Question 57: You need to recommend a solution to migrate the Listings dat...
- Question 58: You have a report that runs against a Microsoft Azure SQL da...
- Question 59: Which database platform should App3 use?...
- Question 60: You have a Microsoft Azure SQL database. You need to configu...
- Question 61: You need to implement a disaster recovery solution that meet...
- Question 62: Which three components are required to meet the encryption r...
- Question 63: You are designing the data warehouse. You need to recommend ...
- Question 64: You are evaluating the migration of an on-premises Microsoft...
- Question 65: Note: This question is part of a series of questions that pr...
- Question 66: Note: This question is part of a series of questions that pr...
- Question 67: You are designing a cloud architecture for an organizational...
- Question 68: Note: This question is part of a series of questions that pr...
- Question 69: You plan to deploy a highly available Microsoft SQL Server s...
- Question 70: You need to identify which service tier to use for the resea...
- Question 71: You are evaluating whether an Azure SQL Database elastic dat...
- Question 72: You have a Microsoft Azure SQL database. You need to audit t...
- Question 73: You manage a large Microsoft Azure SQL database. The databas...
- Question 74: You have a Microsoft Azure SQL database. You need to ensure ...
- Question 75: You need to recommend a solution to migrate the Listings dat...
- Question 76: Your environment contains a Microsoft Azure virtual machine ...
- Question 77: You deploy a Microsoft SQL Server instance on a Microsoft Az...
- Question 78: Your company has a Microsoft Azure MySQL database that is us...
- Question 79: Your company has two offices located in London and New York....
- Question 80: You have a Microsoft Azure Infrastructure as a Service (IaaS...
- Question 81: You have a Microsoft Azure SQL data warehouse. During peak u...
- Question 82: You are planning the migration of SQL01 to an Azure virtual ...
- Question 83: You have a Microsoft SQL Server instance that hosts a databa...
- Question 84: You have a Microsoft Azure SQL database. The database is hos...
- Question 85: You have an application named App1 that connects to a Micros...
- Question 86: Your company has a data warehouse that contains a database n...
- Question 87: You have a Microsoft SQL Server 2014 instance on a Microsoft...
- Question 88: Your company has an application that uses several Microsoft ...
- Question 89: Your environment contains several Microsoft Azure SQL databa...
- Question 90: You plan to implement a Microsoft Azure SQL database. You ne...
