Tamilalt Inc has been storing essential customer data in a database on a local server copy of PostgreSQL. Their database storage needs have expanded, and they are now looking for a cloud-based solution. Tamilalt no longer wants to manage its PostgreSQL server, and high availability is now important as the customer base grows.
As their IT pro, what open-source database solution would you suggest?
A)Azure Database for MySQL
B)Azure Cosmos DB
C)Azure SQL Database, Elastic Pool
D)Azure Database for PostgreSQL, Single Server option
E)Azure Database for PostgreSQL, Hyperscale Option
Explanation
The best solution for Tamilalt would be to use the Azure Database for PostgreSQL, Single Server. The Single Server option will meet their needs. It is a fully managed service and offers a 99.99% performance guarantee.
An Azure SQL Database, Elastic Pool, would not be the solution for Tamilalt. They would have to convert their database to SQL. Also, SQL Database is not an open-source solution.
The Azure Database for MySQL could meet Tamilalt 's needs. Still, there is no particular benefit to converting the database to MySQL, as there is an Azure offering that already works with PostgreSQL.
The Azure Cosmos DB option would not work for Tamilalt. Cosmos DB is not a relational database.
Azure Database for PostgreSQL, Hyperscale option would work for Tamilalt, but it is not the best option. Hyperscale offers high-performance horizontal scaling, but the scenario does not indicate a need for this additional functionality.
The Azure Database for PostgreSQL is also now offered in a third option, Flexible Server, currently in preview. As the name suggests, this service allows more granular control and flexibility. It is best for workloads that don't need full computing power continuously.
Objective:
Describe core Azure services
Sub-Objective:
Describe core resources available in Azure
References:
Azure > PostgreSQL > What is Azure Database for PostgreSQL?
Post a Comment
Thanks for your comment