Question 1 of 30
A company is planning to migrate its on-premises SQL Server database to Azure SQL Database. They have a database that is currently 500 GB in size and experiences an average of 200 transactions per second (TPS). The company wants to ensure that the Azure SQL Database can handle the same workload with minimal latency. They are considering the use of the Hyperscale service tier for its scalability. What factors should the company consider when estimating the required resources for their Azure SQL Database to maintain performance, particularly in terms of DTUs and storage?
The number of DTUs required should be based on the expected transaction volume and the complexity of queries, while storage should account for future growth and backup requirements.
The DTUs can be calculated solely based on the current database size, and storage should be set to a fixed amount without considering future growth.
The company should only focus on the number of transactions per second without considering the complexity of the queries being executed.
The performance of Azure SQL Database is independent of the number of DTUs and storage size, as it automatically scales based on workload.

Preparing for Microsoft AI-102 Designing and Implementing a Microsoft Azure AI Solution? 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