CV0-002 · Question #601
A relational database is hosted on a single VM in a public cloud. As the load on the database is predicted to increase, the cloud administrator is tasked with improving the database service with…
The correct answer is A. Migrate the database to a serverless database service. To achieve higher scalability, more automation, and minimal downtime for a relational database, migrating to a serverless database service is the best solution as it provides automatic scaling of compute and storage, along with managed operational tasks.
Question
A relational database is hosted on a single VM in a public cloud. As the load on the database is predicted to increase, the cloud administrator is tasked with improving the database service with more scalability and automation, without downtime. Which of the following solutions BEST meets these requirements?
Options
- AMigrate the database to a serverless database service.
- BMigrate the database storage of the VM to a scalable block store.
- CConfigure the VM to automatically scale up or down.
- DIncrease the IOPS of the database storage disk.
How the community answered
(26 responses)- A69% (18)
- B15% (4)
- C12% (3)
- D4% (1)
Why each option
To achieve higher scalability, more automation, and minimal downtime for a relational database, migrating to a serverless database service is the best solution as it provides automatic scaling of compute and storage, along with managed operational tasks.
Migrating to a serverless database service offers inherent automatic scalability for both compute and storage resources, robust automation for patching and backups, and is designed to operate with high availability, effectively addressing the requirements for scalability, automation, and minimal downtime. These services abstract away infrastructure management, allowing the database to scale seamlessly under varying loads.
Migrating only the storage to a scalable block store enhances storage scalability and performance but does not address the compute scalability or the comprehensive automation benefits provided by a fully managed database service.
Configuring a VM to automatically scale up (vertical scaling) often involves downtime during resizing operations and does not offer the same level of granular, automatic scaling for relational databases that a dedicated serverless database service provides.
Increasing the IOPS of the database storage disk only improves disk performance, which is a single aspect of scalability, and does not provide comprehensive compute scalability or the broad automation features of a managed database service.
Concept tested: Managed database services and serverless computing
Source: https://learn.microsoft.com/en-us/azure/azure-sql/database/serverless-tier-overview
Topics
Community Discussion
No community discussion yet for this question.