A Finance Company Needs to Make Sure That Its MySQL

question 89

Multiple Choice

A finance company needs to make sure that its MySQL database backups are available for the most recent 90 days. All of the MySQL databases are hosted on Amazon RDS for MySQL DB instances. A database specialist must implement a solution that meets the backup retention requirement with the least possible development effort. Which approach should the database specialist take?

• A) Use AWS Backup to build a backup plan for the required retention period. Assign the DB instances to the backup plan.
• B) Modify the DB instances to enable the automated backup option. Select the required backup retention period.
• C) Automate a daily cron job on an Amazon EC2 instance to create MySQL dumps, transfer to Amazon S3, and implement an S3 Lifecycle policy to meet the retention requirement.
• D) Use AWS Lambda to schedule a daily manual snapshot of the DB instances. Delete snapshots that exceed the retention requirement.

---

Definitions:

FICA Taxes

FICA Taxes are payroll taxes collected to fund the Social Security and Medicare programs, split between the employer and the employee.

Payroll Tax Expense

The taxes that employers are required to withhold and pay on behalf of their employees, including Social Security and Medicare taxes.

State Unemployment Taxes

Taxes paid by employers to the state to fund unemployment insurance programs for workers who have lost their jobs.

Federal Unemployment Taxes

Taxes imposed by the federal government on employers to fund unemployment benefits for workers who have lost their jobs.