70-473 · Question #65
Which database platform should App3 use?
The correct answer is A. Azure SQL Database. App3 should use Azure SQL Database as its platform because it is a fully managed, scalable, and highly available relational database service for Microsoft SQL Server workloads. This choice minimizes administrative overhead and provides a robust database solution.
Question
Exhibit
Options
- AAzure SQL Database
- BAzure Database for PostgreSQL
- CAzure Database for MySQL
- Dan Azure virtual machine that has SQL Server installed
How the community answered
(15 responses)- A87% (13)
- B7% (1)
- C7% (1)
Why each option
App3 should use Azure SQL Database as its platform because it is a fully managed, scalable, and highly available relational database service for Microsoft SQL Server workloads. This choice minimizes administrative overhead and provides a robust database solution.
Azure SQL Database is a fully managed Platform-as-a-Service (PaaS) offering that provides a highly scalable, available, and secure relational database service compatible with SQL Server, minimizing administrative overhead.
Azure Database for PostgreSQL is a managed service for the PostgreSQL database engine, which would only be suitable if App3 specifically required PostgreSQL.
Azure Database for MySQL is a managed service for the MySQL database engine, which would only be suitable if App3 specifically required MySQL.
An Azure virtual machine that has SQL Server installed is an Infrastructure-as-a-Service (IaaS) solution that requires significant administrative effort for patching, backups, and high availability, which is generally less desirable than a PaaS offering like Azure SQL Database unless specific OS-level control is needed.
Concept tested: Choosing appropriate Azure SQL database platform
Source: https://learn.microsoft.com/en-us/azure/azure-sql/database/sql-database-paas-overview
Topics
Community Discussion
No community discussion yet for this question.