Answered

Welcome to Westonci.ca, the place where your questions find answers from a community of knowledgeable experts. Our platform connects you with professionals ready to provide precise answers to all your questions in various areas of expertise. Connect with a community of professionals ready to provide precise solutions to your questions quickly and accurately.

Your company is designing a multi-tenant application that will use elastic pools and Azure SQL databases. The application will be used by 30 customers.
You need to design a storage solution for the application. The solution must meet the following requirements:
✑ Operational costs must be minimized.
✑ All customers must have their own database.
✑ The customer databases will be in one of the following three Azure regions: East US, North Europe, or South Africa North.
What is the minimum number of elastic pools and Azure SQL Database servers required?

Sagot :

anthougo

Answer:

The minimum number of elastic pools and Azure SQL Database servers required is:

three elastic pools and one Azure SQL Database server.

Explanation:

The above will ensure that the Azure regions of East US, North Europe, or South Africa North are grouped into their three elastic pools.  Since cost minimization must be achieved, at the same time, one Azure SQL Database server will be enough to manage the 30 databases required, with one for each customer.  Creating more than one Database server will increase the operational costs.

Thanks for using our service. We're always here to provide accurate and up-to-date answers to all your queries. Thank you for your visit. We're committed to providing you with the best information available. Return anytime for more. Westonci.ca is here to provide the answers you seek. Return often for more expert solutions.