SCP-DPA — SolarWinds Certified Professional - Database Performance Analyzer Query Practice Questions

A database admin reports that a query is taking too long to execute. What feature in DPA can you use to optimize this query?

• AA. Transaction log analysis
• BB. Query performance metrics
• CC. Backup report
• DD. Disk space report

You are interested in understanding how user queries impact your database performance. Which feature will help you analyze user query performance in DPA?

• AA. Wait statistics
• BB. Resource allocation
• CC. Query performance metrics
• DD. Query plans

A developer has submitted a query that runs very slowly on the production environment. What is the best first step to troubleshoot this query?

• AA. Review the query execution plan
• BB. Limit user access
• CC. Revert to a previous version of the database
• DD. Increase server resources