Question 1 of 30
A financial services company is experiencing performance issues with its Azure SQL Database, particularly during peak transaction hours. The database is designed to handle a high volume of transactions, but users report slow response times. As a database administrator, you are tasked with optimizing the performance. Which of the following techniques would be the most effective first step to diagnose and improve the performance of the database?
Analyze the execution plans of the most frequently run queries to identify potential bottlenecks.
Increase the database's DTU (Database Transaction Units) to provide more resources.
Implement a caching layer to reduce the load on the database.
Partition the database tables to improve query performance.

Preparing for Microsoft DP-300 Administering Relational Databases on Microsoft Azure? Now land the interview.

73% of qualified candidates get rejected because of weak resumes. Build an ATS-optimized, recruiter-ready resume in under 5 minutes - free to start.

Build My Resume Free