Oracle
1Z0-908 · Question #49
1Z0-908 Question #49: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-908 to reveal the answer and full explanation for question #49. The question stem and answer options stay visible for context.
Backup and Recovery
Question
You have a MySQL system with 500 GB of data that needs frequent backups. You use a mix of MyISAM and InnoDB storage engines for your data. Examine your backup requirement: - The MySQL system being backed up can never be unavailable or locked to the client applications. - The recovery from the backup must work on any system. - Only 1 hour of data can be lost on recovery of the backup. Which option fulfills all backup requirements?
Options
- ATake a physical backup of the MySQL system.
- BUse the Clone Plugin to copy the data to another MySQL system.
- CTake a logical backup of the MySQL system.
- DTake your backup from a slave of the MySQL system.
Unlock 1Z0-908 to see the answer
You've previewed enough free 1Z0-908 questions. Unlock 1Z0-908 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#Logical Backups#Backup Availability#Point-in-Time Recovery#Storage Engine Compatibility