Query Performance Insight Quiz

5 questions Pass: 70% +25 pts (50 with Pro)

Quiz covering Performance Monitoring

What you'll be asked

  1. Which of the following metrics is most commonly used to identify a query that is consuming excessive CPU resources?
  2. You notice a query has a high 'Wait Time' but low CPU usage. What is the most likely cause?
  3. When analyzing a query execution plan, what does a 'Table Scan' or 'Full Index Scan' usually indicate for a large dataset?
  4. A query is performing well on small test datasets but becomes extremely slow in production. What is the most common reason for this behavior?
  5. You are troubleshooting a query that performs a 'Hash Match' join. If the 'Build' input of the hash join is significantly larger than the available memory grant, what performance issue will occur?

Answers and explanations come after you submit.