The correct option is Yes, Yes, Yes.

Managed cloud SQL services routinely include automated backups and the ability to restore to a point in time within the configured retention period. This capability is part of the backup and recovery features that let you recover from user errors or data corruption by restoring to a specific time during the retention window.

These services also provide built in high availability with automatic failover and redundant replicas to reduce downtime. High availability is implemented by using standby instances or replicas and automated failover so that client traffic can continue when an instance or zone fails.

Many managed SQL offerings can integrate with an Advanced Threat Protection capability or equivalent managed threat detection and response services to surface suspicious activity and provide additional security controls. That integration is offered so you can detect anomalous behavior and respond to potential threats.

Yes, No, Yes is incorrect because it denies the built in high availability and automatic failover feature. Managed SQL services normally include HA so answering No for that statement makes the option wrong.

Yes, No, No is incorrect because it rejects both the high availability and the threat protection statements. Both of those are commonly supported by managed SQL offerings so this option does not match the expected capabilities.

Full AWS Practitioner Certification Question