What are the core data protection considerations for cloud databases, including backups, PITR, replication, and encryption?

• A. Backups and point-in-time recovery, along with replication and encryption, are key considerations for cloud databases.
• B. Replication is optional and encryption is unnecessary.
• C. Backups should be avoided to save space.
• D. Access control is irrelevant to database security.

Answer: (A)

Protecting data in cloud databases revolves around ensuring you can recover from problems, keep data available, and keep it unreadable to unauthorized users. Backups create restore points you can rely on after data loss or corruption. Point-in-time recovery takes that a step further, letting you roll back to a precise moment before an incident, which is crucial for recovering from mistakes, corruption, or ransomware without losing everything. Replication copies data to a secondary location or system, boosting durability and availability and enabling quick failover if the primary site goes down. Encryption protects data at rest and in transit, reducing the risk of data exposure even if access controls are bypassed or the data storage is compromised.

Together, backups, PITR, replication, and encryption cover restore capability, precise recovery, continuous availability, and data confidentiality—all essential for cloud database protection. The other statements fall short because they downplay these protections—such as treating replication as optional, encryption as unnecessary, avoiding backups to save space, or ignoring access controls—each of which would weaken security and resilience.