AWS Exams GCP Exams Azure Exams GitHub Exams Jira Exams ISC2 Exams

Video: Identify the missing word(s) in the following azure video

Question 1 Be Honest
« Back   Next azure Cloud dp-300-database-admin-assoc Question »
Answer

Full Certification Question

Identify the missing word(s) in the following sentence within the context of Microsoft Azure. The path most DBAs take to troubleshoot query performance is to first identify the problematic query (typically the query consuming the highest amount of system resources), and then retrieve that query’s execution plan. There are two scenarios. The query consistently performs poorly. The query performs well for some executions, but not others. [?] use of row-based operations with cursors or WHILE loops is important and there are other SQL Server anti-patterns that you should be able to recognize as well. Table-valued functions (TVF), particularly multi-statement table-valued functions, caused problematic execution plan patterns prior to SQL Server 2017. Many developers like to use multi-statement table valued functions because they can execute multiple queries within a single function and aggregate the results into a single table.