Question: You have set of SQL databases used with various PaaS applications with predictable usage patterns. You are planning to move these databases to Azure SQL and need to choose the right deployment option. Your priorities are minimizing costs, and having the ability to assign CPU and resources to individual databases. Which option should you choose?
- Azure SQL elastic pool
- SQL on Azure VMs
- Azure SQL Database
- SQL Managed Instance
Answer: The correct answer of the above question is Option A:Azure SQL elastic pool