YOU ARE A PART-TIME DATABASE ADMINISTRATOR FOR A SMALL COMPANY THA...

18. You are a part-time database administrator for a small company that relies on its 3GB database for all business needs. Unfortunately, disk space is at a premium and recovery model for this database is set to SIMPLE. What should you do to protect the database so that their maximum data loss objective of 12 hours is met? What should you tell the company’s owner about the risks of having their primary business database set to a SIMPLE recovery model (choose all that apply)?A. Perform a full backup every 12 hours. Explain that the SIMPLE recovery model means that should you lose the database due to hardware failure or corruption, you will not be able to recover any transactions that have happened after the last full backup.B. Perform a full backup every day and an incremental log file backup every 12 hours. Explain that the SIMPLE recovery model means that should you lose the database due to hardware failure or corruption, you will not be able to recover any transactions that have happened after the last incre-mental log file backup.C. Perform a full backup every day and a differential backup every 12 hours. Explain that the SIMPLE recovery model means that should you lose the database due to hardware failure or corruption, you will not be able to recover any transactions that have happened after the last differential backup.D. Perform a full backup every 12 hours. Explain that the SIMPLE recovery corruption, you may be able to recover all transactions that have happened after the last full backup as long as the log file is intact.