AWS Certified Cloud Practitioner

Explanation

Migrating the database to Amazon DynamoDB is the most operationally efficient solution because:

• Scalability: DynamoDB automatically scales to handle throughput and storage requirements without manual intervention
• Failover Protection: DynamoDB provides built-in multi-AZ replication and automatic failover capabilities
• Backup Capabilities: DynamoDB offers automated backups and point-in-time recovery features
• Operational Efficiency: As a fully managed service, DynamoDB eliminates the operational overhead of managing EC2 instances, database software, scaling, backups, and failover mechanisms

Why other options are less efficient:

• Adding EC2 instances: Requires manual scaling and doesn't provide automatic failover or backup capabilities
• Running copy in second AZ: Provides some failover protection but still requires manual management of scaling and backups
• Migrating to relational database: Not suitable for key-value NoSQL workloads and would require significant application changes

DynamoDB is specifically designed for key-value NoSQL workloads and provides all the required features as a managed service, making it the most operationally efficient choice.