Question 1 of 30
A company is evaluating its Azure SQL Database service tier options to optimize performance for its e-commerce application, which experiences fluctuating workloads. The application requires a minimum of 200 DTUs (Database Transaction Units) during peak hours but can operate efficiently with 50 DTUs during off-peak hours. The company is considering the following service tiers: Basic, Standard, and Premium. If the company opts for the Standard tier with a provisioned performance level of 200 DTUs, what would be the most cost-effective approach to manage the database performance while ensuring that the application remains responsive during peak usage?
Utilize the auto-scaling feature to dynamically adjust DTUs based on workload demands.
Manually adjust the DTUs every week based on historical usage patterns.
Keep the database at a constant 200 DTUs regardless of workload fluctuations.
Migrate the database to a Basic tier to save costs during off-peak hours.

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